WordPress.org

Ari Stathopoulos

Adam Zieliński

Bero

Brandon Payton

Jan Jakeš

zaerl

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

Nawawi Jamili

<p>Docket Cache is a persistent WordPress Object Cache that stores cached data as plain PHP code. It is designed as an alternative for sites that do not have access to Redis or Memcached.</p>
<p>Most file-based caching plugins use <a href="https://www.php.net/manual/en/function.serialize.php" rel="nofollow ugc">serializing</a> and <a href="https://www.php.net/manual/en/function.unserialize.php" rel="nofollow ugc">unserializing</a> to save PHP objects to flat files. Docket Cache takes a different approach by converting objects into plain PHP code. This makes data retrieval faster and improves overall performance, especially when Zend OPcache is enabled.</p>
<p>For more information, please refer to the documentation on <a href="https://docs.docketcache.com/resources/caching-in-wordpress" rel="nofollow ugc">Caching In WordPress</a>.</p>
<h3>Why use this plugin?</h3>
<p>For reliable persistent Object Cache in WordPress, <a href="https://redis.io/" rel="nofollow ugc">Redis</a> or <a href="https://memcached.org/" rel="nofollow ugc">Memcached</a> are the top choices. However, they require server knowledge and are rarely available on low-cost or shared hosting plans.</p>
<p>The alternative is to store object caches in files. In WordPress, exporting PHP objects is not straightforward. Most file-based caching plugins rely on serialising and unserialising objects to store and retrieve data.</p>
<p>Docket Cache takes a better approach by turning the object cache into plain PHP code. This is faster because WordPress can use the cache directly without additional processing.</p>
<h3>Features</h3>
<ul>
<li>Object caching + OPcache</li>
<li>Advanced Post Caching</li>
<li>Object Cache Precaching</li>
<li>WordPress Menu Caching</li>
<li>WordPress Translation Caching</li>
<li>WordPress Core Query Optimisation</li>
<li>Term Count Queries Optimisation</li>
<li>Post, Page, Comment Count Optimisation</li>
<li>Database Tables Optimisation</li>
<li>WooCommerce Optimisation</li>
<li>WP Options Autoload suspension</li>
<li>Post Missed Schedule Tweaks</li>
<li>Object Cache + OPcache Stats + OPcache Viewer</li>
<li>Cache Log</li>
<li>Cronbot Service</li>
<li>WP-CLI support</li>
<li>Multisite / Multi-Network support</li>
</ul>
<h3>Requirements</h3>
<p>To use Docket Cache requires minimum:</p>
<ul>
<li>PHP 7.2.5</li>
<li>WordPress 5.4</li>
<li>Zend OPcache</li>
</ul>
<h3>Documentation</h3>
<p>For configuration options, installation guides, and command-line usage, please refer to the <a href="https://docs.docketcache.com" rel="nofollow ugc">Documentation</a>.</p>
<h3>Development</h3>
<ul>
<li><a href="https://github.com/nawawi/docket-cache/" rel="nofollow ugc">GitHub Repository</a> — Source code and development hub for Docket Cache.</li>
<li><a href="https://raw.githubusercontent.com/nawawi/docket-cache/master/changelog.txt" rel="nofollow ugc">Changelog</a> — Full history of changes, fixes, and improvements.</li>
<li><a href="https://github.com/ghostbirdme/gapo" rel="nofollow ugc">Gapo Tunnel</a> — Expose local services to the internet through secure tunnels. Useful for testing Docket Cache on a local development environment.</li>
</ul>
<h3>Sponsor This Project</h3>
<p>Support the ongoing development of Docket Cache with a <a href="https://docketcache.com/sponsorship/?utm_source=wp-readme&utm_campaign=sponsor-uri&utm_medium=wporg" rel="nofollow ugc">one-off or recurring contribution</a>.</p>
<p><strong>Noteworthy Sponsors:</strong></p>
<p>A heartfelt thanks and appreciation.</p>
<ul>
<li><a href="https://jimathosting.com/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">Jimat Hosting</a></li>
<li><a href="https://www.themecloud.io/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">Themecloud</a></li>
<li><a href="https://websavers.ca/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">Websavers Inc</a></li>
<li><a href="https://avu.nu/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">Avunu LLC</a></li>
<li><a href="https://linqru.jp/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">Linqru</a></li>
<li><a href="https://www.gentlemansguru.com/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">Gentleman’s Guru</a></li>
<li><a href="https://www.securepay.my/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">SecurePay</a></li>
<li><a href="https://dnsvault.net/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">DNSVault</a></li>
<li><a href="https://exnano.io/?utm_source=docketcache&utm_campaign=plugin-uri&utm_medium=wporg" rel="nofollow ugc">Exnano Creative</a></li>
</ul>
<p>Other sponsors are mentioned in the <a href="https://github.com/nawawi/docket-cache/issues/5" rel="nofollow ugc">honourable list</a></p>


Docket Cache – Object Cache Accelerator

I have installed the plugin and enable Opcache. It just works and will always be my must installed plugins for every WordPress installation!

It just works!

It greatly reduces the RAM consumption of WordPress

The best solution to reduce RAM consumption and reduce WordPress resource consumption
Very efficient

BEST BEST BEST


Works flawless, really simple way to test object cache locally when developing, without needing to setup memchache or redis or similar.


Easy to use and setup

Speed up your WordPress site with a persistent object cache, powered by OPcache. An efficient alternative to Redis and Memcached.

SQLite Database Integration vs Docket Cache – Object Cache Accelerator