SQLite wrapper for Nucleus

With this tool, SQLite can be used as the database engine instead of MySQL. The SQL query for MySQL is translated for SQLite, so most of plugins can be directly used without manual modification of plugin.

(Japanese)

• How to install SQLite-Nucleus is almost the same as that of original Nucleus, but please note following things:

1. SQLite does not use the user/password, so these settings are not required.
2. A file, ”.dbsqlite” in directory, “nucleus/sqlite/” will be created after installing. This file contains the data of database. Set the permission of “nucleus/sqlite/” to be writable, for example 777.

• Nucleus can be installed by accessing to install.php by blowser. After installing, NP_SQLite mush be also installed in addition to NP_SkinFiles. If not, install this plugin manually.

• The file, “nucleus/sqlite/.dbsqlite” contains all important data. Be sure that this file cannot be read by someone else. The directory contains an ”.htaccess” file to protect itself, however, this way may not work in some environment. Therefore, confirm that the “nucleus/sqlite/.dbsqlite” cannot be accessed by blowser after installing Nucleus (the access must be forbidden).
• If you can access to “nucleus/sqlite/.dbsqlite” by browser, it must be hidden by another way. When this file is placed in the other directory, set the full path in “sqliteconfig.php” like “$SQLITECONF['DBFILENAME']='/home/yourname/.dbsqlite';”.

• Almost the same as that of original Nucleus.

• It is same as for the original Nucleus, but following tips may avoid the possible troubles that are specific to SQLite version.

• To start anything, make a back-up of database. Downloading the file “nucleus/sqlite/.dbsqlite” by FTP is the easiest and best way.

• Upload the required files to server for the upgrading.

• Go to NP_SQLite admin page and execute “VACUUM”. This will optimize the SQL tables.

• If you use SQLite 2.8, execute “PRAGMA default_synchronous = OFF;” on NP_SQLite admin page. This will increase the script speed during the upgrading steps. It is not needed if you use SQLite 3.

• Execute the upgrade scripts by accessing “nucleus/upgrades/”.

• Finally, execute “PRAGMA default_synchronous = OFF;” on NP_SQLite admin page if you use SQLite 2.8.

• Almost the same as that of original Nucleus. If the permissions of PHP files are set to be writable, the required modification of these PHP files will be automatically done by NP_SQLite.
• Some plugins requires only overwriting of PHP file during the upgrade. In this case, go to NP_SQLite management page and select “Check Plugin”. Otherwise, the upgraded plugin may not correctly work.

• 'Allow SQL query during the management?' If it's set to “yes”, SQL query is available in the management page.
• 'Number of SQL queries at once when DB restore.' 'Wating time (seconds) when DB restore.'　The settings used when the DB-restore.

• Vacuum, integrity-check, and other SQLite management things are available in NP_SQLite management page.

• Not bug: this tool does not support a few plugins. In such case, the plugin must be manually modified. Or, ask the author to release a fixed version of SQLite wrapper.

• Version 0.77 beta, released on 2006-10-23
  • Probably the last beta version.
• Version 0.8.0, released on 2006-10-29
  • The first established version.
• Nucleus 3.24 / SQLite 0.8.0, released on 2006-11-17
• Nucleus 3.3 / SQLite 0.8.5 released (when??)
• Nucleus 3.32 / SQLite 0.9.0, released on 2008-02-06