SQLite Database Integration

Name: SQLite Database Integration
Rating: 4.6 (12 reviews)

Par Ari Stathopoulos

Télécharger

Support

Description

The SQLite plugin is a community, feature plugin. The intent is to allow testing an SQLite integration with WordPress and gather feedback, with the goal of eventually landing it in WordPress core.

This feature plugin includes code from the PHPMyAdmin project (specifically parts of the PHPMyAdmin/sql-parser library), licensed under the GPL v2 or later. More info on the PHPMyAdmin/sql-parser library can be found on GitHub.

FAQ

What is the purpose of this plugin?

The primary purpose of the SQLite plugin is to allow testing the use of an SQLite database, with the goal to eventually land in WordPress core.

You can read the original proposal on the Make blog, as well as the call for testing for more context and useful information.

Can I use this plugin on my production site?

Per the primary purpose of the plugin (see above), it can mostly be considered a beta testing plugin. To a degree, it should be okay to use it in production. However, as with every plugin, you are doing so at your own risk.

Where can I submit my plugin feedback?

Feedback is encouraged and much appreciated, especially since this plugin is a future WordPress core feature. If you need help with troubleshooting or have a question, suggestions, or requests, you can submit them as an issue in the SQLite GitHub repository.

How can I contribute to the plugin?

Contributions are always welcome! Learn more about how to get involved in the Core Performance Team Handbook.

Does this plugin change how WordPress queries are executed?

The plugin replaces the default MySQL-based database layer with an
SQLite-backed implementation. Core WordPress code continues to use
the wpdb API, while queries are internally adapted to be compatible
with SQLite syntax and behavior.

Avis

openletter 29 juin 2025

I have no other services requiring MySQL/MariaDB, so this option saves me some memory and headache. Have been running for around one year and zero issues, but my site is very simple.

Alberto Prado 29 juin 2025

SQlite debería de ser la opción por defecto para WordPress. Es mucho más simple de administrar que mySQL y puede funcionar igual de bien. Este plugin es indispensable para crear un WordPress de desarrollo que solamente necesita PHP para iniciar el servidor sin instalar XAMPP ni otro software.

Gareth Bult 3 décembre 2024

Ok, so in terms of doing what it says in the tin, for me it looks great. I’ve set up 20 – 30 instances, it runs my core plugins and has a footprint of ~ 105M when running with a default setup. Seems to be at least as fast as the MySQL instances sat next to them. Here’s the problem tho’. It would seem I can’t actually convert any existing sites over to run on these instances without a lot of manual work. (I say this after reading the experiences of some others who claim to have tried). Are there any relatively automatic tools and/or documentation that I might have missed when it comes to migrating a MySQL instance over to SqLite (and back, in the event of a problem), or at least a Roadmap of if / when such tools or plugins might become available? A roadmap or estimation might at least (if it’s a long way away) prompt someone to get on and do it?

barbaroshh 26 novembre 2024 6 réponses

I added this plugin. Wordpress warned me that it would be reinstalled. But now everything is gone.) Will it come back, hopefully?

John Turner 28 septembre 2024 1 réponse

Thank you dev team for providing this plugin !

lucasbustamante 26 août 2024 1 réponse

I used it to spin up a test site in CI, it’s just elegant and brings WP closer to Static when we need it. There’s a place for SQLite simplicity in some WP workflows. Loved it!

Lire les 12 avis