Indexing an SQL database (or part of one)
Via Glen Newton, LuSql, a "command line Java application that can be used to build a Lucene index from an arbitrary SQL query of a JDBC-accessible SQL database".
I've often thought about writing something similar for Minion, but Glen appears to have done a remarkably thorough job for Lucene. A 40 page user manual? That's impressive. It's Apache Licensed, so I suppose I could port it to use Minion as the indexing engine...
Hi Stephen,
The next version of LuSql has been re-architected and has plugins for both the source and the sink, as opposed to having a hard wired JDBC source and Lucene sink, as it is now. One of the sinks I will be creating for the release is a Minion sink, so JDBC-to-Minion will be possible (other sinks: Berkeley DB, JDBC, Terrier, XML, text; other sources: SparQl end point, Lucene, Minion, Terrier, Berkeley DB).
This next version will be out in 3-4 weeks (updating the docs will take more time than finishing the software!! :-) ) and I will let you know when it is released.
-Glen
Posted by Glen Newton on March 09, 2009 at 10:37 AM EDT #