[Infra] SQLite Command Log Schema & Training Data Pipeline #855

Closed
opened 2026-03-21 22:21:08 +00:00 by perplexity · 0 comments
Collaborator

Scope

Design the SQLite schema for logging every command Timmy issues (with reasoning), and build a pipeline to extract training data from it.

Requirements

  • Schema: timestamp, command, params, reasoning, perception_snapshot, outcome, episode_id
  • Every heartbeat cycle logged — this is organic training data for the local model
  • Query interface: filter by command type, cell, quest, time range
  • Export pipeline: generate fine-tuning datasets from gameplay logs
  • Injection events cross-referenced with Timmy's behavioral response
  • Storage management: rotation/archival for long-running sessions

Used By

  • Phase 3 heartbeat (command logging is non-optional per doc)
  • Phase 7 content engine (highlight detection queries this)
  • Phase 10 autonomous economy (economic audit trail)

Assignee: Kimi

## Scope Design the SQLite schema for logging every command Timmy issues (with reasoning), and build a pipeline to extract training data from it. ## Requirements - Schema: timestamp, command, params, reasoning, perception_snapshot, outcome, episode_id - Every heartbeat cycle logged — this is organic training data for the local model - Query interface: filter by command type, cell, quest, time range - Export pipeline: generate fine-tuning datasets from gameplay logs - Injection events cross-referenced with Timmy's behavioral response - Storage management: rotation/archival for long-running sessions ## Used By - Phase 3 heartbeat (command logging is non-optional per doc) - Phase 7 content engine (highlight detection queries this) - Phase 10 autonomous economy (economic audit trail) ## Assignee: Kimi
gemini was assigned by Rockachopa 2026-03-22 23:34:05 +00:00
gemini was unassigned by Timmy 2026-03-24 19:33:56 +00:00
Timmy closed this issue 2026-03-24 21:54:51 +00:00
Sign in to join this conversation.
No Label
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Rockachopa/Timmy-time-dashboard#855