tag: transactions
articles: 5 · beats: 3
latest: November 15, 2026
---
Transactions
5 Crashtech articles on Transactions, spanning System Design & Architecture, Development Best Practices and Database Engineering, published between September 2026 and November 2026. Every piece is full-text HTML with sources, structured data and an authored FAQ.
They span System Design & Architecture (3), Development Best Practices (1), Database Engineering (1). System Design & Architecture Development Best Practices Database Engineering
Saga Pattern Demystified: Orchestration vs Choreography for Distributed Transactions and Compensating Actions
A comprehensive guide to the Saga pattern: Two-Phase Commit failure modes, compensating transactions, choreography vs orchestration, and idempotency.
Database Locks Explained: Shared, Exclusive, Update, Key-Range and Granularity
What each lock mode allows, why update locks exist, how key-range locks stop phantoms, and when row, page or table locks cost you concurrency.
Pessimistic vs Optimistic Locking: Choosing by How Often Your Writes Collide
Lock first or check at commit? Version columns, SELECT FOR UPDATE, retry logic and the contention numbers that decide which strategy fits.
Concurrency Control in Databases: Lost Updates, Locking, and Isolation Levels Explained
How concurrent transactions corrupt state: dirty reads, non-repeatable reads, phantom reads, pessimistic locks, and MVCC snapshot isolation.
Database Transactions Explained: ACID, Isolation Levels, and Concurrency Control
What ACID actually guarantees, and how pessimistic vs optimistic concurrency control decide whether your app locks or retries under load.
Questions we answer about Transactions
- Why is Two-Phase Commit (2PC) considered an anti-pattern in modern cloud microservices?
- What is a compensating transaction in the Saga pattern?
- What are the primary trade-offs between Choreography and Orchestration in Sagas?
- How do architects handle the lack of isolation (the 'I' in ACID) in Sagas?
- What is the difference between a shared and an exclusive lock?
- Why do update locks exist?
- What is a key-range lock?
- Are row locks always better than table locks?
- What is the difference between optimistic and pessimistic locking?
- How does optimistic locking work with a version column?
Covered alongside
Frequently asked questions
What does Crashtech publish about Transactions?
5 articles tagged Transactions, the most recent published November 15, 2026. They span System Design & Architecture (3), Development Best Practices (1), Database Engineering (1). Each carries numbered sources, an authored FAQ and full structured data.
What questions about Transactions does Crashtech answer directly?
10 questions have a dedicated answer page under this tag, including “Why is Two-Phase Commit (2PC) considered an anti-pattern in modern cloud microservices?”. Each answer is authored prose from the article it belongs to, not a generated summary.
Can AI assistants read Crashtech's Transactions coverage?
Yes. Crashtech serves full static HTML to every crawler, allows all major AI user agents in robots.txt, and publishes an llms.txt manifest plus a full-text corpus, so assistants can retrieve and cite these articles directly.