Page 1 of 1
Enable FTS in SQLite
Posted: Wed Dec 03, 2025 2:49 pm
by 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.
Re: Enable FTS in SQLite
Posted: Wed Dec 03, 2025 4:15 pm
by 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
Re: Enable FTS in SQLite
Posted: Wed Dec 03, 2025 5:44 pm
by mrbungle
Great, it might be how I attempted to access it. Good to know.