What’s so exciting about Postgres?

Re:What’s so exciting about Postgres? by rbanffy on Friday October 30, 2020 @04:40PM (#24946676)

I started using PostgreSQL because, at the time, MySQL wouldn't do subqueries. The fact it silently truncated VARCHAR data to the size of the column and didn't give out an error didn't help much.

Overall, my impression is that the project's philosophy is to do the Correct Thing, even if it's slow.

[ Parent | on HN ]

Re:What’s so exciting about Postgres? by Ralfp on Friday October 30, 2020 @05:30PM (#24947078)

Few years back I've had friend explain the difference between MySQL and PostgreSQL like this:

- MySQL: do it fast, then make it right - PSQL: do it right, then make it fast

[ Parent | on HN ]

Re:What’s so exciting about Postgres? by setr on Friday October 30, 2020 @08:06PM (#24947986)

I had switched after learning that CHECK constraints were parsed, but ignored -- I've yet to be as offended by a program that at that instant

Apparently supported now but what the hell; I don't think they even threw a warning about it

[ Parent | on HN ]

Re:What’s so exciting about Postgres? by Delk on Sunday November 01, 2020 @02:19PM (#24961758)

Years back, the conventional wisdom seemed to be that MySQL used to be faster, and PostgreSQL more correct. Over time, according to that same conventional wisdom, MySQL got more correct than it used to be and PostgreSQL got faster than it used to be.

[ Parent | on HN ]