To view parent comment, click here.
To read all comments associated with this story, please click here.
A lot of people say this, but I don't buy it. There isn't a major RDBMS out there that doesn't have proprietary extensions, simply because there are massive holes in the spec. For example, there are no stored procs in the spec, sprocs tend to be fairly critical, so as soon as you use one, you are locked in to that vendors implementation.
What is great about MySQL is how simple, fast, and reliable it is. The reason it is simple fast and reliable is because it doesn't do many of the things that other databases do. The reason it is so popular is because most people just need a place to persist data that can be backed up easily, and don't really care about ACID properties that are the real selling point of using an RDBMS in the first place.
And yet MySQL is one of the least standards compliant databases.
If stored procedures are so critical, how did MySQL become so popular when it didn't have them until version 5.0?
Simple: definitely not. There are way too many gotchas, and the various storage engines have their own.
Fast: with MyISAM, perhaps. But then you don't get transactions. Hardly simple.
Reliable: definitely not with the non-ACIDic MyISAM.
"simple, fast, and reliable" might be true for H2 (Java embedded database) or perhaps SQLite, for the small subset of typical RDBMS functionality it has.
You should. There's a difference between having extensions and creating incompatibilities in the standard syntax.
True that. For most applications mysql is just used a glorified flat-file storage.





Member since:
2005-07-18
I disagree. *Many* of them are more, *most* of them are just a place to store, query, and backup data, for which an RDBMS of any kind is overkill. Hence the whole NoSQL movement. "
MySQL has historically deviated from the standards so much that it is really hard to move from it. Curiously, moving from SQLite to PostgreSQL or Oracle is easier than moving from MySQL to either one. I think MySQL made their deficiencies into 'feature', in classic Microsoft style, and got lots of clueless PHP (and Java) programmers locked in to MySQL.