Topic track · 5 notes
Databases & Caching
Indexes, isolation, PostgreSQL diagnostics, Redis consistency and ledger-oriented modeling.
Database Indexes: A Practical Guide to Selectivity and Query Shape
How B-tree indexes support filtering, joining and ordering—and why extra indexes also create write cost.
Read article ↗Transaction Isolation and Locking for Backend Engineers
Dirty reads, non-repeatable reads, phantoms, write skew and practical techniques for preserving invariants.
Read article ↗Reading PostgreSQL EXPLAIN ANALYZE Without Guessing
How to interpret plan nodes, row estimates, loops, buffers and the difference between planner cost and elapsed time.
Read article ↗Redis Caching Without Serving Incorrect Data
Cache-aside, TTLs, invalidation, stampede protection and consistency trade-offs for backend systems.
Read article ↗Designing a Ledger Data Model That Can Explain Every Balance
Append-oriented entries, double-entry structure, immutable history and reconciliation-friendly balances.
Read article ↗