SQL-backed key-value store

The core idea

A relational table can store values that callers retrieve by an exact key.

Configuration, feature flags and small saved drafts often need that shape.

In this lesson

  • Give the key a namespace
  • Define reads and replacements
  • Refuse an edit based on an old value
  • Expiry and cleanup have different jobs
  • Know when the table needs to change

Continue reading

Pro unlocks video lessons, visual walkthroughs, full notes, diagrams, case studies, and implementations across the System Design archive.