skill-arch-transactional

What problem does it solve?

Maintaining data integrity across distributed services is challenging due to partial failures, retries, and cross-service coordination. This Skill provides patterns and practices to ensure atomic updates, proper rollback, and reliable event publication.

Core Features & Use Cases

• ACID Fundamentals: Atomicity, Consistency, Isolation, and Durability are explained and demonstrated through practical guidance to ensure reliable cross-service transactions.
• Locking & Concurrency: Guidance on optimistic locking, pessimistic locking, and advisory locks to prevent conflicts and deadlocks.
• Transaction Boundaries & Patterns: Emphasizes Unit of Work, Savepoints, Outbox pattern, and Idempotency keys for safe, repeatable operations across services.
• Distributed Transactions: Coverage of two-phase commit (2PC), Try-Confirm-Cancel (TCC), and Saga choreography for cross-service consistency.
• Error Handling & Retries: Strategies for robust failure handling, idempotent design, and controlled retries.

Quick Start

Implement a basic transactional flow across services with a unit of work, and demonstrate an outbox-based event publication.