lucene and databases

Hi, This is a question to confirm my understanding of lucene when used along with databases and clear my doubts. Lucene can be used to read from databases(both sql and nosql) but there is no api that supports it. Is there any database that is preferred over other databases for use along with

lucene and databases

Thanks to Yonik for replying to my last question about queries and filters. Now I have another issue. I would appreciate any pointers to attempts to integrate Lucene with databases. There's a tantalizing reference to a class called JDBCDirectory mentioned at http://wiki.apache.org/jakarta-luce

Re: lucene and databases

Lucene is agnostic to how (database or not) your content is stored externally: it's up to you to pull that content out, make Documents and index them into Lucene. It is not a great idea to store a Lucene index in a database... Also, Compass essentially became Elasticsearch. Mike McCandless http

Re: lucene and databases

JDBCDirectory doesn't help you to index content in rdms. It just stores the lucene index into rdms. This approach will be slower than file system based approach. For your first question, "Indexing content that is stored in a dbms", you can take a look at DBSight. It's a generic tool to easily extr

Re: lucene and databases

Code and examples for embedding Lucene in HSQLDB and Derby relational databases: Rick Hillegas wrote: Thanks to Yonik for replying to my last question about queries and filters. Now I have another issue. I would appreciate any pointers to attem

Re: lucene and databases

Also, you can try Compass. I remember it stores the index when you use hibernate. Chris Lu -- Lucene Full-Text Search on Any Database http://www.DBSight.net On 10/24/05, Chris Lu <[EMAIL PROTECTED]> wrote: > JDBCDirectory doesn't help you to index content in rdms. > It

Re: lucene and databases

Thanks, Chris. I have a couple follow-on questions: 1) Thanks for the pointer to DBSight.net. It seems that DBSight has built some integration support for MySQL. Do you know if there are any plans to build integration support for Derby, the Apache open source database (http://db.apache.org/der

Re: lucene and databases

Thanks, Steven. This is an interesting approach which looks like it gets the user up and running pretty fast. Cheers, -Rick Steven Rowe wrote: Code and examples for embedding Lucene in HSQLDB and Derby relational databases: Rick Hillegas wro