Archive for March, 2005

Start With Zero

Thursday, March 31st, 2005

I find it kind of funny that I can sit in front of phpMyAdmin all day at work and come home to find myself using it here, too. At the moment, I’m exporting my database. I’m planning to update WordPress here real soon. Besides, it’s time to get an updated version of the database downloaded should disaster strike. I have a lot of writing here. While it may not be considered good writing, it’s still my writing and I’d like to keep it around.

I found out that the third person working on the project at work that I complained about has also been having issues with the brains behind the project. While our brains man is really smart and has good ideas, the third guy also thinks that he can be a bit too critical, all things considered. Earlier this week I lost all respect for Mr. Brains when he decided to create a global array of statuses which was indexed starting at one instead of zero.

Having not used this array before, but knowing its name and file location, I didn’t feel that there would be an issue of how to figure out which was the last piece of the array. It was simply index size($config['c_status']) - 1. I didn’t think twice about it. It’s an array. These conventions are there, because a lot of us really do depend on them and not even know that we’re doing it.

Now that I’ve backed up my database, I will use MetaWeblogger’s post saving feature to make sure that I have the post in the event my upgrade goes wrong. I never thought I’d find that feature so useful.

LEFT JOIN

Friday, March 25th, 2005

Okay, LEFT JOIN is a useful SQL construct, but it scares me. I fear not its correctness, but its cost to run.