3 ms·
But individual apps can change that on the session level, right? So still no guarantees and you more or less have to audit every app connecting to your db to m
by einhverfr 14y ago
But individual apps can change that on the session level, right?
So still no guarantees and you more or less have to audit every app connecting to your db to make sure it isn't tampering with the sql_mode if you value data integrity.
- ceejayoz 14y agoIndividual apps can do far more destructive stupid things than changing sql_mode.
- einhverfr 14y agoThe point though is that you lose a set of guarantees with MySQL that you don't lose with PostgreSQL. Yeah, computers make it possible to make more mistakes faster than any invention since handguns and tequila but when you lose the ability to guarantee that your declarative constraints are actually followed, you lose the ability to prove that certain types of errors are not being made. That's a big deal.