Now POPFile is compatible with SQLite 3.x!
You can choose either version of DBD::SQLite using with POPFile v1.1.0 or later:
Note: POPFile v1.1.0 or later uses DBD::SQLite 1.x (SQLite3) by default. If both DBD::SQLite2 (SQLite2) and DBD::SQLite 1.x (SQLite3) exist in your installation, POPFile will automatically convert the SQLite2 database to SQLite3 database and use DBD::SQLite 1.x. If only DBD::SQLite2 (SQLite2) exists, POPFile will continue to use DBD::SQLite2.
Note: SQLite3 databases are not compatible with SQLite2 databases. After POPFile converts the database, you cannot use the converted database with older version (v1.0.1 or before) of POPFile. When converting the database POPFile backups the old database to 'popfile.db-sqlite2' file in your data folder. If you want to get back to the old versions, delete 'popfile.db' and rename 'popfile.db-sqlite2' to 'popfile.db'.
During July 2004 SQLite Version 3 was released. This version has significant changes from SQLite Version 2 including changes to the database file format, which breaks compatibility between the two versions.
A new version of the Perl interface module to SQLite, DBD::SQLite was also released during July. Unfortunately, the release has caused some confusion due to the naming and numbering schemes that were used.
To check on the version of DBD::SQLite installed on your machine, use the following Perl one-liner.
perl -MDBD::SQLite -e 'print $DBD::SQLite::VERSION'