On 7/11/05, Henry Miller <[EMAIL PROTECTED]> wrote: > For full text search I find the lucene/clucene > http://lucene.apache.org/ > http://sourceforge.net/projects/clucene/ > > to be good solutions. The licenses isn't quite as easy as sqlite, but > they should be good enough for everyone.
Clucene is actually written in C++. There is another project lucene4C - http://incubator.apache.org/lucene4c/ - but this too has transitioned from a completely C implementation to a wrapper over a gcj compiled java version. Using either of these implementations as a reference, it is possible to use lucene to provide all the services mentioned in this mail inside the DB itself http://www.mail-archive.com/sqlite-users@sqlite.org/msg00993.html Lucene could be used to build the column index and this index can be queried later using extensions to SQL like CONTAINS. I would like to contribute / test code for this - but before that I'd like to know if there is a good case for doing this. /Siddharth