Small. Fast. Reliable.
Choose any three.

Page History

Turn Off History

  1. If you already have SQLite installed on your computer, move or rename /usr/local/lib/libsqlite* to something else so the new DBD::SQLite install is forced to use its own source.
  2. Download Audrey Tang's most excellent DBD::SQLite::Amalgamation-3.5.6 from CPAN.
  3. Edit Makefile.PL. Add the flag -DSQLITE_ENABLE_FTS3=1 to the 'DEFINE' key at line 135. I just added it right at the beginning. So, my 'DEFINE' key now looks like
    'DEFINE' => "-DSQLITE_ENABLE_FTS3=1 -DSQLITE_CORE -DNDEBUG=1 -DSQLITE_PTR_SZ=$Config{ptrsize}" .
  4. perl Makefile.PL
  5. make && sudo make install
  6. Download the latest SQLite amalgamation from the mothership.
  7. run the following command in the src directory
    CFLAGS="-Os -DSQLITE_ENABLE_FTS3=1" ./configure
  8. make && sudo make install
email me at punkish eidesis org if further help is needed.