Re: Postgresql.org search engine. - Mailing list pgsql-www

From Oleg Bartunov
Subject Re: Postgresql.org search engine.
Date
Msg-id Pine.GSO.4.58.0401302251560.19778@ra.sai.msu.su
Whole thread Raw
In response to Re: Postgresql.org search engine.  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: Postgresql.org search engine.  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-www
On Fri, 30 Jan 2004, Dave Page wrote:

>
>
> > -----Original Message-----
> > From: Oleg Bartunov [mailto:oleg@sai.msu.su]
> > Sent: 30 January 2004 18:50
> > To: Dave Page
> > Cc: pgsql-www@postgresql.org
> > Subject: RE: [pgsql-www] Postgresql.org search engine.
> >
> >
> > I don't have an experience with aspseek, but one desirable
> > feature - spelling support for user's query. Does aspseek has
> > support for this ?
>
> You mean like Googles speeling corektor?
> (http://labs.google.com/britney.html). No, ASPSeek doesn't have this,
> however I wonder how hard it might be to knock something up based on
> ispell and soundex... Hmmmmm....

In principle, simple corrector could be implemented independent from
aspseek. If you have some dictionary of words, create trigrams of these
words, if query returns too many results create trigram of words in the
query and check which words from dictionary are close, i.e. compute
similarity weights (jaccard coefficents would be ok). More complex
algorithm we use in www.pgsql.ru and in our contrib/trgm

soundex, metaphone are good for english, while trigrams method is
universal.

>
> > Design suggestion: I'd like to see most important parts of
> > form at left side, for example, site selector, imho, better
> > to have left most, then grouping, format, number results per page.
>
> Yup, agreed.
>
> > Also, I don't like fixed width, in my browser I have to
> > scroll left-right to see a whole form :)
>
> The whole site is designed that way at the moment, but the new
> multilanguage version that's in development will be sizable. I hope to
> update the archives to a similar design at some point as well, just as
> soon as I've persuaded Marc that it's worth regenerating the messages
> again!

 Why not have fully dynamic pages for mailing lists ?  Proper configured
server with cacheing could be very fast.

>
> Regards, Dave.
>

    Regards,
        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

pgsql-www by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Postgresql.org search engine.
Next
From: "Dave Page"
Date:
Subject: Re: Postgresql.org search engine.