This entry in my series detailing how I have my development environment set up will deal with databases. This is going to be a somewhat shorter post than the others simply because there isn’t as much customization to be done in this area as some of the others.
For any client that I have a voice in selecting the database back end for, I generally choose MySQL. There is a myriad of places around the Internet that detail the advantages and disadvantages of MySQL when compared to the other popular database systems, so I won’t go into that here. However, the two main reasons I choose it are price (hard to beat free for the community edition) and its ability to run on nearly any platform. It certainly doesn’t hurt that it scales very well and has several options for graphically managing the schemas and data it contains.