Enable FTS in SQLite

[mrbungle]

Is it possible to use sqlite3's FTS capability in PB? It is not enabled by default and some of my use cases could benefit from it. I'd like a cross-platform example if it is possible to enable it.

Thank you in advance.

[spikey]

What makes you think it isn't enabled? A quick look says to me that it is and I can't think of any obvious reasons why Fred would choose to omit it.
For me, on 6.30B4, "PRAGMA compile_options;" returns:-

Code: Select all

[15:09:40] ENABLE_FTS3
[15:09:40] ENABLE_FTS3_PARENTHESIS
[15:09:40] ENABLE_FTS4

[mrbungle]

Great, it might be how I attempted to access it. Good to know.