> Code can provide just as much safety as the database, you just have to be smart enough to not try and override it.
This statement is absolutely false. Some application code that random developers write will never be a match for constraints in a mature, well tested database.
> Some application code that random developers write will never be a match for constraints in a mature, well tested database.
Well, lucky for you, most places don't hire random developers, only qualified ones. /s
Where I work has billions of database tables sharded all over the place. There simply isn't a way to define a constraint except via code. We seem to get along just fine with code reviews and documentation.
I’ve never seen a database with just one writer. I wouldn’t even bet on all the writers using the same language, much less reusing a single piece of code implementing constraints that never have changed and never will.
This statement is absolutely false. Some application code that random developers write will never be a match for constraints in a mature, well tested database.