Search

Lessons (6)

• ACID, Transactions & Locks

  … and isolation protect concurrent writers](/img/database/acid.svg) ACID without vague definitions Property What it protects Concrete …

• Transactions, Indexes & Concurrency

  Interview answers for triggers, ACID, clustered indexes, deadlock/livelock and RAID. Covers PDF questions 8-11 and 18 …

• SQL vs NoSQL Databases

  Relational tables or flexible documents? Understand how each stores data, the four NoSQL families, ACID vs BASE, and …

• Data in Microservices: Sagas & the Outbox Pattern

  … no shared tables, so no cross-service ACID transactions. - Avoid 2PC; use sagas : local transactions plus compensating actions …

• Monolith vs Microservices

  … function calls ❌ Slow, unreliable network calls Transactions ✅ One ACID database transaction ❌ Sagas, eventual consistency Testing end to end …

• What Is Software Architecture?

  … 50k orders/day. Decision Use PostgreSQL 17 (managed, Amazon RDS). Consequences + ACID transactions, mature tooling, team familiarity + JSONB …