WordPress.org

Ari Stathopoulos

Adam Zieliński

Bero

Brandon Payton

zaerl

Jan Jakeš

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.

sh1zen

WP Optimizer improves WordPress speed, Core Web Vitals, and technical SEO with a modular toolkit. 
Enable only what you need: cache, minification, image optimization, database cleanup, update controls, security hardening, and admin customization. 
All optimizations run on your server.
WHY USING WP-Optimizer?
<ul>
<li>One plugin, full optimization workflow: performance, maintenance, security, and admin cleanup from a single panel.</li>
<li>Modular architecture: enable only the modules you need to keep resource usage low.</li>
<li>Built for real speed gains: cache, minify, media optimization, cron tuning, and browser caching work together to reduce load time.</li>
<li>Safer WordPress defaults: security and update modules help reduce attack surface and unwanted changes.</li>
<li>Easier site management: logs, diagnostics, mail logging, and dashboard widgets help you monitor and troubleshoot faster.</li>
<li>Background processing: long operations can run in background to avoid blocking admin work.</li>
<li>Multisite support.</li>
<li>Privacy-friendly: optimization runs on your server, with optional telemetry controls.</li>
<li>No subscription required.</li>
</ul>
BENEFITS
<ul>
<li>Better technical SEO through faster pages and cleaner WordPress output.</li>
<li>Potentially higher search visibility from improved performance metrics.</li>
<li>Lower page load times and better user engagement.</li>
<li>Better stability during traffic spikes.</li>
<li>Reduced bandwidth usage with optimized images and minified assets.</li>
<li>Lower disk usage with media optimization and cleanup tools.</li>
</ul>
FEATURES
WHAT WP OPTIMIZER DOES
<ul>
<li>Improves loading speed with caching, minification, compression, and smarter cron behavior.</li>
<li>Reduces page weight through image optimization and cleanup of unnecessary WordPress output.</li>
<li>Helps technical SEO with cleaner markup, better performance signals, and faster page delivery.</li>
<li>Improves reliability with database maintenance, update controls, and server tuning.</li>
<li>Adds visibility with activity logs, server info, mail logs, and admin dashboard widgets.</li>
<li>Lets you customize WordPress behavior without editing theme or core files.</li>
</ul>
MODULES INCLUDED (FULL LIST)
<ul>
<li>Activity Log: logs user/content actions and suspicious requests.</li>
<li>Cache: object, query, database and static page caching.</li>
<li>Cron Handler: centralizes scheduled jobs and cron-related module tasks.</li>
<li>Database: database cleanup, optimization and backup utilities.</li>
<li>Media: image optimization/conversion and unused media cleanup.</li>
<li>Minify: HTML, CSS and JavaScript minification.</li>
<li>Performance Monitor: request history with charts by request type and slow-request visibility.</li>
<li>Settings: global settings management (reset, import/export, restore, autosave).</li>
<li>Tracking: optional anonymous plugin usage/error telemetry controls.</li>
<li>Widget: dashboard widgets for folder size and server information.</li>
<li>WP Customizer: admin cleanup and WordPress feature toggles.</li>
<li>WP Info: full diagnostic information about WordPress/server environment.</li>
<li>WP Mail: SMTP configuration and mail logging.</li>
<li>WP Optimizer: cron tuning, server enhancements, compression and browser cache policies.</li>
<li>WP Security: WordPress and server-level hardening options.</li>
<li>WP Updates: control over core/plugin/theme update behavior.</li>
<li>
Modules Handler: internal loader/manager for module lifecycle and upgrades.
</li>
<li>
Activity Log:
<ul>
<li>WordPress activity log for users, posts and terms</li>
<li>Monitor suspicious access attempts such as XSS and SQL injection probes</li>
<li>Supports custom rule monitoring</li>
</ul>
</li>
<li>
Cache:
<ul>
<li>Advanced caching system focused on speed and low storage footprint</li>
<li>Object Caching (Memcached and Redis)</li>
<li>WordPress Query Caching</li>
<li>Database Caching</li>
<li>Static Page Caching</li>
</ul>
</li>
<li>
Database:
<ul>
<li>Backup, optimize, and maintain database tables</li>
<li>Clean up orphaned and unnecessary WordPress data</li>
</ul>
</li>
<li>
Media:
<ul>
<li>Image optimization and conversion with WebP support</li>
<li>Media leftovers cleanup tool</li>
<li>Automatic image optimization in background</li>
<li>Compatible with servers with limited PHP execution time</li>
</ul>
</li>
<li>
Server Info:
<ul>
<li>Detailed diagnostics for server, database, PHP and WordPress installation</li>
</ul>
</li>
<li>
WP Optimizer:
<ul>
<li>WordPress cron optimization</li>
<li>Server .htaccess enhancements</li>
<li>Server-side compression (GZIP, Brotli)</li>
<li>Browser cache lifetime controls</li>
</ul>
</li>
<li>
WP Updates:
<ul>
<li>Full control over WordPress core, plugin and theme updates</li>
</ul>
</li>
<li>
WP Security:
<ul>
<li>Practical WordPress and server-level hardening options</li>
</ul>
</li>
<li>
WP Mail:
<ul>
<li>Mail logging</li>
<li>Configure external SMTP server</li>
</ul>
</li>
<li>
WP Customizer:
<ul>
<li>Prevent access to WordPress dashboard for non-admin users</li>
<li>Hide Admin Bar</li>
<li>Disable Block Editor and related block features</li>
<li>Disable comments</li>
<li>Disable QuickPress, WordPress Blog and Welcome Panel</li>
<li>Fast category list filter in your editor</li>
<li>Disable WordPress sitemap, short-links, self-ping and other non-essential outputs</li>
</ul>
</li>
<li>
Minify:
<ul>
<li>HTML, JavaScript and CSS optimization on the fly</li>
</ul>
</li>
</ul>
DONATIONS
This plugin is free and always will be, but if you want to support development, you can buy me a 
beer or coffee <a href="https://www.paypal.com/donate/?business=dev.sh1zen%40outlook.it&item_name=Thank+you+in+advanced+for+the+kind+donations.+You+will+sustain+me+developing+WP-Optimizer.&currency_code=EUR" rel="nofollow ugc">here</a>.

WP Optimizer

WordPress performance optimization plugin with cache, minify, image optimization, database cleanup, security hardening and server tuning.

SQLite Database Integration vs WP Optimizer