Query

event_store.db — conversation_compaction

+/- table definition

Query 

CREATE TABLE conversation_compaction  (
  thread_id TEXT PRIMARY KEY,
  version TEXT NOT NULL DEFAULT 'v1',
  compacted_until_turn_id TEXT,
  compacted_turn_count INTEGER NOT NULL DEFAULT 0,
  summary_text TEXT,
  summary_json TEXT,
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  FOREIGN KEY (compacted_until_turn_id) REFERENCES conversation_turns(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop