SQLite is a pain to work with.

The problems I'm having:

• Where are the DATE functions!?
• Why can I not modify a table stucture with the MODIFY command!?
• Why don't LIMITs work on deleting and updating!?

Such a pain.

The only good thing about SQLite is that it just comes with PHP5 and you don't need to install anything.

MySQL has been working perfectly as usual.

Bluetrait Event Viewer (BTEV) is a plugin I wrote for WordPress that adds an event viewer similar to the one found in Bluetrait 1 and 2.

BTEV has just been updated to version 1.5.

Version 1.5 now includes an auto prune function to remove old events.

BTEV seems pretty popular, it has almost reached 700 downloads off the WordPress site.

I'm slowing building up a collection of plugins I've written for Bluetrait...

I've made public the search plugin I wrote for this site.

It can be downloaded from here and is under the "Creative Commons Attribution-ShareAlike 2.5 License".

The plugin requires Bluetrait 2 and MySQL.

It probably won't be any use to anyone as Bluetrait 2 isn't even in Beta yet ;)

The problems with PHP

Well I can finally edit posts :)

So I'm slowing going through my old posts and adding some categories to them.

I need to add some more categories but I can't do that yet :p

I've released another Bluetrait 2 code example

To enable php:

1. open terminal
2. cd /etc/
3. sudo cp php.ini.default php.ini
4. cd /private/etc/apache2/
5. sudo nano httpd.conf
6. uncomment the two modules: php5_module and fastcgi_module. They were at line 114 and 115 for me.
7. Use ctrl and o to save
8. reload apache (can be done from system preferences).

After hacking my ipod, I installed Apache and PHP. I was successfully able to install the sqlite version of Bluetrait 2 onto my ipod!

There were some small bugs, I haven't yet pin-pointed them down yet but I believe it may have been due to the setup of PHP.

So yeah that was pretty cool, pointless but cool :)

I've re-enabled commenting as I've written in spam filtering. There might be a few issues, but we'll see how it goes.