News for hackers. Stuff that matters.

A comment on Dear Postgres. Parent comment

Re:Dear Postgres by Annatar on Friday October 13, 2017 @02:39PM (#15468223)
Because MariaDB is based on MySQL which is fundamentally broken: check out how basic SQL doesn‘t work on Youtube. And then there is silent data corruption and six different storage engines because Monty & co. just couldn‘t get the code to deliver decent performance for the generic case. Then there’s the nonexistent OS based authentication and very amateurish database backup capabilities. With all of these „features“, MariaDB is „a recipe for success“.

Meanwhile PostgreSQL has always been about reliability and stability and has been getting better and better with every release.

[ Parent | on HN ]
Re:Dear Postgres by anarazel on Friday October 13, 2017 @05:10PM (#15469256)
I don't understand this kind of argument. And I'm about as big a postgres enthusiast as you can get. Both postgres and mysql/mariadb have strengths and weaknesses. In some areas they overlap, in some not. In some areas they're of philosophical nature, in others purely technical.

I'm fine with arguing that $pro{je,du}ct is better for most cases. But that doesn't mean the other alternatives have to be denigrated as being pure shit. That's not going to convince anybody that's not already convinced, and stirs um enmity.

FWIW, I think both postgres and mysql/mariadb benefit from the competition.

Do I think that postgres is overall the better project? Yes. Do I think mysql is shit? No.

[ Parent | on HN ]
Re:Dear Postgres by Annatar on Sunday October 15, 2017 @03:21AM (#15476242)
It's really simple: MySQL / MariaDB do not function correctly for the feature set they supposedly support, while PostgreSQL works correctly for that which it supports and people recognised this eventually, which is thankfully why PostgreSQL is the leading open source relational database management system.

There is not much philosophy here: MySQL should have never been used since it's always been busted, and thankfully now it's lost so much market share that it's become all but irrelevant. If you want to build bullet proof, robust systems and don't want or can't afford Oracle, one of PostgreSQL variants is a critical piece for building such a system.

I like sleeping through my nights instead of wasting my life away troubleshooting MySQL. How about you?

[ Parent | on HN ]
Re:Dear Postgres by anarazel on Sunday October 15, 2017 @04:14AM (#15476333)
> I like sleeping through my nights instead of wasting my life away troubleshooting MySQL. How about you?

I waste them working on postgres. Doesn't mean I've to denigrate other systems.

[ Parent | on HN ]
Re:Dear Postgres by Annatar on Tuesday October 17, 2017 @02:42AM (#15489105)
At least you’re investing your time in a product which works correctly and isn’t throughly broken by design. Sometimes it’s necessary to point out MySQL’s flaws lest someone get the “bright” idea to put it in production, then I get the job and then get stuck with that disaster of a database (that actually happened to me several times). Raising awareness is the best prevention.
[ Parent | on HN ]