3 ms·
The database is the only place that can be the authority because the application can have race conditions. It’s the only way to guarantee data integrity.
by brightball 5y ago
The database is the only place that can be the authority because the application can have race conditions. It’s the only way to guarantee data integrity.
- grogers 5y agoThere's no way to specify every single application specific constraint directly in the database. Race conditions are not present when using locking reads (select ... for update, or DB specific shared locking selects) or serializable isolation level, which are the typical way of enforcing application level constraints.