Thread: Re: [pgsql-advocacy] New PostgreSQL search resource

Re: [pgsql-advocacy] New PostgreSQL search resource

From
"Dave Page"
Date:

> -----Original Message-----
> From: Marc G. Fournier [mailto:scrappy@postgresql.org]
> Sent: 17 January 2004 03:52
> To: Robert Treat
> Cc: pgsql-www@postgresql.org; Joshua D. Drake
> Subject: Re: [pgsql-www] [pgsql-advocacy] New PostgreSQL
> search resource
>
> On Fri, 16 Jan 2004, Robert Treat wrote:
>
> > Ok, this is now the second site that has come to be in the last few
> > days that is using FTS and Tsearch for site search, and providing
> > something that seems a lot better than the search available on the
> > main website... what is stopping us from implementing this
> and dumping
> > mnogosearch?  at least for the main site if not for the archives?
>
> actually, Dave is working on an improved search ... but, Oleg
> just announced a crawler using tsearch that I'm going to take
> a look at implementing as well ...

That was going to be my next experiment should the current one not work
out!

The only other potential solution I've found so far is ASPSeek
(http://www.aspseek.org/) which claims to be efficient for massive
searches, but that's MySQL/Oracle only, so unless we can write a
PostgreSQL interface for it that's out. (mind you, I took a quick look
and it looks like all the db stuff is abstracted out into a single file
for each db so that might not be too difficult).

Regards, Dave.

Re: [pgsql-advocacy] New PostgreSQL search resource

From
Robert Treat
Date:
On Saturday 17 January 2004 04:48, Dave Page wrote:
> > -----Original Message-----
> > From: Marc G. Fournier [mailto:scrappy@postgresql.org]
> > Sent: 17 January 2004 03:52
> > To: Robert Treat
> > Cc: pgsql-www@postgresql.org; Joshua D. Drake
> > Subject: Re: [pgsql-www] [pgsql-advocacy] New PostgreSQL
> > search resource
> >
> > On Fri, 16 Jan 2004, Robert Treat wrote:
> > > Ok, this is now the second site that has come to be in the last few
> > > days that is using FTS and Tsearch for site search, and providing
> > > something that seems a lot better than the search available on the
> > > main website... what is stopping us from implementing this
> >
> > and dumping
> >
> > > mnogosearch?  at least for the main site if not for the archives?
> >
> > actually, Dave is working on an improved search ... but, Oleg
> > just announced a crawler using tsearch that I'm going to take
> > a look at implementing as well ...
>
> That was going to be my next experiment should the current one not work
> out!
>
> The only other potential solution I've found so far is ASPSeek
> (http://www.aspseek.org/) which claims to be efficient for massive
> searches, but that's MySQL/Oracle only, so unless we can write a
> PostgreSQL interface for it that's out. (mind you, I took a quick look
> and it looks like all the db stuff is abstracted out into a single file
> for each db so that might not be too difficult).
>

ho ha! i've been looking at that too, and i've talked with someone on irc that
already has it running on postgresql too.  check out his site:
http://search.oztralis.com.au/Top.htm, I'm sure he'd be willing to help out
if you want.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL