WordPress.org

Ari Stathopoulos

Adam Zieliński

zaerl

Jan Jakeš

Bero

Brandon Payton

<p>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.</p>
<p>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>.</p>


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

<p>A <a href="https://developer.wordpress.org/reference/classes/wp_object_cache/#persistent-cache-plugins" rel="nofollow ugc">persistent object cache</a> helps your site perform well. This one uses the widely available <a href="https://www.php.net/manual/en/book.sqlite3.php" rel="nofollow ugc">SQLite3</a> extension, and optionally the <a href="https://www.php.net/manual/en/intro.igbinary.php" rel="nofollow ugc">igbinary</a> and <a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> extensions to php. Many hosting services offer those extensions, and they are easy to install on a server you control.</p>
<h4>What is this about?</h4>
<p>It’s about making your site’s web server perform better. An object cache does that by reducing the workload on your MariaDB or MySQL database. This is not a <a href="https://developer.wordpress.org/advanced-administration/performance/cache/" rel="nofollow ugc">page cache</a>; these persistent objects go into a different kind of cache. These objects aren’t chunks of web pages ready for people to view in their browsers, they are data objects for use by the WordPress software.</p>
<p><a href="https://en.wikipedia.org/wiki/Cache_(computing)" rel="nofollow ugc">Caches</a> are ubiquitous in computing, and WordPress has its own caching subsystem. Caches contain short-term copies of the results of expensive database lookups or computations, and allow software to use the copy rather than repeating the expensive operation. This plugin (like other object-caching plugins) extends WordPress’s caching subsystem to save those short-term copies from page view to page view. WordPress’s cache happens to be a <a href="https://en.wikipedia.org/wiki/Cache_(computing)#Memoization" rel="nofollow ugc">memoization</a> cache.</p>
<p>Without a persistent object cache, every WordPress page view must use your MariaDB or MySQL database server to retrieve everything about your site. When a user requests a page, WordPress starts from scratch and loads everything it needs from your database server. Only then can it deliver content to your user. With a persistent object cache, WordPress immediately loads much of the information it needs. This lightens the load on your  database server and delivers content to your users faster.</p>
<h4>Who should use this?</h4>
<p>If your site runs on a single web server machine, and that server provides the <a href="https://www.php.net/manual/en/book.sqlite3.php" rel="nofollow ugc">SQLite3</a> and <a href="https://www.php.net/manual/en/intro.igbinary.php" rel="nofollow ugc">igbinary</a> extensions to php, this plugin will almost certainly make your site work faster. And if that server provides the <a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> extension, this plugin uses it too.</p>
<p>Some hosting providers offer <a href="https://redis.io/" rel="nofollow ugc">redis</a> cache servers. If your provider offers redis, it may be a good choice. You can use it via the <a href="https://wordpress.org/plugins/redis-cache/" rel="ugc">Redis Object Cache</a> plugin. Sites using redis have one SQL database and another non-SQL storage server: redis. Other hosting providers offer <a href="https://memcached.org/" rel="nofollow ugc">memcached</a>, which has the <a href="https://wordpress.org/plugins/memcached/" rel="ugc">Memcached Object Cache</a> plugin. And some large multipurpose cache plugins, such as the <a href="https://wordpress.org/plugins/litespeed-cache/" rel="ugc">LiteSpeed Cache</a>, also offer object caching based on one of those cache server software packages.</p>
<p>The cache-server approach to object caching comes into its own when you have multiple load-balanced web server machines handling your site. SQLite doesn’t work correctly in a multiple-web-server environment.</p>
<p>But, for single-server site configurations, SQLite, possibly assisted by APCu, performs well. And the vast majority of sites are single-server.</p>
<h4>APCu</h4>
<p><a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> is an in-memory storage medium. It lets php programs, like WordPress, store data in shared memory so it’s very fast to retrieve when needed. If APCu is available on your host server, you can configure this plugin to use it. It reduces the typical cache lookup time to one-fifth or less of the SQLite lookup time, which is itself a few tens of microseconds. Performance counts, especially on busy web sites.</p>
<p>Please look at <a href="https://wordpress.org/plugins/sqlite-object-cache/#installation" rel="ugc">Installation</a> to learn how to configure this plugin to use APCu. The plugin works fast without it, and faster with it.</p>
<p>WP-CLI: Even if APCu is in use, caching with SQLite is necessary when your web site uses WP-CLI, because WP-CLI programs do not have access to the APCu cache. This plugin writes all cached data both to APCu and to SQLite and makes sure the two are synchronized.</p>
<h4>WP-CLI</h4>
<p>You can control this plugin via WP-CLI once you activate it. Please type this command into your shell for details.</p>
<pre><code>wp help sqlite-object-cache
</code></pre>
<h4>Credits</h4>
<p>Thanks to <a href="https://profiles.wordpress.org/tillkruess/" rel="nofollow ugc">Till Krüss</a>. His <a href="https://wordpress.org/plugins/redis-cache/" rel="ugc">Redis Object Cache</a> plugin serves as a model for this one. And thanks to <a href="https://profiles.wordpress.org/aristath/" rel="nofollow ugc">Ari Stathopoulos</a> and <a href="https://profiles.wordpress.org/spacedmonkey/" rel="nofollow ugc">Jonny Harris</a> for reviewing this. Props to Matt Jones for finding and fixing a bug that appeared on a heavily loaded system. Thanks to <a href="https://speedable.net/about-us/" rel="nofollow ugc">Massimo Villa</a> for testing help, and to <a href="https://github.com/nickchomey" rel="nofollow ugc">nickchomey</a> for a comprehensive code review. All defects are, of course, entirely the author’s responsibility.</p>
<p>And thanks to Jetbrains for the use of their software development tools, especially <a href="https://www.jetbrains.com/phpstorm/" rel="nofollow ugc">PhpStorm</a>. It’s hard to imagine how a plugin like this one could be developed without PhpStorm’s tools for exploring epic code bases like WordPress’s.</p>
<h4>How can I learn more about making my WordPress site more efficient?</h4>
<p>We 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>.</p>


