News for hackers. Stuff that matters.
Re:One Giant Leap for SQL: MySQL 8.0 Released by smacktoward on Wednesday April 25, 2018 @01:46PM (#16924080)
Back in the day (i.e. long before Oracle purchased MySQL), if you wanted an open source database, you had two choices: Postgres, which was reliable, and MySQL, which was fast. It turned out there were a lot more people who cared about being fast than there were who cared about reliability.

Eventually Postgres got fast enough and MySQL got reliable enough, which has made the distinction between them somewhat fuzzier today. But by then MySQL had become the standard database offered by umpty zillion web hosts, and ubiquity is a hard position to dislodge someone from.

Re:One Giant Leap for SQL: MySQL 8.0 Released by ExactoKnight on Wednesday April 25, 2018 @02:30PM (#16924528)
>MySQL got reliable enough

MySQL still doesn't support nested DDL's, and this has caused me extreme amounts of pain in old projects where consistency was expected and we did not receive it on crucial payment processing.

Re:One Giant Leap for SQL: MySQL 8.0 Released by VectorLock on Wednesday April 25, 2018 @02:09PM (#16924328)
>Postgres, which was reliable

My experience recently and historically has been the exact opposite. Postgres seems to blow up in more mysterious and hair-yankingly frustrating ways than MySQL does. "Why Uber Engineering moved from Postgres to MySQL" echos a lot of the issues I've had with Postgres in large production environments.

Re:One Giant Leap for SQL: MySQL 8.0 Released by philliphaydon on Wednesday April 25, 2018 @09:46PM (#16928167)
Uber’s use of PostgreSQL was a mess. It’s probably the worst example of why not to use PostgreSQL.
Re:One Giant Leap for SQL: MySQL 8.0 Released by ausjke on Wednesday April 25, 2018 @02:29PM (#16924524)
https://lwn.net/Articles/752063/ PostgreSQL's fsync() surprise

this is very scary, if not fatally scary.

Re:One Giant Leap for SQL: MySQL 8.0 Released by macdice on Wednesday April 25, 2018 @04:18PM (#16925630)
I think it is scary about Linux. They are still wrestling with reliable error reporting for buffered IO after decades, and while the changes in 4.13 are an improvement in some ways they make some highly questionable assumptions that don't seem to be based on POSIX. I'm not following it in detail but fortunately it sounds like something might be done to improve the situation on the Linux side?
Re:One Giant Leap for SQL: MySQL 8.0 Released by sterwill on Wednesday April 25, 2018 @03:00PM (#16924882)
I can't read it because it's paywalled, but how is the operating system's fsync behavior "fatally scary" with regards to PostgreSQL? How does MySQL handle durability in these cases? What's your point?
Re:One Giant Leap for SQL: MySQL 8.0 Released by severine on Wednesday April 25, 2018 @07:10PM (#16927252)