Database Transactions

Use database transactions for write operations that must be atomic.

This is the canonical transaction skill. It consolidates the former transactions-and-consistency topic.

Transaction boundaries usually belong inside an Action or Service, not spread across controllers.

Required Transaction Cases

Use DB::transaction() when a workflow:

• writes multiple related records;
• updates counters, balances, inventory, or state machines;
• coordinates audit records with domain writes;
• creates records and related child rows;
• must not partially succeed.