Archive for the ‘consulting’ Category

Getting excited for the MySQL Conference 2009

Sunday, February 22nd, 2009

I finally received confirmation that I’m attending the MySQL Conference 2009, yay! I didn’t really dive deep into all the conference has to offer just because I didn’t want to get too excited and then not be able to go. Now that I do know I’m going, I’m full on with excitement and thought I would share that excitement here :) (more…)

What to do when everything needs attention

Monday, January 26th, 2009

The problem

Every once in a while it happens. A customer comes to us for a review of their site or application. We have our initial interview and start picking up the signs: they are developing their product alone. They are self-taught, self made men/women. They word certain concepts in slightly strange way. Then, we log in to the server to take a first look, and there it is: no primary keys. no indexes. Everything is a VARCHAR(100), sometimes even TEXT or LONGTEXT. There is no my.cnf, or it is only 5 lines long. No updates have been run on the server since it was installed 2 years ago. The code is spaghetti and has no comments in it. (more…)