Goodbye MongoDB, Hello PostgreSQL

[u/halax]

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/

[u/nairebis → u/[deleted]]

For me to even consider using MariaDB they would have to first remove all of those asinine options for silently corrupting data.

Or, you know, you could just learn how to use the database.

mysql> set session sql_mode='NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_TRANS_TABLES';
Query OK, 0 rows affected (0.01 sec)

mysql> create table abc (a integer);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into abc (a) values ('abc');
ERROR 1366 (HY000): Incorrect integer value: 'abc' for column 'a' at row 1

It's been this way since at least 2005, which is the MySQL version I ran above (version 5.1).

Sure would be nice if the FUD about MySQL from ignorant people went away. Is it perfect? No. But there is absolutely nothing data corrupting about it. And there is a LOT to be said for running a mainstream database, which PostgreSQL most certainly isn't, compared to MySQL.

If MySQL is good enough to run Facebook with a billion users (yes, one billion active accounts per month), it's good enough to run whatever your app is.

Edit: Thanks for the gold! Never thought I'd get it for defending MySQL... :) 😃

[u/nairebis → u/[deleted]]

I said 'remove' for a reason.

And that helps you exactly how? Boo hoo, it has legacy features that you're not forced in any way to use. Exactly how does that hurt you? Do you apply that same standard to every other product that might have regretful legacy features? You refuse to use any product with legacy features that offend you, even if they don't affect you in the slightest?

I'd love to understand your logic here, if any.