I've finally made the switch from MySQL to PostgreSQL. This is something that I've been meaning to do for awhile, but MySQL did what I needed, I was using it at work and so knowing more about it was useful, and I was just used to it and comfortable with it. I've recently changed jobs and the new place uses postgres. Since I've also been working with Django and the Django guys also recommend postgres, now seemed like a good time to switch.

One thing that always comes up when discussing mysql and postgres is a bunch of people claiming that postgres works better and does things right, but no details are ever provided. Before I made my decision I did some searching to see if I could find any details. It turns out postgres provides them. For most of this stuff I'll never notice the difference it makes with my small personal projects. I really liked the dedication to data integrity and consistency, though, which fits in with most of my Linux decisions such as running Debian.