[Zope] Searching: Zcatalog, what else?

[kapil thangavelu]

On Wednesday 10 April 2002 02:37 pm, Paul Winkler wrote:
> On Wed, Apr 10, 2002 at 08:39:00PM +0200, Dieter Maurer wrote:
> > Paul Winkler writes:
> >  > re. search engines in zope:
> >  > I know there's Zcatalog, but I'm curious
> >  > what my other options are for implementing searches.
> >  > Simply finding a string in the body of a document
> >  > would be great.
> >
> > "ZopeFind" does this, though not index supported and therefore quite
> > slow...
>
> No good then... I want searching to be quickish and
> I don't want it to bog down my zope.
>
> >  > For example, How would you do text search if your data is in an
> >  > SQL database?  Maintain a separate text index and update it every so
> >  > often?
> >
> > The easiest solution would be that your SQL database would support
> > text queries efficiently...
>
> Which ones do this? Anybody know offhand?

both, afaik.

for postgres look at the contrib/tsearch module.

you can check openfts.sf.net for some related info.

-kapil