1

Enable sqlite FTS Enhanced Query Syntax in python in RHEL6?

view story
linux-howto

http://unix.stackexchange.com – SQLite's full text search engine offers a simple query syntax (with AND and 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 -term syntax. 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 (HowTos)