Differences

This shows you the differences between two versions of the page.

--- sqlite3 [2008/02/08 18:49] – external edit 127.0.0.1
+++ sqlite3 [2008/12/03 06:04] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== SQLite Version 3.xx =====
-**Note:** The information presented on this page does **not** apply to POPFile users on the Windows platform who installed POPFile using the installer package. The installer sees to it that the version of SQLite included with POPFile is compatible with POPFile and installs the needed libraries in such a manner that they will not impact any other software on your system.
+**Now POPFile is compatible with SQLite 3.x!**
 ===== Quick Summary =====
-** DBD::SQLite 0.31 and before ** needs to be installed without modification (unless you tried a v1.X and have a Sqlite3 db which must be converted back).
+You can choose either version of DBD::SQLite using with POPFile v1.1.0 or later:
-** DBD::SQLite 0.32 - 0.33 ** needs to be installed **with** modification:
+  * ** DBD::SQLite 0.31 and before (SQLite2) ** needs to be installed without modification.
-Change Bayes_dbconnect from:
+  * ** 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).
-dbi:SQLite:dbname=$dbname...
+  * ** DBD::SQLite 1.x (SQLite3) ** needs to be installed without modification.
-to:
-dbi:SQLite2:dbname=$dbname...in the config file).
-(also if you tried a v1.X and have a Sqlite3 db which must be converted).
-** DBD::SQLite 1.x ** Does not work without modification of popfile (yet). It can coexist with popfile (if needed for another application) by changing popfile to DBD::SQLite2 0.33 (see above)...and allowing the other application to run with a sqlite 1.x driver.
+**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 ====
@@ Line 29: / Line 26: @@
   * **CPAN** - Several updated versions were released to CPAN;
-    * DBD::SQLite2 0.32 - 0.33 - This version is compatible with SQLite 2 (and with the current POPFile release).
+    * DBD::SQLite2 0.32 - 0.33 - This version is compatible with SQLite 2 (and with the older POPFile release).
-    * DBD::SQLite 1.00 - 1.06 - These versions are compatible with SQLite 3, but are not currently compatible with POPFile due to unresolved issues and bugs.
+    * DBD::SQLite 1.00 - 1.14 - These versions are compatible with SQLite 3 (and with the current POPFile release).
-  * **PPM** - A release was made to the Activestate Repository that added to the confusion. At this point, there is no module presently available via PPM that is compatible with SQLite 3.
+  * **PPM** - Several updated version were released to %%ActiveState%% Package Repository.
-    * DBD::SQLite 1.00 - This version is **not** the same as the CPAN version with the same version number. This version is compatible with SQLite 2, not SQLite 3. This version has not been fully tested with POPFile, but it is expected to work with the current release.
+    * 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.
 <code>   perl -MDBD::SQLite -e 'print $DBD::SQLite::VERSION'</code>
-==== Implications ====
-With the break in database file compatibility and version confusion,  we expect that users of SQLite will start seeing issues, particularly those who have installed Perl packages that use SQLite.
-  * When you upgrade any existing DBD::SQLite module from CPAN, it will upgrade to SQLite version 3 , which will then require you to convert **all** SQLite 2 databases on your machine to version 3.
-  * POPFile is not currently compatible with SQLite version 3 due to issues with DBD::SQLite 1.00 - 1.06. It is anticipated that those issues will be resolved for a later release of POPFile.
-  * In order to have both SQLite version 2 and SQLite version 3 databases in a Perl environment, you will have to install DBD::SQLite2 to handle version 2 databases, and DBD::SQLite 1.xx for version 3.
-==== Recommendation ====
-Until the POPFile developers resolve the incompatibility issues with SQLite3, we do not recommend any POPFile users use SQLite 3 for POPFile.
-If you must upgrade your Perl SQLite to version 3 due to other applications on your machine, we recommend you install DBD::SQLite2 and make the following change to your database connection string on the advanced page of the UI (or in popfile.cfg).
-Change bayes_dbconnect from:
-<code>   dbi:SQLite:dbname=$dbname</code>
-to:
-<code>   dbi:SQLite2:dbname=$dbname</code>
-Note that POPFile must be shutdown and restarted for the change to go into effect.
-==== The Future ====
-Once the dust settles and the POPFile developers have had the opportunity to fully test SQLite 3 with POPFile, we will make an orderly transition to the newer version and take care of converting your POPFile database at that time.

POPFile - Automatic Email Classification

SQLite Version 3.xx

Differences