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:
And once we have SQLite installed, we need to install the PHP module for it:
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.