ADR-0009: Raw transcripts live outside SQLite

• Status: Accepted
• Date: 2026-09-10

Context

Long agent histories are large and semi-structured. Treating SQLite as the raw transcript warehouse increases migration and memory/query pressure.

Decision

Raw protocol streams are append-only files; SQLite stores queryable application state and normalized events.

Consequences

Raw files are evidence; SQLite remains the application read/write store.

Change rule

If implementation evidence proves this wrong, update the canonical architecture/product document first and then supersede/amend this ADR. The ADR is not allowed to keep current docs stale.