December 17 2022

Performance Lab Plugin pushes to add a new experimental SQLite integration module in the upcoming 1.8.0 release

WordPress and SQLite as a backend instead of the usual MySQL as an alternative for lean and unpretentious sites.

Performance Lab Plugins

The WordPress Performance Team contributors have joined a new experimental SQLite integration module which is on its way to being included in the upcoming 1.8.0 version of the plugin Performance Lab. (This is the plugin that contains a collection of feature plugins with performance-related modules that the team hopes to push into WordPress core.) The new module allows the adventurous to test out the new SQLite implementation, with the awareness that the overall user experience will continue to be rough.

SQLite is a database engine. It is software that allows users to interact with a relational database. In SQLite, a database is stored in a single file, a feature that sets it apart from other database engines. This fact allows for great accessibility: copying a database is no more complicated than copying the file that stores the data, sharing a database can mean sending an email attachment.

sqlite VS MySQL Schema

In a proposal entitled Let's make WordPress officially support SQLite Yoast-sponsored lead contributor Ari Stathopoulos argues that less complex sites (small to medium-sized sites and blogs) don't necessarily benefit from the requirement to use the standard WordPress MySQL database:

At the lower end of the WordPress user park, there are small, simple sites. These are numerous and consist of all blogs, company pages and sites that do not have thousands of users or thousands of posts, etc. These websites don't always need the intricacies of a MySQL/MariaDB database. The requirement for a dedicated MySQL server increases hosting costs and installation complexity. On low-end servers, it also reduces performance as the same "box" has to cater for both a PHP server and a MySQL/MariaDB server.

In an ideal world, users could select the database type during installation. Stathopoulos said this would require WordPress to have a database abstraction layer, which other platforms like Drupal have had for more than 10 years.

Building a database abstraction layer for WordPress would be a colossal task, although it may be one that, at some point in the future, we may need to undertake to ensure continued evolution and longevity of the project

he has declared.

Alternatively, Stathopoulos sees SQLite as a "perfect fit" and cited the benefits of using it for smaller websites:

  • It is the most used database in the world
  • It is cross-platform and can be run on any device
  • It is included by default in all PHP installations (unless explicitly disabled)
  • The minimum WordPress requirements would be a simple PHP server, without the need for a separate database server.
  • SQLite support helps reduce hosting costs, reduces power consumption, and lowers performance costs on low-end servers.

This new SQLite integration module is based on the plugin wp-db-sqlite  , a SQLite database driver drop-in also used by the WordPress Sandbox project, as WASM does not support MySQL. The wp-db-sqlite plugin was based on the original work of Kojima Toshiyasu in his SQLite Integration plugin from eight years ago , which is no longer available for download on Stathopoulos said these solutions have evolved over the years, have been thoroughly tested and proven to work flawlessly, although they are not well known among users.

Matt Mullenweg

Matt Mullenweg said in support of the proposition, so the implementation moving into the Performance Lab plugin might have a good chance of landing in core someday in the future. Most of the participants in the proposal discussion supported the idea, but also discussed some of the potential drawbacks. These include poorer support for things like multi-author editing and searching.

MySQL is and should continue to be the default because if you have aspirations to be the next big thing, then MySQL can scale better. If on the other hand you just want a blog, a company site with your about page and a contact form to have an online presence, or any kind of small site (which is probably most sites on WordPress) then SQLite is all you need. you need will ever need and will work much better.

Stathopoulos said.

Some participants in the discussion also chafed at the controversy ethical code religious that SQLite holds for its contributors. Stathopoulos sees this as a non-issue because the project is open source and the technology is widely used.

"Its popularity speaks volumes about what it can do and where it can be used“he said in response to criticism of the idea of ​​tying WordPress to a project with a questionable code of ethics.

If you've been using WordPress since the early days, you've seen it get more complicated over the years. The discussions on the idea of ​​a ” WordPress Lite have popped up every few years, but the specific selection of platform features seems to have been a big factor in WordPress which powers 43% of the web (according to W3Techs ). NerdPress founder Andrew Wilder has suggested that a SQLite implementation could benefit from being branded as “WordPress Lite".

Reading the comments and potential issues above, if this were to go forward, perhaps the way to implement this in a way that makes sense to users would be to simultaneously brand it as 'WordPress Lite' So if a site uses SQLite, there may be features that they're just not available anymore (like multiple authors or maybe plugins that have certain database requirements can't be installed).

Wilder said.

Those interested in testing the new SQLite integration module should be able to test it next week. Felix Arntz, contributor to the Google-sponsored Performance Team, provided some testing notes during yesterday's team meeting:

