"They ditched a perfectly working MySQL application and migrated to Oracle which caused them to hire Oracle consultants $2000 per day and spend millions on Oracle big-iron."
Reminds me of when the ads manager at Google decided we needed to ditch MySQL and get a "real database" for the ads system. "Real database" in that case meant Sybase, but it was still a barely mitigated disaster. Sometimes it seems as if the "real" databases are just a colossal scam.
Well, it never was listed that Oracle was the reason, just that it was one of, and indicative of why it failed. If the MySQL solution was working, which the answerer on Quora implied, and there was no immediate sign of its failure, I think transitioning to Oracle at the cost of millions of dollars is a pretty big mistake.
Back then it might have been an OK decision, you did get some very nice things with Oracle including scaling and MySQL was a lot less mature, only about half a decade old. It certainly doesn't sound like choosing Oracle per se was instrumental in eToys' failure. On the other hand I've never heard a good thing about Sybase.
Sybase has to be the worst of the "real databases", although SQL Server, DB2 and Oracle are bad too. The first time I tried to use Sybase, I wrote something like "CREATE TABLE foo (id INTEGER PRIMARY KEY, bar INTEGER NOT NULL)". Turns out Sybase doesn't have a type called "INTEGER". What the fuck.
Admittedly, all databases have their quirks. I use SQLite for a multi-process app suite, and get "database is locked" rather frequently. At least my app now knows how to retry transactions. Most of the apps using "real databases" fall over as soon as a transaction fails. "Internal server error, please retry later." Uh, no... transactions are supposed to fail. Even reads.
"They ditched a perfectly working MySQL application and migrated to Oracle which caused them to hire Oracle consultants $2000 per day and spend millions on Oracle big-iron."
Reminds me of when the ads manager at Google decided we needed to ditch MySQL and get a "real database" for the ads system. "Real database" in that case meant Sybase, but it was still a barely mitigated disaster. Sometimes it seems as if the "real" databases are just a colossal scam.