DEV Community

Cover image for WordPress on steroids
Stokry
Stokry

Posted on

WordPress on steroids

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');
Enter fullscreen mode Exit fullscreen mode

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');
Enter fullscreen mode Exit fullscreen mode

You can try and see how everything works on a link WP-SQLite

Thanks.

Discussion (0)