Ask Ubuntu is a question and answer site for Ubuntu users and developers. 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

I would like to have PHP with SQlite with FTS3 extension enabled, as noted in Manual:SQLite - MediaWiki.

I'm somewhat confused about FTS3 support in the default Ubuntu packages;

from Bug #229003 in sqlite3 (Ubuntu): “Build sqlite3 with fts3 fulltext search ”:

It would be great if ubuntu can ship with enabled fts3 too.

That bug seems to have been fixed in karmic, so from Issue 448 - clementine-player - Clementine 0.4 does not start - A cross-platform music player based on Amarok 1.4 - Google Project Hosting:

That's strange - all of Ubuntu's sqlite3 packages have FTS3 enabled, even 3.6.23...

... so all should be fine - however, that doesn't seem to be the case for php5-sqlite package..

So, it seems, that in order to enable FTS3 for PHP, I'd have to re-build SQlite (and possibly PHP) from source - but I was hoping there's a package-like way to use precompiled binaries (as I'd like to make an install suggestion to an administrator of a server, and compiling from source will be too troublesome). Is there?

Thanks in advance for any suggestions,

share|improve this question
up vote 0 down vote accepted

Well, I got an answer at LInux: How to install FTS3 (for sqlite3) in PHP? - Stack Overflow - and I guess, the answer is, there is no such binary package; things have to be compiled from source.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.