MySQL

What Exactly Constitutes an “Expert” Author These Days?

Hmmmphh. No, let me correct that. Hhmmmppppphhhh.

For those of you who know me, you realize that the above is about as angry as I get. 😉 I’ve generally a very nice guy! But….. on certain occasions, I’ve been known to get my knickers in a twist over certain things (my colleagues at a previous job used to call it J-had, as in gihad!). And, I’ve got my knickers in a twist over a certain silly little article on WebProNews. Why? Well, here goes.

Lee Asher, ostensibly called an “Expert Author”, had the following to say about MySQL:

MySQL is the most common database software for small websites, but is laughed at in the rest of the industry. It’s fine for simple insertion and retrieval of data, but if you start trying to do anything more advanced with it, you’re going to start running into problems.

OK, this is just ridiculous. The list of MySQL customers who rely on MySQL for mission critical systems include Google (Adsense), Yahoo!, Friendster, Ticketmaster, Evite, Pokerroom.com… the list goes on and on and on. Check out the MySQL customer list yourself. For Lee Asher to make a claim that MySQL is “laughed at in the rest of the industry” proves he is neither an “Expert Author” nor capable of doing the most basic research before putting together an article for a website.

I’m not sure what Mr. Asher means by “anything more advanced with it”, but I am sure that the sheer number of projects using MySQL, either as a backend database or embedded storage system, aren’t all simplistic “Hello World” applications. Perhaps if Mr. Asher would like to see examples of extremely complex and high-performance MySQL systems, he should plan on coming to the MySQL User’s Conference, where many of these applications will be highlighted and he would be able to “refine” his researching skills.

and then further down…

So what doesn’t MySQL support? Today, MySQL doesn’t support views (‘virtual’ tables made from other tables), stored procedures (small programs that can be stored in the database) or triggers (actions that the database can be told to do automatically when certain things happen). However, many of these features are promised in future versions.

Again, Mr. Asher, please do some homework before re-printing ancient (in web terms at least) information that you found while researching MySQL on Microsoft’s Knowledge Base. Stored procedures, views, triggers, and much more functionality has been in MySQL 5 for a long time now. You find details of all of MySQL 5’s new features online.

For WebProNews to print such outright misinformation leads me to believe that “Pro” and “News” should be removed from their website title. Although I do give them kudos for actually printing my notification of their misinformation, they did so at the very bottom of the article.

Special thanks to Felix Geerinkcx for bringing this to my attention and Ronald’s blog post about it.