SQLite support for wp2.0

SQLite support

Forget to say that I made this using php5 that comes with SQLite bundled in so to use SQLite in php4 you need to install the SQLite module and then load it. All functions should also work in php4 but if don't let me know. Mail can be send to tume@2ndpoint.fi

PS. And that patch is pretty big mesh, sorry for that.

Could this be done as a plugin?

I also don't need mysql, and tume's patch is certainly a big step in that direction. With some tweaking, I now run the latest WP and sqlite (on PHP 5.0.5-2ubuntu1.2 CGI).

I've attached a new diff based on his work, with the changes I had to do for it to work on my setup, using wp 2.0.2.

Note that I never seem to get the hang of creating diffs, so it might blow up your toaster and all that. However, it does apply cleanly for me:

  $ cd wordpress-2.0.2/
  $ patch --verbose -p1 < ../sqlite+wordpress.2.0.2-2.diff

Also, remember to give write permissions to the web user on the directory where you keep your sqlite database(s). Look at the comments in wp-config-sample.php.

tume's original patch had quite a few whitespace changes, and some syntactic errors, I've kept the whitespace and removed the errors. It is still rough, but it works.

NB. Note that categories are screwed up (I can't create them), but I have not yet determined whether it is browser related (Konqueror), sqlite related, or a big bad bug.

Have fun,

Hå-hå-håvard

Second patch. Code cleanup and syntactic errors removed.

Update: I said categories are screwed up (I can't create them), and it's caused by a collision of category ids: new categories are added to the database with a cat_ID == 1, even though that id already exists.

I do not know why this happens, but tume's patch does do something to category ids. I have not had time to sort this out yet, let alone figure out why tume did that in his patch. Too many aliens in the front yard.

Now, where's that water hose...

Hå

Quick tip: if you use svn diff instead of bog-standard diff to create your patches, they normally apply fine with a patch -p0 < patchfile.

I'm a big fan of this feature request, the attached patch still applies cleanly to 2.0.4, and I'm using it now. The broken categories bug was easy to fix, it was because the code inserts a value in to the cat_ID field. That field is marked as the primary key, and as an auto incrementing field.

I don't really know enough about mysql to tell if the original code is a defect or not, but here's a diff snippet that makes it work for sqlite.

--- wp-admin/admin-db.php       2006-10-20 01:59:48.400611520 +0100
+++ /home/cdavies/wordpress-sqlite/wp-admin/admin-db.php        2006-10-20 00:07:32.231664856 +0100
@@ -109,7 +109,7 @@
                $category_parent = 0;
 
        if (!$update) {
-               $wpdb->query("INSERT INTO $wpdb->categories (cat_name, category_nicename, category_description, category_parent) VALUES ('$cat_name', '$category_nicename', '$category_description', '$category_parent')");
+               $wpdb->query("INSERT INTO $wpdb->categories (cat_ID, cat_name, category_nicename, category_description, category_parent) VALUES ('1', '$cat_name', '$category_nicename', '$category_description', '$category_parent')");
                $cat_ID = $wpdb->insert_id;
        } else {
                $wpdb->query ("UPDATE $wpdb->categories SET cat_name = '$cat_name', category_nicename = '$category_nicename', category_description = '$category_description', category_parent = '$category_parent' WHERE cat_ID = '$cat_ID'");

Oops, should have noticed I reversed the diff before posting that... never mind, just apply it reversed or do it by hand :)

Are there any patches available for 2.1?

It's been said that support for databases other than MySQL is plug-in territory.