How to Install the SQLite Module on Ubuntu 12.04 LTS

Josh Sherman
1 min read
Servers / Serverless PHP Debian / Ubuntu SQL
WARNING: The following post talks about an Ubuntu version that is at end of life. It's highly recommended that you upgrade your server to a newer Ubuntu version.

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.

Join the Conversation

Good stuff? Want more?

Weekly emails about technology, development, and sometimes sauerkraut.

100% Fresh, Grade A Content, Never Spam.

About Josh

Husband. Father. Pug dad. Born again Linux user. Founder of Holiday API, Backend Engineering Manager and Emoji Specialist at Mailshake (WE'RE HIRING!), and author of the best damn Lorem Ipsum Library for PHP.

Currently Reading

Pears and Perils
Antifragile: Things That Gain from Disorder
Code Girls: The Untold Story of the American Women Code Breakers of World War II

Previous Reads

Buy Me a Coffee Become a Sponsor

Related Articles