Hacker News new | ask | show | jobs
by The_Colonel 605 days ago
Lack of transactional DDL is certainly painful, but not unique for MySQL. Oracle doesn't support it either.
2 comments
tpmoney 604 days ago
Oracle also didn't support Boolean data types for a long time, and had a 20 some odd year public thread arguing that no one needed a Boolean data type (https://asktom.oracle.com/ords/f?p=100:11:0::::P11_QUESTION_...). They finally added it in Oracle 23 which is nice, but I wouldn't consider it to be in good company to be lacking something Oracle also lacks.
link
The_Colonel 603 days ago
Not having a boolean data type is IMHO just an annoyance, not comparable to the lack of transactional DDL.

But to the point, people often use this point to claim that MySQL is a toy database, not usable for real world production use. I use Oracle as a counterpoint, which also has a lot of warts but is pretty much an archetype of an enterprise-grade DB engine.

link
justinclift 605 days ago
Both databases are owned by the same company. Wonder if it's something inherent to the company which has keep that limitation going?
link