WordPress with SQLite

WordPress is a free open source CMS (Content Management System) written in PHP and uses MySQL, WordPress is one of the most popular CMS, It does not support any other database other than MySQL, Due to a lack of support for any other Database, It sometimes turn into a problem when the user want to have WordPress installed but does not have MySQL database for various reasons sometimes the Web Server is not powerful enough to handle MySQL or the hosting service does not offer MySQL in certain plans. Certain hosting service run the MySQL database in a separate data center which can sometimes be slow to fetch the data or might slow the WordPress system completely on higher traffic.

However a WordPress plugin developer kjmtsh developed a plugin SQLite Integration which lets you run WordPress with Sqlite, a file based alternative to MySQL which is faster, consumes lesser system resource. So now you can run WordPress with Sqlite. _I have tried this plugin with a fresh WordPress install and did not try to migrate an existing MySQL based WordPress install. So I don’t recommend trying it on a existing WordPress install with MySQL.

Getting started

First grab a copy of WordPress from here and expand the files in into Web root or wherever you website source is stored.

Now get the Sqlite integration plugin from here and expand the files.

Now place the Sqlite integration plugin folder in your wp-content/plugins directory.

Copy the db.php file found in the sqlite-integration folder to wordpress/wp-content folder.

Rename wordpress/wp-config-sample.php to wordpress/wp-config.php.

You use these parameters to configure what the database should be named and where it should be located.

Sqlite database file name settings.

define('DB_FILE', 'your_database_name');  

Database storage directory

define('DB_DIR', '/home/youraccount/database_directory/');  

Visit your WordPress install and you should be greeted with a setup page.

You can enable the Sqlite plugin in the plugins page and visit the miscellaneous page and optimise the database every time there is a new plugin installed/removed or there is need to do a database cleanup.

optimise will drop the size of the database by only keeping the required content of posts, pages and plugins, this will improve the performance of WordPress overall.

Now you have WordPress running on Sqlite installed on your system.

If you require patches or issue tracking visit here.


I am a CG Generalist, I previously worked for a Game development studio, now doing freelance, modelling, animation, in my free time I create Stills and Animations.