Hi all, 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. 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? You can tell I'm no dba. :) -- Paul Winkler home: http://www.slinkp.com "Muppet Labs, where the future is made - today!"
Paul Winkler wrote:
Hi all,
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.
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?
If your data is in an SQL-Database you could use input forms which result in SQL-Statements "select from table where column like <dtml-var input_field>". Or you can use ZCatalog. I didn't use ZCatalog for an sql-database yet. But it works fine for python products. You can keep your index always uptodate if you call seld.index_object every time you change properties which are cataloged. Your class needs to inherit from CatalogPathAware.CatalogAware. HTH thomas
On Wed, Apr 10, 2002 at 03:26:31PM +0200, Thomas Guettler wrote:
If your data is in an SQL-Database you could use input forms which result in SQL-Statements "select from table where column like <dtml-var input_field>".
Does that support full text searches? Like if I want to find all pages which contain a certain string in the main body text?
Or you can use ZCatalog. I didn't use ZCatalog for an sql-database yet. But it works fine for python products.
Thanks...
You can keep your index always uptodate if you call seld.index_object every time you change properties which are cataloged. Your class needs to inherit from CatalogPathAware.CatalogAware.
--PW
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...
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...
Dieter
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? I think I'm limited to mysql and postgresql on my host... but might be able to install something else that runs on linux. THanks, PW
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
MySQL has full text indexing capabilities. I have not used them myself in an application though. AFAIK it does not support boolean searches tho. -Casey 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? I think I'm limited to mysql and postgresql on my host... but might be able to install something else that runs on linux.
THanks,
PW
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Thanks for all the replies, I'll check out postgres and mysql... --pw
participants (5)
-
Casey Duncan -
Dieter Maurer -
kapil thangavelu -
Paul Winkler -
Thomas Guettler