by
OllieJones
5 (50 reviews)
SQLite Object Cache
A fast persistent object cache backend for the rest of us, powered by SQLite and accelerated by APCu
SQLite Object Cache ranks #2,091 among WordPress.org plugins with 10,000+ active installations, is #73 of 1,518 in the Performance category, a 5/5 rating from 50 reviews, and was last updated Aug 17, 2026. Data from WordPress.org, refreshed twice daily — see methodology.
Compatible with WP 7.1
v1.6.5
Current Version v1.6.5
Updated 4 weeks ago
Last Update on 17 Aug, 2026
Refreshed 7 hours ago
Last Refreshed on
#73 of 1,518 in Performance
Top 5% by installs
Downloads -28.4% this week
Actively maintained
Rank
#2,091
-1 this week
Active Installs
10K+
-11.1%
KW Avg Position
15
—
No change
Downloads
111.9K
+290 today
Support Resolved
100%
—
No change
Rating
100%
Review 5 out of 5
5
(50 reviews)
Next Milestone 20K
10K+
20K+
671
Ranks to Climb
-
Growth Needed
8,000,000
Active Installs
Pro
Unlock Exact Install Count
See the precise estimated active installs for this plugin, calculated from real-time ranking data.
- Exact install estimates within tiers
- Track install growth over time
- Milestone progress predictions
Need 8,367 more installs to reach 20K+
Rank Changes
Current
#2,091
Change
Best
#
Downloads Growth
Downloads
Growth
Peak
Upgrade to Pro
Unlock 30-day, 90-day, and yearly download history charts with a Pro subscription.
Upgrade NowReviews & Ratings
5.0
50 reviews
Overall
100%
5
50
(100%)
4
0
(0%)
3
0
(0%)
2
0
(0%)
1
0
(0%)
Support Threads Overview
Resolved
Unresolved
4
Total Threads
4
Resolved
0
Unresolved
100%
Resolution Rate
Security History
Source: WPVulnerabilityNo known vulnerabilities on record for SQLite Object Cache. Checked 1 day ago.
Track This Plugin
Get detailed analytics, keyword tracking, and position alerts delivered to your inbox.
Start Tracking FreePlugin Details
- Version
- 1.6.5
- Last Updated
- Aug 17, 2026
- Requires WP
- 5.9+
- Tested Up To
- 7.1
- PHP Version
- 5.6 or higher
- Author
- OllieJones
Support & Rating
- Rating
- ★ ★ ★ ★ ★ 5
- Reviews
- 50
- Support Threads
- 4
- Resolved
- 100%
Keywords
Upgrade to Pro
Unlock keyword rankings, search positions, and detailed analytics with a Pro subscription.
Upgrade NowSimilar Plugins
Adminify – White Label, Admin Menu Editor, Login Customizer
6K+ installs
#2,752
Master Addons for Elementor – Elementor Addons, Widgets, Mega Menu Builder, Popup Builder, Widget Builder & Template Kits
30K+ installs
#1,007
LiteSpeed Cache
7M+ installs
#5
Wordfence Security - Firewall, Malware Scan, and Login Security
5M+ installs
#11
Hostinger Tools
3M+ installs
#20
WP Super Cache
1M+ installs
#38
Speed Optimizer - The All-In-One Performance-Boosting Plugin
1M+ installs
#43
WP Fastest Cache - WordPress Cache Plugin
1M+ installs
#47
WP-Optimize – Cache, Compress images, Minify & Clean database to boost page speed & performance
1M+ installs
#52
Maintenance
1M+ installs
#57
TL;DR
AI summary of the plugin's readmeThis plugin is for WordPress site owners running on a single web server with the SQLite3 PHP extension available, especially those without access to Redis or Memcached hosting. It solves the problem of repeated expensive database lookups by adding a persistent object cache that reduces load on the MariaDB or MySQL database and speeds up page delivery.
- SQLite-based persistent object cache
- APCu acceleration support
- igbinary extension support
- WP-CLI command support
- Syncs data between APCu and SQLite
- Single-server site optimization
Frequently Asked Questions
Common questions about SQLite Object Cache
Yes. To see the Settings page, choose Settings > Object Cache from the first site, or any site, in the multisite installation.
Exactly predicting each site's speedup is not possible. Still, benchmarking results comparing it to other object caching schemes are promising. Please see this. If you run a benchmark, please let the author know by leaving a comment on that page or using the support forum.
The default setting for Cached Data Size is 16 megabytes (MiB). This plugin allows the actual cached data size to grow larger than that, and occasionally removes old -- the least recently updated -- data to trim back the size to the setting. Take a look at the Statistics page. If your actual cached data usage under All Groups is consistently larger than the setting, double the setting. If you operate a large and busy site, try an initial setting of 32 MiB, then adjust it based on the growth of the actual size. Notice that this setting controls the size of the data in the cache. That is the size shown under All Groups. The data file used by SQLite is larger than that.
SQLite is fast and efficient database software. It doesn't require a separate server. Instead, it is built into php using the SQLite3 extension. SQLite programs don't need to open network connections to send requests and wait for replies.
igbinary is a php extension that provides an efficient way to serialize and compress the kinds of data objects stored in caches. It, in some cases, uses less than half the storage space of the built-in php data serializer. If igbinary is available in your php configuration, this plugin uses it, unless you force it not to by setting WP_SQLITE_OBJECT_CACHE_SERIALIZE to true in wp-config.php.
APCu is php extension offering an in-memory storage medium. You can configure this plugin to use it to speed up cache lookups.
On most operating systems the size of the APCu cache is, as installed, 32MiB. If you need to increase this size you can add a line to your php.ini file mentioning the apc.shm_size configuration option. For example, the line apc.shm_size = 64M sets the size to 64MiB. Please consult your operating system or hosting provider documetation for information on how to do this. Notice that sometimes multiple WordPress installations that run on the same server share the same APCu cache, so provide enough space for them all. And keep in mind that this plugin only uses APCu to accelerate its operations, so the consequences of setting its size too small are not great.
No. Your MariaDB or MySQL database sql server still holds all your content. All your site's imports, exports, backups and other database operations continue to function normally. This plugin uses SQLite simply to hold named values. For example, a value named "post|3" will hold a temporary, easy-to-retrieve cached copy of post number 3. When it needs that post, WordPress can fetch it quickly from SQLite.
No, you don't. This plugin doesn't use SQLite as a full-fledged database server. A persistent object cache needs some kind of storage mechanism. SQLite serves this plugin as a fast and simple key / value storage mechanism. Some hosting providers offer the scalable high-performance redis cache server. You can use it via Redis Object Cache plugin. Sites using redis have one SQL database and another non-SQL storage scheme: redis. Some other hosting providers offer memcached, which has the Memcached Object Cache. But many hosting providers don't offer either redis or memcached, while they do offer SQLite. This plugin enables your site to use a persistent object cache even without a separate cache server. And, because everything happens within your web server, the performance is good.
Probably. Page caching and persistent object caching are completely separate functions in WordPress. But, some multi-feature caching plugins support optional object caching using redis or memcached. If that feature is enabled in your page cache plugin, you should not use this plugin. You can find out whether your page-cache plugin also enables persistent object caching. Look at the Drop-in section of the Plugins -> Installed Plugins page. If it mentions the drop-in called "object-cache.php" then your page cache plugin is handling persistent object caching. You should disable that feature before using this plugin. Users of this plugin have found that it works well with WP Rocket, LiteSpeed Cache, WP Total Cache, WP Super Cache, and WP Fastest Cache. It also works with Cloudflare and other content delivery networks. The author has not learned of any incompatibilities in this area. (If you find one please start a support topic!)
