On: PostgreSQL Rising

[AaronBBrown]

1. Yes, applications can set sql_mode themselves at the session level. An admin cannot prevent this. http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html

[einhverfr → AaronBBrown]

So, what good is setting a sensible default as a DBA if the dev guys can override it?

I mean it's fine if you only allow one app to write to your db, but once you have more than one, the fact that the option to ignore invalid data even exists ought to make one very nervous if the data stored is worth anything.

[AaronBBrown → einhverfr]

A dev can only override it for their session, not at the global level.