Databases
Apr 30, 2024
Databases
42 min readDatabases (8): Databases in Practice — Migration, Monitoring, and War Stories
The operational side of databases — schema migrations, connection pooling, monitoring, backup strategies, managed database options, and hard-won lessons from production incidents.
Apr 28, 2024
Databases
42 min readDatabases (7): Distributed Transactions — 2PC, Saga, and Why Consensus Is Hard
How distributed databases coordinate transactions across machines — two-phase commit, Raft consensus, the Saga pattern, and practical patterns like outbox and CDC.
Apr 26, 2024
Databases
34 min readDatabases (6): Replication and Partitioning — Scaling Beyond One Machine
How databases replicate data for availability and partition data for scale — covering leader-follower, multi-leader, leaderless, sharding strategies, and consistent hashing.
Apr 24, 2024
Databases
36 min readDatabases (5): NoSQL — Document, Key-Value, Column, and Graph
A practical tour of the four major NoSQL families — document, key-value, wide-column, and graph — including the CAP theorem and when to use each model.
Apr 22, 2024
Databases
38 min readDatabases (4): Storage Engines — How Data Hits Disk
How database storage engines work under the hood — B-tree vs LSM-tree, WAL, buffer pools, compaction, and why your choice of engine shapes everything.
Apr 21, 2024
Databases
40 min readDatabases (3): Transactions and Concurrency — ACID, Isolation Levels, and Locking
A thorough guide to ACID properties, isolation levels, MVCC, locking strategies, and deadlock prevention — with concrete SQL examples for every concept.
Apr 19, 2024
Databases
36 min readDatabases (2): Indexing and Query Planning — How Databases Find Your Data
Deep dive into B-tree and B+tree indexes, hash indexes, composite indexes, covering indexes, and how to read EXPLAIN output to diagnose slow queries.
Apr 17, 2024
Databases
42 min readDatabases (1): Data Models and SQL — Why Tables Won (For Now)
A ground-up tour of the relational model, SQL fundamentals, normalization, and advanced query patterns — everything you need to speak fluent SQL.