SQLite Object Cache


This is the plugin, the community of shared-hosting users have waited for without even knowing it.



Thanks to @ollijones the plugin author for making this possible and also for tagging it a community-plugin and doing friendly support here on the forum as well.



Great!


Great Plugin & friendly and fast support


Thanks Ollie for this great plugin!



I use this in conjunction with your other plugin Index WP MySQL For Speed and have installed these on quite a lot of websites with great success. Each and every one has increased speed.



It is faster and it feels faster and that's all the client cares about 🎉


5 star plugin. Speed increasement does not go unnoticed.


Honestly I was skeptical at first because of the low number of installs, but given the lack of options for object caching on a lot of shared hosting services that I cant control with a lot of client sites I decided to give it a shot on a few.  



This plugin is amazing, it helped turn a 15 second load on back end page edits into 3-4 seconds on a plugin heavy site running on an overpopulated shared host that I wont name here, but it was honestly awful, one of the worst I've ever used and a surprisingly big name.  I was brought in to try and optimize a monster on this occasion and it helped me turn it into some form of a workhorse again for my client, with almost no setup, toggled a checkbox or two and clicked save.   



This plugin needs more downloads, there are so many sites running on garbage hosting that could use this to make the back end a working environment again.



I will be using this on any site where I do not have redis or memcache available from here on out, cheers to the developer, you are an true WP Wizard.


Absolutely Brilliant


When no Memcached, no Redis available, this is the obvious solution.


Just what I was looking for

Amazing

great project!

A fast persistent object cache backend for the rest of us, powered by SQLite and accelerated by APCu

SQLite Database Integration vs SQLite Object Cache