Although I must grudgingly admit that MySQL has improved over the years, I still think it is a toy database. Rants (both valid and unreasonable) on the vagaries of MySQL abound, so I won't duplicate any of those comments here. Instead, I will relate a recent experience on when MySQL "saved the day".
Once upon a time there was an orders database storing order data and ordered items in MySQL without InnoDb. Someone deleted a really large order and all seemed lost. The order itself could be easily recreated but the list of ordered items was extensive.
But MySQL's lack of referential integrity meant that the ordered items were still present in a separate table. A quick query or two and all of the ordered items were available again.
No comments:
Post a Comment