Subject Re: Full Text Search
Author Herbert Sitz
--- In firebird-support@yahoogroups.com, Flavio Costa
<flaviocosta2003@...> wrote:
>
> Hi.
>
> How can I do Full Text Search using Firebird + PHP, without doing
all the job "manually"?
>
> Is there any library or something similar to DotLucene?
>
> Flávio
>
>

Yes, there is a FastTextSearch product you'll find here:
http://www.textolution.com/ftsib_example.asp

Not sure how good it is, but it looks promising and you can try for
free and see if it works for you.

Apart from that there's the method described in the Firebird
Conference presentation that someone already linked to, as well as
Jason Wharton's method.

If you don't need to integrate the fulltext indexing with sql in the
same query then a product like Rubicon (http://www.fulltextsearch.com
) can be easily integrated with Firebird, and is full featured like
Lucene. I wonder whether there's some way to use Rubicon and then
have a selectable sproc return the list of matches to be joined to
other tables in an SQL query.