martinthrelly wrote:

>hello there. i am being asked to design a google-esque search facility
>which will hook up to a relational firebird database. we are porting
>our application onto the web using the firebird.net provider.
>
>i have checked out the java based dotlucene component but i am loathe
>to storing our indexes outside the database because our database will
>be constantly updated by the users so i am worried about concurrency
>issues. also some search results will require to use joins before
>displaying the info.
>
>all in all any advice would be appreciated.
>
>

take a look here:
http://www.codeproject.com/cs/database/FulltextFirebird.asp

in special at this paragraph:


Where to Store the Index

On a server, it's no problem to store the index in a separate directory
(you can also load it to RAM to make your searches super fast - if you
have enough RAM, of course). In a desktop application, it might be
useful to store the index in a Firebird database.

DotLucene supports a mechanism for adding custom index storages. All
storage types (file system and RAM are built-in) are implemented as a
class derived from Lucene.Net.Store.Directory abstract class
<http://www.dotlucene.net/documentation/api/1.4/Lucene.Net.Store.Directory.html>.
I have created a Directory
<http://www.dotlucene.net/documentation/api/1.4/Lucene.Net.Store.Directory.html>
implementation that stores the index directly in a Firebird SQL database.


Please report back I'd like to know how well it works :-)

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br