Tag Archives: plugin

Wordpress and SQLite

SQLite Proof-of-concept WP plugin (Updated)

1 Reply

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.

Wordpress Plugin

Some old posts restored and Other updates

Leave a reply

I know that I haven’t post anything in a while. I have been busying with the new site lately. In fact, today is the first time I visited this blog after the last post I wrote about two weeks ago.

Anyway, I discovered that the traffic has been surprisingly increasing since this blog relaunched a while ago. All of these traffic surges are thanks to the posts I wrote two years ago or so when I was still using Linux. As you know, I already deleted these posts because of the white screen of death, which means that the visitors of these links were presented with the 404 error page.

Based on the traffic log, I restored some of the posts which are still popular today from my backup copy of the site. These posts didn’t actually stored in the WordPress files. They stored in the WordPress MySQL database. I will write about how to do a scheduled backup of the database in another post.

Here are the restored posts with no specific order:

Unfortunately, not all of the posts are recoverable. Here is one post which I couldn’t find. I can’t remember the exact content for the post. But by looking at its URL, I think it is about using jQuery to generate the breadcrumb navigation.

The URL for each of these post are maintained so that others can visit the posts from other sites without updating their links. This is achieved by changing the publishing date to the original publishing date. For example, the publishing date for the post wrote on 12/19/2010 was set to 12/19/2010 and so on.

The content for these posts are almost original. I removed the images in these posts since I don’t have them anymore. The original comments were retained for nearly all of the posts thanks to Disqus.

I will be adding more of these old posts as they appear in the traffic log.

Now onto the updates for the site. In the next several days, I will be creating the child theme for this blog based on the Twenty Twelve theme. The upcoming posts will be the daily report for the child theme features of the day.

As of right now, I’m focusing on the WordPress development, mainly the plugin. For the last several months, I have been modifying the WordPress plugins for others. Recently I started my own WordPress plugin project. It will be used to managing my modified plugins and others’ feedbacks for  my plugin modification service. If all goes well, I will publish this plugin to the WordPress plugins repo.

That’s all for this post. Be sure to leave a comment below to discuss which of my old posts do you want me to publish except for those that were already on the blog, as well as other feedbacks for this post.