6 posts · page 1 of 1
Understand Kafka's three delivery guarantees, idempotent producers, transactional writes, and when you actually need exactly-once semantics in production.
Deep dive into ACID properties, isolation levels, and distributed transactions. Understand dirty reads, phantom reads, two-phase commit, the saga pattern, and how Stripe handles payment consistency.
Understand SQL isolation levels, their concurrency trade-offs, and how to choose the right level for your application.
Understanding SQL transactions and isolation levels: ACID properties, read phenomena, read committed, repeatable read, serializable isolation, deadlocks, and practical concurrency patterns.
What ACID and BASE actually mean, where each shines, and how to reason about consistency, availability, and durability when you design data systems.
Understand BEGIN, COMMIT, ROLLBACK, and the four standard isolation levels with concrete examples of dirty reads, non-repeatable reads, and phantoms.