On Dec 15, 2004, at 6:11 PM, Chuck Bearden wrote:
> In my mind, searching large swaths of full-text is rather different
> than searching structured metadata, especially on controlled
> vocabulary index points. One idea that comes to mind is using either
> the Throwing Beans/PostgreSQL or eXist solutions for storage and
> XPath-based access, and creating full-text indices with Lucene....
Yep, this is my thought as well. My plan will be to write easily
indexable content to the file system and/or create a dump from my
database, and then feed this output to an indexer. My current favorite
is swish-e. Swish-e will provide all the searching functionality I
could desire. Results returned from swish-e will be either URL's
pointing to documents on the file system or to keys in the the
database. Documents on the filesystem would most likely highly
structured HTML documents. If keys are returned, then I would use the
key to extract the necessary information from the database, build some
sort of document on the fly, and return the results to the browser.
I like this sort of approach instead of querying the database directly
because querying the database directly forces me to create all sorts of
ugly SQL statements defining specific fields to query. Ick, again.