Title: SQLite Cache Author: andreyk Published: May 21, 2015 Last modified: July 1, 2016 --- Search plugins This plugin **hasn’t been tested with the latest 3 major releases of WordPress**. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress. ![](https://s.w.org/plugins/geopattern-icon/sqlite-cache.svg) # SQLite Cache By [andreyk](https://profiles.wordpress.org/andreyk/) [Download](https://downloads.wordpress.org/plugin/sqlite-cache.zip) * [Details](https://twd.wordpress.org/plugins/sqlite-cache/#description) * [Reviews](https://twd.wordpress.org/plugins/sqlite-cache/#reviews) * [Installation](https://twd.wordpress.org/plugins/sqlite-cache/#installation) * [Development](https://twd.wordpress.org/plugins/sqlite-cache/#developers) [Support](https://wordpress.org/support/plugin/sqlite-cache/) ## Description On first request to a given URL whole html code of a page is being stored in the SQLite database. On next requests to the same page WordPress core will not be loaded at all but the content of a page will be retrieved from the the SQLite storage therefore duration of PHP execution decreases in dozen of times. Many sites on the same webserver may use common SQLite storage. Compatible with WordPress Multisite. Requires PHP SQLite PDO. In comparison with plugins generating static html pages this plugin does not create multiple directories and html files but stores all generated pages in one file. Moreover, many wordpress sites on the same webserver may use common SQLite storage. Keeps 404, 301, 302, 304 HTTP statuses, optionally supports ETag, Expires, Content- Length, Content-Type (with charset) headers. #### As the cache script doesn’t load the WordPress core where does it save it’s settings? To get the plugin working you need to define the SQLite storage location in the` index.php` of the wordpress installation directory (note, not in wp-config.php but index.php). Besides of the SQLite file, this directory contains general settings file (compression setting) and a subfolder for per domain settings. In the admin area (plugin setting page) and to remember after deactivation where the cache located,` litecache_path` WordPress option is used. #### How the plugin handles URLs with and without `www.` prefix? The presence of `www.` prefix is defined in `Settings` – `General`. The plugin stores `with_www` parameter in `domains/yourdomain.ini` file in the cache directory and redirects requests correspondingly; these redirects are being processed before cache usage. #### Is it WordPress Multisite compatible? Yes, but for subdomains mode only (blogname.example.com), not for example.com/blogname. A superadmin of a multisite network has access to the first setting form (cache location), blog admins have access to the second form and purge form. ## Installation * Upload the plugin from the WordPress plugin installation page or unpack `sqlite- cache` folder to the plugins directory (usually `wp-content/plugins/`). * Activate the plugin through the WordPress Plugins manager, then you will see` SQLite Cache` item in the `Settings` submenu of WordPress admin menu. * Forms on the the plugin settings page: 1. Define a directory where the plugin settings and the cache storage will be located. 2. Define cache expiration time and HTTP headers the cached pages will be delivered with. 3. Third form is for cleaning cache. Note the cache will be cleared every time when you submit the domain settings form so you don’t need to clear cache after changing settings. * Add two lines into `index.php` file (you will be notified on the settings page) to define where the cache storage is located and include the cache engine file. Done! For testing, enable `Show performance time` checkbox to ensure the cache engine works. ## FAQ I’m the owner of a site and I see `Edit page` link near the page content. Will it be cached? No. The cache engine is not used for authorized users, for those who has commenter cookie and for visitors with active PHP sessions. What I’ll see after posting a comment? The result of a page after POST request method will isn’t being cached so you will see your comment or a notification about pending comment. Also, see the previous question. What else is not cached? * Any URL containing `wp-`, `.php`, `/files/` and `blogs.dir`. * Results of POST and HEAD request methods. Do I need clear cache when I edit an existing post or page or add a comment? Cache entry of a single post page or page will be cleared automatically after post/ page update or publishing a comment. Also, the blog list page cache is cleared on post updates. You need to purge cache after modifying menus, widgets, switching theme, changes of theme options. Can I disable cache for some pages? Yes, you can define a list of URL patterns to exclude them from cache. Does the `Contact Form 7` work on cached pages? Yes, it works by itself but additional functionalities such as CAPTHCHAs might be not working. How the plugin handles with 404 Not Found response and redirects? The plugin caches `404 Not Found` HTTP status code with the same expiration period as other pages as well as redirect codes 301 and 302 with Location header. How to deactivate the plugin? Click on Deactivate link on the plugins list, then the settings file (yourdomain. ini) will be deleted so cache engine will not be applied for the current domain. However it stays working for other sites installed in the same directory until it is included in the `index.php` and their setting files exist. ## Reviews ![](https://secure.gravatar.com/avatar/098d7931cde7313738b15b33c34fa8bcc606b049aafd712de205c50ba2f7a890? s=60&d=retro&r=g) ### 󠀁[glitchy](https://wordpress.org/support/topic/glitchy-2/)󠁿 [frazzledjazz](https://profiles.wordpress.org/frazzledjazz/) September 3, 2016 it works but its glitchy.cant update menu when using this enabled. add legull custom link and you will see what i mean. [ Read all 2 reviews ](https://wordpress.org/support/plugin/sqlite-cache/reviews/) ## Contributors & Developers “SQLite Cache” is open source software. The following people have contributed to this plugin. Contributors * [ andreyk ](https://profiles.wordpress.org/andreyk/) [Translate “SQLite Cache” into your language.](https://translate.wordpress.org/projects/wp-plugins/sqlite-cache) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/sqlite-cache/), check out the [SVN repository](https://plugins.svn.wordpress.org/sqlite-cache/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/sqlite-cache/) by [RSS](https://plugins.trac.wordpress.org/log/sqlite-cache/?limit=100&mode=stop_on_copy&format=rss). ## Changelog 0.6.2 * Fix Content-Length header value. * Fix php warning when $_SERVER[‘HTTPS’] is not set. 0.6.1 * Improved usability on multisite: get_site_option instead of get_option (update, delete). * Cleaning code (check input before gzcompress/uncompress, bug fix in ob_start). * Ukrainian translation. 0.6 First public version. ## Meta * Version **0.6.2** * Last updated **10 years ago** * Active installations **10+** * WordPress version ** 3.8.1 or higher ** * Tested up to **4.5.33** * Language * [English (US)](https://wordpress.org/plugins/sqlite-cache/) * Tags * [cache](https://twd.wordpress.org/plugins/tags/cache/)[performance](https://twd.wordpress.org/plugins/tags/performance/) [SQLite](https://twd.wordpress.org/plugins/tags/sqlite/) * [Advanced View](https://twd.wordpress.org/plugins/sqlite-cache/advanced/) ## Ratings 4 out of 5 stars. * [ 1 5-star review ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=4) * [ 1 3-star review ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/sqlite-cache/reviews/?filter=1) [Add my review](https://wordpress.org/support/plugin/sqlite-cache/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/sqlite-cache/reviews/) ## Contributors * [ andreyk ](https://profiles.wordpress.org/andreyk/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/sqlite-cache/)