Clickframes

SQLite’s file-based database is an ideal match for Clickframes-PHP, so I took some time to figure out how to SQLite3 in CodeIgniter.

I quickly found this PDO SQLite3 driver on the CodeIgniter wiki, and then found these fixes in the forum.

I’ve combined the two, cleaned up the code a little, improved the log messages, and posted it on the Clickframes-PHP Google Code site.

Here’s how to set up CodeIgniter to use SQLite3 with Clickframes-PHP, assuming your core CodeIgniter files are installed at BASEPATH (your “system” folder), and your application is installed at APPPATH.

1. Download the driver ZIP and expand it into BASEPATH/database/drivers. This will create a subdirectory called pdo_sqlite.
2. Make sure PHP has SQLite3 PDO support enabled. Open php.ini and uncomment the line with extension=php_pdo_sqlite.dll and restart your web server.
3. The database configuration file generated by Clickframes-PHP at APPPATH/config/database.php enables the pdo_sqlite database driver by default, and expects your database file to live at APPPATH/db/database.sqlite. Change the file path if you prefer your database file elsewhere.

Use the database creation script generated by Clickframes-PHP in src/main/sql/sqlite to create/recreate your database. Sqliteman is a decent (and free) database management GUI tool for running the scripts.