When people insist that code in the database is never acceptable, these are precisely the kinds of situations where the benefits outweigh the downsides. If I w

When people insist that code in the database is never acceptable, these are precisely the kinds of situations where the benefits outweigh the downsides. If I were to come up with a rule: A database should avoid having to rely on stored procedures to maintain invariants, but shouldn't avoid using stored procedures to maintain invariants it would otherwise struggle to maintain.