MySQL inadequecies

Freshness Warning
This article is over 6 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.

Nikolaas
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

  • How not to apply for a job Applying for a job isn't that hard, but it does take some minimal effort and common sense.
  • Movie marketing on a budget Mark Cuban's looking for more cost effective ways to market movies.
  • 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.
  • Customer reference questions. Sample questions to ask customer references when choosing a software vendor.
  • Comment Spam Manifesto Spammers are hereby put on notice. Your comments are not welcome. If the purpose behind your comment is to advertise yourself, your Web site, or a product that you are affiliated with, that comment is spam and will not be tolerated. We will hit you where it hurts by attacking your source of income.
  • More of the best »

Recently Read

Get More

Subscribe | Archives

Recently

Assumptions and project planning (Feb 18)
When your assumptions change, it's reasonable that your project plans and needs change as well. But too many managers are afraid to go back and re-work a plan that they've already agreed to.
Feature voting is harmful to your product (Feb 7)
There's a lot of problems with using feature voting to drive your product.
Encouraging 1:1s from other managers in your organization (Jan 4)
If you’re managing other managers, encourage them to hold their own 1:1s. It’s such an important tool for managing and leading that everyone needs to be holding them.
One on One Meetings - a collection of posts about 1:1s (Jan 2)
A collection of all my writing on 1:1s
Are 1:1s confidential? (Jan 2)
Is the discussion that occurs in a 1:1 confidential, even if no agreed in the meeting to keep it so?
Skip-level 1:1s are your hidden superpower (Jan 1)
Holding 1:1s with peers and with people far below you on the reporting chain will open your eyes up to what’s really going on in your business.
Do you need a 1:1 if you’re regularly communicating with your team? (Dec 28)
You’re simply not having deep meaningful conversation about the process of work in hallway conversations or in your chat apps.
What agenda items should a manager bring to a 1:1? (Dec 23)
At least 80% of a 1:1 agenda should be driven by your report, but if you also to use this time to work on things with them, then you’ll have better meetings.

Subscribe to this site's feed.

Contact

Adam Kalsey

Mobile: 916.600.2497

Email: adam AT kalsey.com

Twitter, etc: akalsey

Resume

PGP Key

©1999-2019 Adam Kalsey.