Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

ADR-008: Postgres and SQLite together from day one

Date: 2026-08-13
Status: Accepted

Decision: both dialects in v1, not Postgres first and SQLite later.

Why: an abstraction with one implementation is not proven to be an abstraction. Adding SQLite in month two would mean discovering every Postgres assumption baked into codegen and migrations at the worst possible moment. SQLite also makes the test suite fast and dependency-free for contributors.

Cost: roughly three extra days in P2 and P6, mostly the SQLite table-rebuild path. Paid deliberately.