kebab/tasks/p9/p9-fb-17-chat-session-storage.md

phase, component, task_id, title, status, depends_on, unblocks, contract_source, contract_sections, source_feedback

phase	component	task_id	title	status	depends_on	unblocks	contract_source	contract_sections	source_feedback
P9	kebab-store-sqlite	p9-fb-17	SQLite V004 — chat_sessions / chat_turns	completed	p9-fb-15	p9-fb-18	../../docs/superpowers/specs/2026-04-27-kebab-final-form-design.md	§5 storage	p9-dogfooding-feedback.md item 13, 14

p9-fb-17 — Chat session storage

Goal

multi-turn 대화 영속화. session 단위로 turn 저장 / 조회. TUI 의 "이전 대화 이어가기", CLI --session <id> (p9-fb-18) 의 backing store.

Allowed dependencies

• kebab-store-sqlite 기존 deps (rusqlite, refinery).

Public surface

마이그레이션 migrations/V004__chat_sessions.sql:

CREATE TABLE chat_sessions (
    session_id   TEXT PRIMARY KEY,           -- 사용자 지정 또는 blake3 해시
    created_at   INTEGER NOT NULL,
    updated_at   INTEGER NOT NULL,
    title        TEXT,                        -- 첫 question 의 첫 N 자
    config_snapshot_json TEXT NOT NULL        -- prompt_template_version, llm model 등
);

CREATE TABLE chat_turns (
    turn_id      TEXT PRIMARY KEY,           -- blake3(session_id || index)
    session_id   TEXT NOT NULL REFERENCES chat_sessions(session_id) ON DELETE CASCADE,
    turn_index   INTEGER NOT NULL,
    question     TEXT NOT NULL,
    answer       TEXT NOT NULL,
    citations_json TEXT NOT NULL,             -- Vec<Citation> 직렬화
    created_at   INTEGER NOT NULL,
    UNIQUE(session_id, turn_index)
);
CREATE INDEX idx_chat_turns_session ON chat_turns(session_id, turn_index);

kebab_core::ChatSessionRepo trait + SqliteStore impl.

Behavior contract

• session_id 사용자 명시 (kebab ask --session foo) 또는 자동 생성 (blake3 of first_question + ts).
• turn_index monotonic per session.
• ON DELETE CASCADE — kebab reset --data-only (p9-fb-06) 가 wipe.
• config_snapshot_json 는 prompt_template_version + llm.model + max_context_tokens 등 — 후일 retrospective 분석 가능.

Test plan

kind	description
unit	session 생성, 3 turn append, list_turns sequence
unit	session delete → CASCADE turns
migration	V004 apply 후 schema_version table 갱신

DoD

• cargo test -p kebab-store-sqlite 통과
• migrations/V004__chat_sessions.sql 추가
• kebab_core::ChatSessionRepo trait 정의
• frozen design §5 storage 절에 chat_sessions / chat_turns 추가

Out of scope

• session 검색 / 필터 UI (P+)
• 다른 store backend (postgres 등)