ADR-0003: D1 for snapshots only
Status: Accepted Date: 2026-08-05
Context
Section titled “Context”The read path needs global low-latency and eventual tenant isolation.
Decision
Section titled “Decision”Snapshots (materialized, evaluation-ready config) are published to KV/D1 per environment; Postgres flag_environments.version is the versioning source.
Consequences
Section titled “Consequences”- Read-path is read-only
- Stateless
- Horizontally trivial
- Snapshot rebuilds are idempotent from Postgres
Alternatives
Section titled “Alternatives”- Workers reading Postgres via Hyperdrive (latency connection constraint): rejected
- SDKs polling Postgres directly (database on the hot path): rejected