Hacker News new | ask | show | jobs
by Doxin 2797 days ago
I'm not even sure this is possible in mysql. Last time I checked mysql still couldn't do DDL statements in a transaction.
1 comments

Last time I checked MySQL even silently commits out of the transaction and proceeds with the remainder of the queries.

Here are the "implicit commit" statements:

https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html

Honestly I don't see a single good reason for any new project to use mysql over postgres. mysql is almost universally terrible at actually being a database.
In Django it doesn't, it just dumps you out with a fucked-up semi-migration that takes you 20 minutes to get back to a consistent state...