Ask HN: PostgreSQL or MySQL?

Re:Ask HN: PostgreSQL or MySQL? by namewasmypw on Sunday September 22, 2019 @09:41AM (#21041311)

MySQL is simply garbage that shouldn't be used under any circumstance.

1. No transactional DDL 2. Implicit, confusing coercions 3. Terrible Unicode handling 4. the list goes on

[ Parent | on HN ]

Re:Ask HN: PostgreSQL or MySQL? by johannes1234321 on Sunday September 22, 2019 @10:11AM (#21041435)

1. Thanks to the new data dictionary in 8.0 there is light at the end of that tunnel ...

2. Yeah, MySQL tried to be "simple" and it took a while to be confident for changing it's default to being strict (the option for opting exists for ages ...) But meanwhile defaults are proper.

3. Especially the 3 byte Unicode type was a historic mistake. It reduced required storage space but didn't forsee the need for Emojis and other 4 byte sequences ... utf8mb4 charset fixes that though

4. ...

[ Parent | on HN ]