| Subject | Re: [firebird-support] google type search of a VARCHAR field |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-05-14T04:12:52Z |
At 11:46 AM 14/05/2009, you wrote:
Plug-in search engines are on the drawing board for Firebird 3.something. That trial might be something to wet your feet. ;-) Meanwhile, if you're looking for client-side searching tools, please ask on the firebird-tools list.
Tip: If your software is built using IBObjects, it has facilities for building FTS directly into your database.
^ heLen
>Hi, We have a table with a list of 900,000 descriptions for different items.Not as fuzzy as Google, but have you tried out the Sphinx implementation that Vlad Khorsun and Pierre Yager did last year? You can link to its download page from the "Currently Testing" spot on the main Firebird website. AFAIR, Vlad built the Windows binary on a Firebird 2.1 beta.
>
>We want the user to be able to enter a string value and a result set come back with matching descriptions in the same way google does.
Plug-in search engines are on the drawing board for Firebird 3.something. That trial might be something to wet your feet. ;-) Meanwhile, if you're looking for client-side searching tools, please ask on the firebird-tools list.
Tip: If your software is built using IBObjects, it has facilities for building FTS directly into your database.
^ heLen