Geek asks and answers

How to convert an existing sqlite database table to fts3?

I have a regular sqlite database and you want to use fts3. As stated at http://www.sqlite.org/fts3.html , to use this search function, you must create an FTS table.

Is there a way to convert an existing table to an FTS table?

+5
source share
1 answer

I think the solution is to populate the FTS virtual table yourself. I want to open a new stream that will be read from an existing database and then written to the FTS table.

Actually, I could find a better way, hope you are still watching this thread:

, : SQLite FTS

:

CREATE VIRTUAL TABLE , , .

+3

More articles:


All Articles