Last time I checked MySQL even *silently* commits out of the transaction and pro... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

lloeki on Oct 23, 2018 | parent | context | favorite | on: Django zero-downtime migrations for Postgres that ...

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

Doxin on Oct 25, 2018 | [–]

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.

fredley on Oct 23, 2018 | [–]

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...

Consider applying for YC's Spring batch! Applications are open till Feb 11.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact