Semicolony home
Search guides and simulators ⌘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

Published Updated