MySQL 8.0 is now generally available

Re:MySQL 8.0 is now generally available by superice on Thursday April 19, 2018 @11:01AM (#16876462)

There are some nice features that MySQL lacks. Personally, the thing I like best in Postgres is transactional DDL. In MySQL, if halfway through a database transformation your migration script fails, you are in a broken state and you are on your own. Postgres rolls the whole transaction back. Ofcourse there are some other features MySQL lacks, such as variable length character columns (varchar) where you don't need to specify a maximum length.

The transactional DDL seems to be introduced in MySQL per 8.0 though

[ Parent | on HN ]

Re:MySQL 8.0 is now generally available by madenine on Thursday April 19, 2018 @11:19AM (#16876626)

The advantages of Postgres (and MariaDB) over MySQL are pretty well traveled on HN. OP wants to move from Redshift Postgres & SQL Server to MySQL - which isn't something you see very often.

[ Parent | on HN ]

Re:MySQL 8.0 is now generally available by semiquaver on Thursday April 19, 2018 @11:58AM (#16876956)

> The transactional DDL seems to be introduced in MySQL per 8.0 though

I thought so as well from the release note wording, thanks to theptip for confirming in the docs that DDL is not transactional in 8.0, just crash-safe. see https://news.ycombinator.com/item?id=16876549.

[ Parent | on HN ]