SQLite's full text search engine offers a simple query syntax (with
OR operators and
-term for negation), as well as an enhanced query syntax which also allows parenthesis and
NEAR — as well as using
NOT instead of the
The enhanced query syntax is enabled by setting the SQLITE_ENABLE_FTS3_PARENTHESIS option at compile time, and sqlite as distributed by Red Hat does not have this enabled.
I have a python web app where I'd prefer to use the enhanced search syntax.
What's the best way to do this? Since the syntax is incompatible, rebuilding the system sqlite might break other things. But I'd prefer not to end up in a whole world of maintaining a parallel python tree. What's the best approach?