SQLite is a self-contained, serverless, zero-configuration, transactional SQL database engine. The SQLite website also boasts that it is the most widely deployed SQL database engine in the world. As I’ve previously discussed, SQLite has the advantage over MySQL as it can be used as an internal session handler with PHP.
Before we can start using SQLite, we need to make sure it’s installed on our system:
sudo apt-get install sqlite
And once we have SQLite installed, we need to install the PHP module for it:
sudo apt-get install php5-sqlite
You will need to restart your web server or FastCGI process manager before the module will become available. Once you’ve done so check phpinfo() and you should see the new SQLite module as part of the output.
