The Desi Architect
Notes / Interview Foundations / Database Types Field Guide
Track 1 · Interview Foundations

Database Types Field Guide

Seven families of database, each built to answer one kind of question fast. This page tells you the question each one is good at, how each one breaks, and how to pick without arguing for an hour.

Guide28 min read
On this page
  1. The search that ate the checkout
  2. The simple version
  3. The one-glance matrix
  4. Relational: where money and seats live
  5. Key-value: the fastest answer is a known key
  6. Document: one read, one whole object
  7. Wide-column: relentless writes, read by key and time
  8. Graph: when the question is about the connections
  9. Time-series: a number, a timestamp, a few tags
  10. Search: a second index, not a second source of truth
  11. Which database makes which consistency choice
  12. Real engines, side by side
  13. The three engines everyone confuses
  14. Pick one: two desi systems
  15. Common traps