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.

OllieJones

This plugin speeds up the handling of your WordPress registered users, especially when your site has many thousands of them. (Congratulations! Building a successful site with thousands of users is an accomplishment.) With optimized MySQL / MariaDB database techniques, it finds and displays your users more quickly. Your All Users panel on your dashboard displays faster and searches faster. Your All Posts and All Pages panels no longer lag when displaying. And, you can edit your posts to change authorship more efficiently.
Without this plugin WordPress sites with many users slow down drastically on Dashboard pages. It can take many seconds each time you display your Users dashboard panel. It takes just about the same large amount of time to display your Posts or Pages panels. While those slow displays are loading, WordPress is hammering on your site’s MySQL or MariaDB database server. That means your site serves your visitors slowly too, not just your dashboard users.
And, versions of WordPress since 6.0.1 have dealt with <a href="https://make.wordpress.org/core/2022/05/02/performance-increase-for-sites-with-large-user-counts-now-also-available-on-single-site/" rel="nofollow ugc">this performance problem</a> by preventing changes to the authors of posts and pages in the Gutenberg editor, the classic editor, and the Quick Edit feature. Those recent versions also suppress the user counts shown at the top of the Users panel. This plugin restores those functions.
This plugin helps speed up the handling of those large numbers of users. It does so by indexing your users by adding metadata that’s easily optimized by MySQL or MariaDB. For example, when your site must ask the database for your post-author users, the database no longer needs to examine every user on your system. (In database jargon, it no longer needs to do notoriously slow full table scans to find users.)
When slow queries are required to make sure the metadata indexes are up to date, this plugin does them in the background so nobody has to wait for them to complete. You can set the plugin to do this background work at a particular time each day. Many people prefer to do them overnight or at some other off-peak time.
<h4>WP-CLI commands</h4>
You can use WP-CLI commands built in to this plugin.
<ul>
<li>
<code>wp index-users status</code> shows the status of user index creation.
</li>
<li>
<code>wp index-users remove</code> removes the user index information. This includes usermeta rows and options rows.
</li>
<li>
<code>wp index-users rebuild</code> rebuilds the user index information. Notice that activating the plugin always begins building the user index information.
</li>
</ul>
<h4>How can I learn more about making my WordPress site more efficient?</h4>
This is a companion plugin to <a href="https://wordpress.org/plugins/index-wp-mysql-for-speed/" rel="ugc">Index WP MySQL for Speed</a>. If that plugin is in use, this plugin will perform better. But they are in no way dependent on one another; you may use either, both, or of course neither.
I offer several plugins to help with your site’s database efficiency. You can <a href="https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/" rel="nofollow ugc">read about them here</a>.

Index WP Users For Speed

This is absolutely amazing work. I've reviewed your discussions on WP issue tracker and various other places and came to the same conclusion. While I had already added some of my own custom indexes long ago, this is even better. Fantastic job!

Amazing

It’s great to see a plugin like this created and maintained to such a high standard. Thank you Ollie

Top class

Do you have thousands of users on your WordPress site? Look them up fast. Find authors more easily. Speed up your laggy dashboard.

SQLite Database Integration vs Index WP Users For Speed