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

데이터 일관성을 위해 데이터베이스 트랜잭션을 관리합니다. ACID 준수 구현, 동시성 처리 또는 트랜잭션 격리 수준 관리 시 사용합니다. 출처: aj-geddes/useful-ai-prompts.

원본 보기