Why favor PostgreSQL over MariaDB/MySQL?

Re:Why favor PostgreSQL over MariaDB/MySQL? by marcosdumay on Tuesday September 05, 2017 @11:24AM (#15176109)

Well, personally what I see is people comparing a group of developers that are adamant on never corrupting any data, where everything is secondary and will refuse to push any feature that may cause problems with a group that is adamant on increasing market share, if it's by doing a low quality MVP so be it, that I have seen corrupting data on production several times, and whose software still carries the scars from those MVP's errors.

Yes, MySQL is all featureful¹. The only thing missing there is guarantees that your data will stay good.

1 - Some of those are "no, we won't ever implement it" features that will do nothing but eat your data by design. Why would you ever want them in a persistence layer? Cache on memory somewhere better.

[ Parent | on HN ]

Re:Why favor PostgreSQL over MariaDB/MySQL? by bonesss on Thursday September 07, 2017 @05:34AM (#15190236)

> Some of those are "no, we won't ever implement it" features that will do nothing but eat your data by design. Why would you ever want them in a persistence layer? Cache on memory somewhere better.

I feel a significant motivation for MySql development are lightweight webapps on PHP like Wordpress where the developers are beholden to a third-party hosting environment and have a significant front-end focus...

From that perspective I can see why bells and whistles that would be moronic in a normal application would start sticking to the database itself.

MongoDB suffers from some of the same market pressure: being easy to demo and get from 0 to SAP in 10 min is great, but having to choose crazy insecure defaults and be open for data loss in order to get there is a showstopper in Enterprise circles. In both cases the ironic demands for competent administration are much higher because of all the potential for foot-shooting.

"It's always worth it to take the pain up front."

[ Parent | on HN ]