For the implementation of SQLite, in addition to the correct functioning of the SQLite DB alone, another crucial aspect to test is the user experience on activating the module. You'll get a completely new database, but we've added logic to make the transition as easy as possible: in a typical WordPress setup, you shouldn't need to reinstall WordPress yourself when you enable the module, and you shouldn't even need to log in again.

Basically the PR has the logic to install WordPress automatically into the new database, using the same basic configuration data that is in the regular database.

Note that this is not a migration at all. It's just the install you'll get; no content will be migrated.

Version 1.8.0 of the Performance Lab plug-in is expected on Monday, December 19 and will include the new module.

Do you have doubts? Don't know where to start? Contact us!

We have all the answers to your questions to help you make the right choice.

Chat with us

Chat directly with our presales support.


Contact us by phone during office hours 9:30 - 19:30

Contact us online

Open a request directly in the contact area.


Managed Server Srl is a leading Italian player in providing advanced GNU/Linux system solutions oriented towards high performance. With a low-cost and predictable subscription model, we ensure that our customers have access to advanced technologies in hosting, dedicated servers and cloud services. In addition to this, we offer systems consultancy on Linux systems and specialized maintenance in DBMS, IT Security, Cloud and much more. We stand out for our expertise in hosting leading Open Source CMS such as WordPress, WooCommerce, Drupal, Prestashop, Joomla, OpenCart and Magento, supported by a high-level support and consultancy service suitable for Public Administration, SMEs and any size.

Red Hat, Inc. owns the rights to Red Hat®, RHEL®, RedHat Linux®, and CentOS®; AlmaLinux™ is a trademark of AlmaLinux OS Foundation; Rocky Linux® is a registered trademark of the Rocky Linux Foundation; SUSE® is a registered trademark of SUSE LLC; Canonical Ltd. owns the rights to Ubuntu®; Software in the Public Interest, Inc. holds the rights to Debian®; Linus Torvalds holds the rights to Linux®; FreeBSD® is a registered trademark of The FreeBSD Foundation; NetBSD® is a registered trademark of The NetBSD Foundation; OpenBSD® is a registered trademark of Theo de Raadt. Oracle Corporation owns the rights to Oracle®, MySQL®, and MyRocks®; Percona® is a registered trademark of Percona LLC; MariaDB® is a registered trademark of MariaDB Corporation Ab; REDIS® is a registered trademark of Redis Labs Ltd. F5 Networks, Inc. owns the rights to NGINX® and NGINX Plus®; Varnish® is a registered trademark of Varnish Software AB. Adobe Inc. holds the rights to Magento®; PrestaShop® is a registered trademark of PrestaShop SA; OpenCart® is a registered trademark of OpenCart Limited. Automattic Inc. owns the rights to WordPress®, WooCommerce®, and JetPack®; Open Source Matters, Inc. owns the rights to Joomla®; Dries Buytaert holds the rights to Drupal®. Amazon Web Services, Inc. holds the rights to AWS®; Google LLC holds the rights to Google Cloud™ and Chrome™; Microsoft Corporation holds the rights to Microsoft®, Azure®, and Internet Explorer®; Mozilla Foundation owns the rights to Firefox®. Apache® is a registered trademark of The Apache Software Foundation; PHP® is a registered trademark of the PHP Group. CloudFlare® is a registered trademark of Cloudflare, Inc.; NETSCOUT® is a registered trademark of NETSCOUT Systems Inc.; ElasticSearch®, LogStash®, and Kibana® are registered trademarks of Elastic NV Hetzner Online GmbH owns the rights to Hetzner®; OVHcloud is a registered trademark of OVH Groupe SAS; cPanel®, LLC owns the rights to cPanel®; Plesk® is a registered trademark of Plesk International GmbH; Facebook, Inc. owns the rights to Facebook®. This site is not affiliated, sponsored or otherwise associated with any of the entities mentioned above and does not represent any of these entities in any way. All rights to the brands and product names mentioned are the property of their respective copyright holders. Any other trademarks mentioned belong to their registrants. MANAGED SERVER® is a trademark registered at European level by MANAGED SERVER SRL, Via Enzo Ferrari, 9, 62012 Civitanova Marche (MC), Italy.


Would you like to see how your WooCommerce runs on our systems without having to migrate anything? 

Enter the address of your WooCommerce site and you will get a navigable demonstration, without having to do absolutely anything and completely free.

No thanks, my customers prefer the slow site.
Back to top