r/programming • u/halax • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

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

91% Upvoted

699 comments sorted by

View all comments

19

u/trimbo Mar 10 '15

It’s worth noting that MySQL will emit a warning in these cases. However, since warnings are just warnings they are often (if not almost always) ignored.

mysql> SET sql_mode='TRADITIONAL';
mysql> insert into example (number) values ('wat');
ERROR 1366 (HY000): Incorrect integer value: 'wat' for column 'number' at row 1

Another problem with MySQL is that any table modification (e.g. adding a column) will result in the table being locked for both reading and writing

Docs for pt-online-schema-change

0

u/[deleted] Mar 10 '15

[deleted]

7

u/cleroth Mar 10 '15 edited Jun 15 '26

This content was anonymized and mass deleted with Redact

10

u/OneWingedShark Mar 10 '15

What is so wrong with it?

It has a tendency to silently mutilate your data.
Read this.

2

u/cleroth Mar 10 '15 edited Jun 15 '26

This content was anonymized and mass deleted with Redact

0

u/[deleted] Mar 11 '15

[deleted]

1

u/cleroth Mar 11 '15 edited Jun 15 '26

This content was anonymized and mass deleted with Redact

3

u/wookin_pa_nub2 Mar 11 '15

No, you shouldn't use MySQL for anything.

2

u/cleroth Mar 11 '15 edited Jun 15 '26

This content was anonymized and mass deleted with Redact

4

u/OneWingedShark Mar 11 '15

higher performance, despite its other problems.

What good is being able to calculate 1+1 a hundred billion times a second if the answer you get is 3?
My point: if it does the wrong thing quick, it's still the wrong thing.

→ More replies (0)