SQLite Web: event

thread_id

Primary key. TEXT

version

TEXT NOT NULL (default 'v1'

compacted_until_turn_id

TEXT

compacted_turn_count

INTEGER NOT NULL (default 0

summary_text

TEXT

summary_json

{"head_turns":[{"at":"2026-04-08T21:01:09.088735+00:00","id":"turn_evt_7902baf4e792","role":"user","text":"hey how are you? what's your name? do you know mine?"},{"at":"2026-04-08T21:01:49.839531+00:00","id":"turn_evt_a983fef15ea9","role":"assistant","text":"Hi! I\u2019m doing well\u2014calm, sharp, and ready. \ud83d\ude04 My name is Angela. I don\u2019t know your name yet from this chat\u2014what should I call you?"},{"at":"2026-04-08T21:02:37.458813+00:00","id":"turn_evt_ef86aa1b9d10","role":"user","text":"I'm your owner, you know my name"},{"at":"2026-04-08T21:04:30.758226+00:00","id":"turn_evt_2012b2ddb4b9","role":"user","text":"hello?"}],"middle_chunks":[],"tail_turns":[{"at":"2026-04-08T21:04:55.873448+00:00","id":"turn_evt_8324d0e44730","role":"assistant","text":"Hey Omid\u2014yep, I\u2019m Angela. \ud83d\ude04 What would you like to do next?"},{"at":"2026-04-08T21:07:43.235864+00:00","id":"turn_evt_e3e6c107dec1","role":"user","text":"okay cool, tell me a joke"},{"at":"2026-04-08T21:07:52.194483+00:00","id":"turn_evt_26a0fec6e573","role":"assistant","text":"Alright Omid\u2014here\u2019s a joke: Why don\u2019t scientists trust atoms? Because they make up everything. \ud83d\ude04"},{"at":"2026-04-08T21:08:13.992256+00:00","id":"turn_evt_ccf5dfe93109","role":"user","text":"You always tell me the same joke, tell me something creative and original"},{"at":"2026-04-08T21:08:22.480853+00:00","id":"turn_evt_a1ef9b8df102","role":"assistant","text":"Got it\u2014no repeats. Here\u2019s an original one: I tried to organize my sock drawer by color\u2026 Turns out I\u2019m not a \u201cfashion person.\u201d I\u2019m a \u201cpair-onomics\u201d person. \ud83e\udde6\ud83d\ude04"},{"at":"2026-04-08T21:09:09.080587+00:00","id":"turn_evt_c2e910660f95","role":"user","text":"okay that's funny, email this joke to my girlfriend Marian"}],"total_turns":10,"version":"v1"}

TEXT

updated_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — conversation_compaction

Update row thr_3cb85089cf8d9aec18 in conversation_compaction