I’ve gotten a lot of great feedback over the past few years from people using my Bugzilla Changelog generator tool. I’ve released a new update that cleans up some code, fixes some issues, etc.

I’ve moved the code hosting to google code because sourceforge is just too bulky, slow, and their new web design is far worse than their last one.

http://code.google.com/p/bugzillachangelog/

I’ve also created a google group to help people who email me with questions find a more public space to ask questions.

http://groups.google.com/group/bugzilla-changelog

Updated: 6/6/09: As of now, I’ve settled on NetBeans as my primary IDE, and Textmate as my secondary. Read below for reasons.

In my line of work, a code editing tool is something that you spend almost all of your day with. There are so many that I keep forgetting what I don’t like about each one, and I return to it six months later thinking it was decent. Here, I’m going to try to outline all of my complaints about each one.

If you’re a developer of any of these, please let me know what I can do to help you fix these problems, or please contact me to explain why I’m failing to see your genius. I’m certain that I’ve been through all of the big ones so if I’m missing one, please let me know.

In general, my must-have features are typically:

(more…)

Recently I was doing some local development on my Mac OS X Leopard machine. When running apache2 with php I was able to connect to the database just fine, and from the command line I was able to run mysql commands.

However, when running a php script from the command line I was getting an error:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)

After spending some time thinking it was the code, I discovered that the mysql.sock file was missing.

Others on the net found the file elsewhere, like /private/tmp/mysql.sock or /tmp/mysql.sock but I had absolutely no .sock file anywhere.

Turns out, it did exist, but was named differently. According to the php.ini, the file was located at

/usr/local/mysql/run/mysql_socket

So, the solution was to create a symlink in /var/mysql to the proper file.

sudo ln -s /usr/local/mysql/run/mysql_socket /var/mysql/mysql.sock