feat(tui): implement SQLite session persistence at ~/.local/state/cleveragents/tui.db #10170

Open
opened 2026-04-17 04:08:18 +00:00 by HAL9000 · 0 comments
Owner

Background

TUI sessions must persist across restarts so users can resume conversations where they left off. SQLite at ~/.local/state/cleveragents/tui.db provides a lightweight, file-based persistence layer that stores session metadata, conversation history, and persona state without requiring a separate database server.

Acceptance Criteria

  • SQLite database created at ~/.local/state/cleveragents/tui.db on first launch
  • Session metadata (id, name, persona, created_at) persisted to SQLite
  • Conversation history persisted and restored on session load
  • Sessions screen shows all persisted sessions with metadata
  • Test coverage >= 97%

Metadata

  • Commit Message: feat(tui): implement SQLite session persistence
  • Branch: feature/v3.7.0/tui-sqlite-session-persistence
  • Milestone: v3.7.0
  • Ref: #5308 EPIC: TUI Session Management & Persistence — SQLite State & Multi-Session Tabs (v3.7.0)

Subtasks

  • Define SQLite schema for sessions and conversation history
  • Implement session save/load/delete operations
  • Implement conversation history serialization/deserialization
  • Implement database migration support for schema changes
  • Write unit tests with in-memory SQLite database

Definition of Done

  • Implementation complete and all acceptance criteria met
  • Tests written and passing (coverage >= 97%)
  • PR reviewed and merged
  • Parent epic updated

Automated by CleverAgents Bot
Supervisor: Epic Planning | Agent: epic-planning-pool-supervisor

## Background TUI sessions must persist across restarts so users can resume conversations where they left off. SQLite at `~/.local/state/cleveragents/tui.db` provides a lightweight, file-based persistence layer that stores session metadata, conversation history, and persona state without requiring a separate database server. ## Acceptance Criteria - [ ] SQLite database created at `~/.local/state/cleveragents/tui.db` on first launch - [ ] Session metadata (id, name, persona, created_at) persisted to SQLite - [ ] Conversation history persisted and restored on session load - [ ] Sessions screen shows all persisted sessions with metadata - [ ] Test coverage >= 97% ## Metadata - **Commit Message**: `feat(tui): implement SQLite session persistence` - **Branch**: `feature/v3.7.0/tui-sqlite-session-persistence` - **Milestone**: v3.7.0 - **Ref**: #5308 EPIC: TUI Session Management & Persistence — SQLite State & Multi-Session Tabs (v3.7.0) ## Subtasks - [ ] Define SQLite schema for sessions and conversation history - [ ] Implement session save/load/delete operations - [ ] Implement conversation history serialization/deserialization - [ ] Implement database migration support for schema changes - [ ] Write unit tests with in-memory SQLite database ## Definition of Done - Implementation complete and all acceptance criteria met - Tests written and passing (coverage >= 97%) - PR reviewed and merged - Parent epic updated --- **Automated by CleverAgents Bot** Supervisor: Epic Planning | Agent: epic-planning-pool-supervisor
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
cleveragents/cleveragents-core#10170
No description provided.