Easy Learn
A complete, ground-up tutorial on database normalization — what it is, why it exists, and how professional engineers actually use (and sometimes deliberately break) it in real production systems. Starts from the messy-notebook analogy and Edgar Codd’s 1970 relational-model paper, then walks through every classic building block: relation, attribute, tuple,…
A complete, beginner-to-production guide to database migrations: the toy-box analogy for schema evolution, why the term exists and a short history from 1970s fixed schemas through 1980s manual DBA scripts, 1990s version control, 2004 Rails Migrations, and today’s tooling (Flyway, Liquibase, Alembic, Django Migrations, Prisma Migrate, golang-migrate) baked into CI/CD;…
A complete, beginner-to-production guide to database transactions: what they are, why they exist, how ACID (Atomicity, Consistency, Isolation, Durability) works under the hood, and how modern databases and distributed systems handle transactions at massive scale. Covers the history from Jim Gray and IBM System R through PostgreSQL, MySQL, Oracle, and…
A complete, beginner-to-production guide to database partitioning: the big idea (splitting one overloaded table into smaller, independently manageable pieces), a short history from 1970s mainframes through 1990s Oracle table partitioning, 2000s web-scale sharding, NoSQL built-in sharding, and today’s cloud-native automatic partitioners, the storage/throughput/latency pressures that motivate splitting, seven core concepts…
A complete, beginner-to-production tutorial on database connection pooling: introduction and history (from 1970s client-server through 1990s enterprise Java pools, PgBouncer, HikariCP, and today’s cloud-managed poolers like RDS Proxy), the latency and resource-exhaustion problems that motivate pooling, nine core concepts (connection, pool, min/max size, borrow/return, idle connection, connection timeout, idle timeout,…
A complete, beginner-to-production guide to data lakes: what they are, why they exist, and how modern lakehouse architectures at Netflix, Uber, and Amazon are built on top of them. Traces the history from 1970s relational databases through Hadoop, Amazon S3, and the “data lake” term coined by James Dixon, into…
A complete, beginner-to-production tutorial on sharding versus replication in distributed databases: why the topic matters and the short history of horizontal scaling, the three failure modes of a single database and how each technique attacks a different one, precise definitions of nodes, replicas, and shards, a CAP-theorem foundation with consistency…
A complete, beginner-to-production tutorial on database replication – what it is, why it exists, how it works internally, and how it is used in every serious modern system. Covers the notebook analogy and the full history from 1970s single-machine relational databases through the birth of primary-backup in the 1980s-90s, the…
A first-principles guide to data sharding: what it is, why systems need it, and how they decide where data lives. Covers all five common strategies (range-based, hash-based, consistent hashing with virtual nodes, directory-based, and geographic/attribute-based) with worked Java code, sequence and ring diagrams, and honest trade-offs. Includes the routing architecture,…
A complete, beginner-friendly guide to database sharding. Covers: what sharding is and its history, the problem it solves (single-server scaling limits, vertical vs horizontal scaling, sharding vs replication), the core vocabulary (shard, shard key, logical vs physical shard, shard map, rebalancing, cross-shard queries), production architecture and routing options, the five…