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.