Today I want to introduce you to a small project that I’ve decided to make as an open source.
So far, I've been developing smaller projects on the WordPress platform, and I've always looked for some lighter versions where I could be faster, so WP-SQLite was created. Simple, WordPress on the Sqltie database. SQLite has the following noticeable features: self-contained, serverless, zero-configuration, transactional. Because of the serverless architecture, you don’t need to “install” SQLite before using it. There is no server process that needs to be configured, started, and stopped.
In addition, SQLite does not use any configuration files. SQLite allows a single database connection to access multiple database files simultaneously. This brings many nice features like joining tables in different databases or copying data between databases in a single command.
SQLite is capable of creating in-memory databases that are very fast to work with.
WordPress is much faster and secure with this kind of implementation.
Installation
Grab the last source code on release page. After that, you can unzip the files and run a standard WordPress installation. Note that you need to enable pdo_mysql
and after that, you can open wp-config.php
file and replace example.com
with your url's.
define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');
Database file already exist and you can leave that file like that, or of course, you can change if you want.
define('DB_FILE', 'wpsqlite.db');
You can try and see how everything works on a link WP-SQLite
Thanks.
Top comments (0)