transaction-management

SKILL.md

Implement robust transaction management with ACID compliance, concurrency control, and error handling. Covers isolation levels, locking strategies, and deadlock resolution.

✅ DO use appropriate isolation levels for use case ✅ DO keep transactions short ✅ DO commit frequently ✅ DO handle transaction errors ✅ DO use consistent lock ordering ✅ DO monitor transaction performance ✅ DO document transaction requirements

❌ DON'T hold transactions during user input ❌ DON'T use SERIALIZABLE for high-concurrency systems ❌ DON'T ignore deadlock errors ❌ DON'T lock too many rows ❌ DON'T use READ UNCOMMITTED for critical data

Administre las transacciones de la base de datos para lograr la coherencia de los datos. Úselo al implementar el cumplimiento de ACID, manejar la concurrencia o administrar los niveles de aislamiento de transacciones. Fuente: aj-geddes/useful-ai-prompts.

Ver original