Differences

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

sqlite3 [2008/08/01 06:37]
amatubu draft
sqlite3 [2008/12/03 06:04] (current)
amatubu this page is no longer a draft
Line 1: Line 1:
===== SQLite Version 3.xx ===== ===== SQLite Version 3.xx =====
-**Note:** This documentation is being updated for v1.1.0. +**Now POPFile is compatible with SQLite 3.x!**
- +
-**Now POPFile v1.1.0 or later is compatible with SQLite 3.x!**+
===== Quick Summary ===== ===== Quick Summary =====
Line 9: Line 7:
You can choose either version of DBD::SQLite using with POPFile v1.1.0 or later: 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::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::SQLite2 0.32 - 0.33 (SQLite2) ** needs to be installed **with** modification: +  * ** DBD::SQLite 1.x (SQLite3) ** needs to be installed without 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:** 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 database with older version (v1.0.1 or before) of POPFile. When converting the database POPFile copies the old database to a file named 'popfile.db-sqlite2' in your data folder. If you want to get back to the old version, delete 'popfile.db' and rename 'popfile.db-sqlite2' to 'popfile.db'.+**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 ==== ==== Background ====
Line 36: Line 28:
    * DBD::SQLite2 0.32 - 0.33 - This version is compatible with SQLite 2 (and with the older 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.14 - These versions are compatible with SQLite 3 (and with the current 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.+  * **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::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).     * DBD::SQLite 1.13 - This version is compatible with SQLite 3 (and with the current POPFile release).
 
sqlite3.1217565433.txt.gz · Last modified: 2008/08/01 06:37 by amatubu

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