MySQL Rocks
I’ve been using MySQL for years now and MySQL 5 since it was in beta. MySQL 5 brings a lot of nice things to the table (no pun intended) like views and stored procedures. The more I use MySQL 5 in my application development and system administration tasks the more great new features I’m finding. The latest feature that is going to save me a ton of code is foreign keys on InnoDB tables. For as long as I have used MySQL the enforcement of referential integrity has been a function of the application. I’ve invested a lot of code in always making sure my database stays consistent when I do a delete or update, no more. Adding simple foreign key constraints to a InnoDB table causes all of this to happen automatically. I’m a very happy man.
On a side note the GUI tools for MySQL are slick as snot and the next version of MySQL (5.1) looks like it is going to be another awesome release with a ton of goodies.
Leave a Reply