SQLite Version 3.xx

Now POPFile is compatible with SQLite 3.x!

Quick Summary

You can choose either version of DBD::SQLite using with POPFile v1.1.0 or later:

  • DBD::SQLite 0.31 and before (SQLite2) needs to be installed without modification.
  • DBD::SQLite2 0.32 - 0.33 (SQLite2) needs to be installed with modification:
    Change Bayes_dbconnect from:
    dbi:SQLite:dbname=$dbname…
    to:
    dbi:SQLite2:dbname=$dbname…in the config file).
  • DBD::SQLite 1.x (SQLite3) needs to be installed without modification.

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'.

Background

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.

  • SQLite 3 databases are not compatible with SQLite 2 databases. SQLite 2 databases must be converted to the SQLite 3 format.
  • The command line tool for SQLite 3 has been named sqlite3 to avoid confusion. The SQLite 2 command line tool retains the name sqlite.
  • Internally, the calls and libraries for SQLite 3 all include a 3 at the end, again to avoid confusion.

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.

  • CPAN - Several updated versions were released to CPAN;
    • DBD::SQLite2 0.32 - 0.33 - This version is compatible with SQLite 2 (and with the older POPFile release).
    • DBD::SQLite 1.00 - 1.14 - These versions are compatible with SQLite 3 (and with the current POPFile release).
  • PPM - Several updated version were released to ActiveState Package Repository.
    • DBD::SQLite2 0.33 - This version is compatible with SQLite 2 (and with the older POPFile release).
    • DBD::SQLite 1.13 - This version is compatible with SQLite 3 (and with the current POPFile release).

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'
 
sqlite3.txt · Last modified: 2008/12/03 06:04 by 127.0.0.1

Should you find anything in the documentation that is incomplete, unclear, outdated or just plain wrong, please let us know and leave a note in the Documentation Forum.

Recent changes RSS feed Donate Driven by DokuWiki
The content of this wiki is protected by the GNU Fee Documentation License