---
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

System Design & Architecture6 min

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.

System Design & Architecture5 min

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.

Development Best Practices3 min

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.

Database systems diagram contrasting Two-Phase Locking table locks with Multi-Version Concurrency Control undo log version pointers
Database Engineering4 min

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.

System Design & Architecture7 min

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

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.