SQLite Database Integration
SQLite Database Integration
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
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.
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.
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.
Contributions are always welcome! Learn more about how to get involved in the Core Performance Team Handbook.
Reviews
Works great on my low-traffic site
By 
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.
Util para crear sitios de desarrollo
By 
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.
Great, seems only one step away ...
By 
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?
First start
By 
I added this plugin. WordPress warned me that it would be reinstalled. But now everything is gone.) Will it come back, hopefully?
Great Plugin! Makes WP so fast!
By 
Thank you dev team for providing this plugin !
Excellent!
By 
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!
Working Fine for Me
By 
Great start to a well needed SQLite option.
Installation was smooth for a fresh installation with no content. Using PHP 8.2 and WordPress 6.6.
Thank you, team for sharing and getting this into production.
سایتی بدون تنظیمات دیتابیس
By 
با این افزونه در واقع سایت شما قلمبه کپی میشه و همه جا منتقل میشه و کار می کنه بدون اینکه نیازی به ساخت و تنظیم دیتابیس باشه. همه چیز در یک فایل کنار فایل های وردپرس ذخیره میشه
Excelente idea
By 
una gran idea
Requiring PDO_SQLITE is WRONG !
By 
I consider the fact that the coders of this module require the presence of the PDO_SQLITE module on the server, to be wrong.
Why not simply use the native sqlite module, which is not tied to PDO ?
What's wrong with that one ?
On a regular shared hosting, having PDO_SQLITE turned on can be a PITA, while the "regular" sqlite extension is almost always present, so why not use that one ?
I'm just sayin...