Databases

Choosing a store, indexing it, and splitting it once one server cannot hold the data.

1. 01

   SQL vs NoSQL

   0/4

   Choose based on access patterns, consistency needs, and query complexity, not hype.

   1. What Relational Buys You3 min
   2. The NoSQL Families3 min
   3. How to Actually Choose2 min
   4. Polyglot Persistence3 min
2. 02

   Indexing

   0/4

   Pre-sorted data structures that trade write overhead for dramatic read speedup.

   1. What an Index Actually Is3 min
   2. B-Trees, the Default3 min
   3. Composite and Covering Indexes3 min
   4. What Writes Pay for Your Reads3 min
3. 03

   Consistent Hashing

   0/4

   Distribute data across nodes so adding/removing a node only moves a small fraction of keys.

   1. The Resharding Problem3 min
   2. The Hash Ring3 min
   3. Virtual Nodes3 min
   4. Where It Shows Up3 min
4. 04

   Normalization vs Denormalization

   0/3

   Normalize to reduce duplication; denormalize to avoid expensive joins at scale.

   1. Normal Forms in Practice3 min
   2. Why Reads Push You to Denormalize3 min
   3. Keeping Duplicates Honest3 min
5. 05

   Geospatial Indexing

   0/4

   Turn latitude and longitude into a sortable key so "what is near me" becomes a range scan.

   1. Why Two Dimensions Break Indexes2 min
   2. Geohash2 min
   3. The Boundary Problem2 min
   4. Quadtrees and Hexagons3 min