News for hackers. Stuff that matters.

A comment on PostgreSQL 11.3 and 10.8. Parent comment

Re:PostgreSQL 11.3 and 10.8 by mixmastamyk on Thursday May 09, 2019 @01:31PM (#19870270)
To be clearer, it's about the defaults regarding strictness (of the acceptance) of data that help to avoid trouble up front, not that mysql randomly corrupts/deletes it later.
[ Parent | on HN ]
Re:PostgreSQL 11.3 and 10.8 by evanelias on Thursday May 09, 2019 @01:57PM (#19870517)
Sure, and MySQL 5.7, released 4 years ago, fixed those bad defaults.

It isn't fair to compare Postgres-of-today to MySQL-of-over-4-years-ago.

[ Parent | on HN ]
Re:PostgreSQL 11.3 and 10.8 by mixmastamyk on Thursday May 09, 2019 @02:03PM (#19870571)
Ok, looks like that version is in LTS dists now. Perhaps to poster's legacy apps are taking advantage of them.

There were other deficiencies mentioned in Klepmann's book on Designing Data apps, but I don't remember the specifics now.

[ Parent | on HN ]
Re:PostgreSQL 11.3 and 10.8 by evanelias on Thursday May 09, 2019 @02:47PM (#19870995)
Even if OP is using 5.6 or previous, strict mode has been available as an option for over 15 years, and can be enabled dynamically (no restart required).

I simply don't see any valid argument for avoiding MySQL due to "data reliability" concerns in 2019.

> There were other minor deficiencies mentioned in Klepmann's book on Designing Data apps, but I don't remember the specifics now.

Well, I can't really respond to non-specific points from a book I haven't read. I'm happy to respond to any specifics re: data reliability concerns, if you want to cite them. FWIW, I have quite extensive expertise on the subject of massive-scale MySQL (16 years of MySQL use; led development of Facebook's internal DBaaS; rebuilt most of Tumblr's backend during its hockey-stick growth period).

[ Parent | on HN ]
Re:PostgreSQL 11.3 and 10.8 by mixmastamyk on Thursday May 09, 2019 @04:28PM (#19872089)
It takes years to build up trust, seconds to lose it. Obsolete documentation to disappear. It's an uphill battle. In the meantime there's postgres, and it's free.
[ Parent | on HN ]