Learn MySQL
Nope 2 years ago

MySQL’s poor performance forced me into writing crazy cache schemes. 5.0 was an unstable hunk of crap. MySQL would barf with random table crashes that would bring down my website. I still don’t understand why a table should randomly crash!

When I finally migrated to a better database system and added foreign keys, I discovered that MySQL’s was happily letting “CoryKING” and “coryking” exist in my unique username column. I had to sift through almost 100 usernames to figure out which account was the real one. Had I been using the new database server in the first place, this issue would have been caught before it could corrupt my database.

Bottom line?

MySQL is overrated. I would not recommend its use in any kind of production environment. There are much better alternatives.



Comments:

Dan Bodenstein is working on story number 2

I disagree. It seems that the case sensitivity issue is a programming, or database creation issue.

As for foreign keys, mySQL does do foreign keys. Newer versions also do stored procedures.

I’ve created several high end web sites using mysql. Many popular forum sites and new social networking sites use mysql.

There may be instances where a high end MS SQL, or Oracle db is needed, but most web sites can function easily with mysql.


 

I want to:
43 Things Login