Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.