Hacker News new | ask | show | jobs
by pielud 5344 days ago
Where is transactional DDL on this list?
3 comments

I think that's the sort of thing most people take for granted. It really shocked me to see that Mysql didn't have that.
transactional DDL for granted? Not at all! Oracle doesn't support that AFAIK. May be you were thinking about transactional DML?
Huh, weird. I don't know Oracle much at all... it seems that it does some things amazingly well, and others abominably. Strange beast.
Oracle silently issues an implicit commit after each DDL statement. I think it kills a kitten each time.
Web development is like a fashion industry. Just because it is popular it doesn't mean it has the functionalities.
The functionality for fashion is "makes you look great."
Transactional DDL is awesome with Rails migrations, it's not a huge thing, but being able to cleanly roll them forward and back when they fail or you screw something up in development is very nice (and certainly beats having to comment out half of your migration and re-run it like you need to do with MySQL).
I mentioned it in the "this could be included but it didn't meet my criteria and here's why" section in the last couple paragraphs. Yes, it's highly underrated, but my focus was just a little narrow perhaps.