Which full-text search package should I use for SQLite3?

Posted by Benjamin Pollack on Stack Overflow See other posts from Stack Overflow or by Benjamin Pollack
Published on 2009-08-10T21:15:59Z Indexed on 2010/04/15 1:43 UTC
Read the original article Hit count: 380

Filed under:
|

SQLite3 appears to come with three different full-text search engines, called FTS1, FTS2, and FTS3. The documentation available on the website mentions that FTS1 is stable, FTS2 is in development, and that you should use FTS2. Examples I find online use FTS3, which is in CVS, and not documented versus FTS2. None of the full-text search engines come with the amalgamated source, as near as I can tell.

So, my question: which of these three engines, if any, should I use for full-text indexing in SQLite? Or should I simply use a third-party tool like Sphinx, or a custom solution in Lucene, instead?

© Stack Overflow or respective owner

Related posts about sqlite3

Related posts about full-text-search