News for hackers. Stuff that matters.

user9903

Re:Amazon RDS for PostgreSQL on Friday November 15, 2013 @10:43AM (#6740016)
I don't think it's fair to say Mysql doesn't care about your data. For example,

> Perhaps you mistakenly insert "2013-10-32" into a date column.

Only with ALLOW_INVALID_DATES sql mode set. As of 5.0.2, the server requires by default that month and day values be legal, and not merely in the range 1 to 12 and 1 to 31.[1]

> Perhaps you make an error in a transaction. MySQL lets you keep doing subsequent things in the transaction.

If you care about transactions you should have STRICT_TRANS_TABLES on.[2]

[1] - http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html#...

[2] - http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#...