Search tools and guides ⌘K
Semicolony ELI5 · comic

SQL vs NoSQL.

Labelled filing cabinets with strict folders, versus a fast drawer you can toss anything into.

  1. SCHEMA FIRST
    1

    SQL is a labelled filing cabinet: you define the folders — the schema — before storing anything.

  2. Wrong shape — rejected.
    expects □
    2

    Every record must fit the agreed shape, so the cabinet can enforce rules and reject mess.

  3. orders users join
    3

    Its real power is relationships: separate folders stitched together on demand with a join.

  4. Just toss it in.
    any shape, store first
    4

    NoSQL is a fast drawer: store first, define later, each item keeping its related data together.

  5. spreads easily, weaker guarantees
    5

    No fixed shape means it spreads across many machines easily — but often with weaker guarantees.

  6. SQL core data NoSQL caches · logs +
    6

    Neither wins. Many systems use a relational core plus a NoSQL store for caches and logs.

Strict labelled folders versus a drawer you toss anything into — a different bargain about structure.
Semicolony semicolony.dev/eli5/sql-vs-nosql/comic
← All ELI5 explainers