MySQL inadequecies

Freshness Warning
This article is over 2 years old. It's possible that the information you read below isn't current.

This guy seriously hates MySQL:

Considering MySQL? Use something else. Already on MySQL? Migrate. For every successful project built on MySQL, you could uncover a history of time wasted mitigating MySQL’s inadequacies.

Thesis: databases fill roles ranging from pure storage to complex and interesting data processing; MySQL is differently bad at both tasks. Real apps all fall somewhere between these poles, and suffer variably from both sets of MySQL flaws.

What follows is a 5300 word treatise on the inadequacies, weird design choices, and tradeoffs that MySQL has. You’re really got to have a lot of hate to spend time writing that detailed of an analysis of something.

For those that actually use MySQL, the post serves as a great summary of things you need to be aware of. Not every tool is appropriate for every job, and every database server has some sort of deficiency, so knowing what you’re in for before you start is helpful.

August 28, 2013 11:36 AM

MySQL is ok (note I didn't say great or even good), and definitely has/has had its problems. But if all you need is a basic client/server SQL provider (and don't care about lightning speed, scalability, [insert complex/non-portable usage here]), it can do the job.. which in many personal environments is all one needs. The ironic thing is that article implied using SQLite as an alternative.. yet some of his arguments against MySQL could be equally applied to SQLite. And for the record.. when given a choice, I use PostgreSQL instead of MySQL. But that, like all SQL databases, has its problems too (i.e. using Oracle [the database] is always a hate, love, hate relationship).

This discussion has been closed.

Follow me on Twitter

Best Of

  • Lock-in is bad T-Mobile thinks they'll get new Hotspot customers with exclusive content and locked-in devices.
  • The importance of being good Starbucks is pulling CD burning stations from their stores. That says something interesting about their brand.
  • Newly Digital Newly Digital is an experimental writing project. I've asked 11 people to write about their early experiences with computing technology and post their essays on their weblogs. So go read, enjoy, and then contribute. This collection is open to you. Write up your own story, and then let the world know about it.
  • California State Fair The California State Fair lets you buy tickets in advance from their Web site. That's good. But the site is a horror house of usability problems.
  • Google on the desktop Google picks up Picasa, giving them an important foothold on people's PCs.
  • More of the best »

Recently Read

Get More

Subscribe | Archives



Form or function in hotel design (Nov 17)
The hotel has one of the most beautifully designed rooms I've ever stayed in. It's also the worst designed hotel room I've ever stayed in.
Protesting TSA security theater (Nov 9)
Please join me in messing with the TSA's fake security. Maybe we'll save some money and implement useful security instead.
Vintage Phone Numbers (Oct 27)
I have a bunch of old phone numbers hanging in my closet.
But... schools (Oct 28)
This school alarmism needs to stop. For the children.
Travel weight of coins (Aug 26)
My laptop bag was getting heavy, so I emptied it. Found 115 coins from 6 different countries in there. That will do it.
Aereo: a parable (Jun 26)
Here's why people who understand both technology and copyright law think the Supreme Court's Aereo decision defies common sense.
The birth of cubicle hell (Apr 29)
Where do cubicles come from?
Double Opt-In helps you (Apr 2)
A simple reason why double opt-in is a good thing for marketers.

Subscribe to this site's feed.


Voice and communications platforms, including Tropo and Phono. Work.
The Sacramento technology startup community.
Pinewood Freak
Pinewood Derby tips and tricks


Adam Kalsey

Mobile: 916.600.2497

Email: adam AT

AIM or Skype: akalsey



©1999-2015 Adam Kalsey.
Content management by Movable Type.