4 ms·
There are a lot of postgres fans on HN, would you mind giving some more info on why you want to go from PG to MySQL?
by orf 9y ago
There are a lot of postgres fans on HN, would you mind giving some more info on why you want to go from PG to MySQL?
- superice 9y agoThere 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
- madenine 9y agoThe 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.
- semiquaver 9y ago> 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 https://news.ycombinator.com/item?id=16876549.
- cdevnull 9y agoI did a project with postgres and symfony+doctrine. At 80% of completion, I moved to mySql because I needed spatial index, I installed Postgis but got a lot of problems with doctrine-migration.
- boznz 9y agoNo explanation he could possibly give on HN will prevent him being down voted. Sad but true