sqlite - Compiling Fts Three

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.