UPDATE 1: As those who follow me on Twitter already knew, I have been struggling with the loading speed for all of my sites. The main problem I think is that I’m using WordPress multisite and installed a lot of plugins. I’m in the process of separating my sites into single installations of WordPress. Until that time, I won’t be posting new posts.
UPDATE 2: Anyway, here is the future plan for the SQLite concept plugin. I will upload the plugin to both WordPress Plugins Repo and GitHub so that others could contribute to the plugin and hopefully others will use it as a starting point for developing SQLite-based plugins.
UPDATE 3: But before that, I will rewrite the plugin using the WP Plugin Boilerplate for more cleaner code.
As promised, I have been working on this plugin for the last several days. As the name suggests, this plugin is created for developers who want to maintain the performance of WordPress for their end users by storing the data of each plugin into separate SQLite files.
You are free to use any section of the source code for this plugin without contribution. The source code should be clean enough to be readable (I tried to write a comment for each confuse-able code whenever possible). Please leave a comment if you don’t understand certain part of the code.
Here is the plugin. In the next post, I will be uploading this plugin to the official WordPress repo and discussing my experience.