MySQL inadequecies

Freshness Warning
This blog post is over 8 years old. It's possible that the information you read below isn't current and the links no longer work.

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.

Recently Written

The Trap of The Sales-Led Product (Dec 10)
It’s not a winning way to build a product company.
The Hidden Cost of Custom Customer Features (Dec 7)
One-off features will cost you more than you think and make your customers unhappy.
Domain expertise in Product Management (Nov 16)
When you're hiring software product managers, hire for product management skills. Looking for domain experts will reduce the pool of people you can hire and might just be worse for your product.
Strategy Means Saying No (Oct 27)
An oft-overlooked aspect of strategy is to define what you are not doing. There are lots of adjacent problems you can attack. Strategy means defining which ones you will ignore.
Understanding vision, strategy, and execution (Oct 24)
Vision is what you're trying to do. Strategy is broad strokes on how you'll get there. Execution is the tasks you complete to complete the strategy.
How to advance your Product Market Fit KPI (Oct 21)
Finding the gaps in your product that will unlock the next round of growth.
Developer Relations as Developer Success (Oct 19)
Outreach, marketing, and developer evangelism are a part of Developer Relations. But the companies that are most successful with developers spend most of their time on something else.
Developer Experience Principle 6: Easy to Maintain (Oct 17)
Keeping your product Easy to Maintain will improve the lives of your team and your customers. It will help keep your docs up to date. Your SDKs and APIs will be released in sync. Your tooling and overall experience will shine.

Older...

What I'm Reading

Contact

Adam Kalsey

+1 916 600 2497

Resume

Public Key

© 1999-2021 Adam Kalsey.