WordPress.org

Ari Stathopoulos

Adam Zieliński

Bero

Brandon Payton

Jan Jakeš

zaerl

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 <a href="https://github.com/phpmyadmin/sql-parser" rel="nofollow ugc">GitHub</a>.

SQLite Database Integration



Installed version 2.0



Activated



Message: "All checks completed successfully, your site can use an SQLite database. You can proceed with the installation."



Screen with text and button. Ok, I can go back by just deactivating this plugin! Great!



Clicked button "Install SQLite database"



"PDO Driver for SQLite is missing" alone on an blank page, wheverer I go



Stuck. My somewhat "well crafted" and sophisticated testing site gone away, it seemed. 




Why could this plugin not check the availability of this driver before presenting a clickable button, or even proceeding?



Since I'm knowledgable enough to delete the ´wp-content/db.php´ file I was soon back to start, so I don't need help.



Others, if less knowledable in WP, should be warned and stay away until proper tests can be made before proceeding. On screen instructions on how to manually disable it in an emergency should also be given.


Possibly worst UX trap I have ever seen


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!


Excellent!


Thank you dev team for providing this plugin !


Great Plugin! Makes WP so fast!


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?


Great, seems only one step away ...

SQLite integration plugin by the WordPress Team.

Kirtikumar Solanki

SmartPro Database Optimiser & Cleaner helps you maintain a faster, cleaner, and more efficient WordPress website by removing unnecessary database clutter and optimizing all database tables. 
It features a beautiful modern interface, one-click actions, real-time item counts, and AJAX-powered cleaning for a seamless experience.
This tool also includes an integrated full database backup system, allowing you to download your entire WordPress database in <code>.sql</code> format before cleaning.
No technical skills required — simply open Tools → SmartPro Database Optimiser & Cleaner, click “Clean”, and enjoy improved performance instantly.
<h3>🚀 Key Benefits</h3>
<ul>
<li>Faster database performance </li>
<li>Reduced storage usage </li>
<li>Ability to safely back up your WordPress database </li>
<li>Clean, modern, user-friendly UI </li>
<li>No page reloads (AJAX-based) </li>
<li>Safe queries using <code>$wpdb</code> </li>
<li>No bloat, lightweight, and optimized </li>
</ul>
<h3>🧹 Cleanup Features</h3>
Clean up unnecessary and unused database entries with a single click:
<ul>
<li>Remove post revisions</li>
<li>Delete auto-saved drafts</li>
<li>Remove trashed posts and trashed pages</li>
<li>Clean spam and trashed comments</li>
<li>Remove expired transients</li>
<li>Delete all transients</li>
<li>Remove orphaned post meta</li>
<li>Remove orphaned comment meta</li>
<li>Delete orphaned user meta</li>
<li>Remove unused tags</li>
<li>Delete empty taxonomy terms</li>
<li>Optimize all WordPress tables</li>
</ul>
Each cleanup item displays: 
– Real-time items count 
– Action button 
– Instant results message
Also includes: 
– Clean All button 
– Refresh Counts button
<h3>🛢️ Database Backup Features</h3>
Before cleaning, download your full database for safety.
<ul>
<li>One-click SQL backup download</li>
<li>Shows total database size</li>
<li>Backups stored in: 
 /wp-content/uploads/smartpro-database-optimiser-cleaner/</li>
<li>Backup is generated safely using WordPress standards</li>
</ul>
<h3>🗂️ Database Table Optimization</h3>
From the Optimize Tables tab, you can:
<ul>
<li>View every database table </li>
<li>See table size, index size, total size, row count </li>
<li>Optimize each table individually </li>
<li>Or use Optimize All Tables</li>
</ul>
All database optimization is handled using safe, built-in SQL operations.
<h3>🖥️ Smart, Modern UI</h3>
The plugin includes a clean and intuitive interface:
<ul>
<li>AJAX-powered actions </li>
<li>Smooth progress indicators </li>
<li>Live counts </li>
<li>Field-based table listing </li>
<li>Fully responsive design </li>
<li>Admin-friendly layout </li>
</ul>
<h3>🔒 Security & Permissions</h3>
<ul>
<li>Nonce-protected AJAX requests </li>
<li>Sanitized inputs </li>
<li>Works only for administrators </li>
<li>No risky SQL execution </li>
<li>Follows strict WordPress coding standards</li>
</ul>

SmartPro Database Optimiser & Cleaner

Smart, lightweight tool to clean, optimize, and back up your WordPress database for better speed and performance.

SQLite Database Integration vs SmartPro Database Optimiser & Cleaner