Current status (2026-06-28)

Path 3 has consolidated from the historical 3.1b / 3.2 stack into one active SQLite storage flip line.

• Active implementation PR: refactor: flip sessions and transcripts to sqlite storage #96625 (refactor: flip sessions and transcripts to sqlite storage). This is now the only outstanding Path 3 implementation lane. It carries the SQLite session/transcript storage flip, import/migration behavior, archive-before-delete semantics, runtime read/write conversion, SDK/file-surface removals, and the live/fresh-instance proof harness work that supersedes the older 3.2 foundation/adapter split.
• Superseded 3.2 foundation PRs: refactor: add SQLite session store foundation #89178, refactor: add SQLite transcript identity adapter #90437, and refactor: add SQLite embedded run target adapter #90438 are no longer active review targets. Their intended foundation/adapter work has been absorbed or replaced by refactor: flip sessions and transcripts to sqlite storage #96625, so those PRs should remain closed rather than rebased.
• 3.1b seam-adoption status: complete enough for the flip lane. The remaining work should be tracked through refactor: flip sessions and transcripts to sqlite storage #96625 review/CI/proof, not by reviving old foundation PRs.
• Tracker policy: update this issue when refactor: flip sessions and transcripts to sqlite storage #96625 changes state, when its proof scope changes materially, or when post-flip follow-up issues are split out. Do not add new PRs to the historical 3.1b/3.2 stack unless refactor: flip sessions and transcripts to sqlite storage #96625 is abandoned.

Active queue

Superseded / closed PRs

Durable plan

Track the core session/transcript runtime-state migration to SQLite through a storage-neutral accessor seam, with runtime state moving to SQLite and legacy JSONL/file reads restricted to doctor/import/archive workflows.

The original plan intentionally decomposed the migration so the accessor seam, caller adoption, SQLite store modules, and runtime flip could be reviewed separately. That decomposition worked for the 3.1b seam-adoption phase. As of #96625, the remaining implementation work is now consolidated into a single flip PR rather than the old 3.2 foundation/adapter PR stack.

Decisions still binding on #96625

• Database-first runtime: after the flip, active runtime session/transcript reads and writes go through SQLite-backed accessors. There should be no runtime JSONL fallback reader for active sessions.
• Doctor/import boundary: legacy file reads belong in migration/import/doctor/archive code, not steady-state runtime.
• Archive-before-delete: migration and lifecycle cleanup must archive imported/deleted transcript artifacts before removing legacy files or rows.
• One-way flip: no reverse migration or downgrade rescue ships with this flip. The merge bar is forward migration correctness plus clear operator proof.
• Transcript lifecycle: SQLite is the hot canonical store. Archived JSONL artifacts are derived product artifacts and are not runtime fallback inputs.
• SDK/file-surface cleanup: deprecated active-session file-shaped SDK surfaces should be removed as part of the flip, while explicit archive/import/export artifact handling remains allowed.

Acceptance criteria for the active flip lane

• refactor: flip sessions and transcripts to sqlite storage #96625 owns the remaining Path 3 implementation and keeps the tracker current.
• Active sessions and hot transcripts migrate to SQLite through idempotent startup/doctor paths.
• Imported active JSONL files are moved out of their old runtime-readable locations after successful import/archive handling.
• Runtime reads/writes active session and transcript state through the accessor seam only.
• No active runtime fallback reads from sessions.json or transcript JSONL remain after the flip.
• Reset/delete/maintenance paths archive before deleting rows or files.
• Local/fresh-instance proof demonstrates startup migration, live gateway state visibility, full agent turn history, reset/delete/archive behavior, and no stale JSONL dependency.
• Old 3.2 foundation PRs remain closed unless refactor: flip sessions and transcripts to sqlite storage #96625 is abandoned.