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

Thread has 15 turns. Early context: - U:hey how are you? what's your name? do you know mine? - A:Angela here 😄 I’m doing well—thanks for asking. My name is Angela. I don’t know your name yet from this thread, but tell me what you’d like - U:I'm your owner haha - A:Haha got it 😄 I’m Angela—your calm, sharp LifeOS operator. What should I call you, Omid? Compacted middle timeline: - turns 5-7: 2U/1A/0S; start U:Omid is good lol. Anyway tell me a funny original joke; end U:hahha this is funny. Now put this in an email message to my girlfriend Marian saying that I thought of her and I wanted Recent context: - A:I can do that—what email address should I send it to (Marian’s), and do you want the subject line to be something specific or should I choos - U:<mailto:mare0987@gmail.com|mare0987@gmail.com> and you can choose one - A:Perfect—Marian’s email is mare0987@gmail.com. What subject line do you want, or should I pick one? (If you say “pick one,” I’ll send it righ - U:pick one - A:Got it 😄 I’ll pick a subject line and send the email to Marian (mare0987@gmail.com) now. - A:*Approval needed* *email send* _tier:_ `T2` _risk:_ `tier_requires_approval` _User requested to email Marian with a specific friendly messag - U:approve - A:Done: Email sent: A little smile from Omid -> mare0987@gmail.com Evidence: action_id=`act_72fcc1f3d303`, approval_id=`appr_6c0e976788`, prop

TEXT

summary_json

{"head_turns":[{"at":"2026-04-08T22:07:06.211915+00:00","id":"turn_evt_afb9a2134503","role":"user","text":"hey how are you? what's your name? do you know mine?"},{"at":"2026-04-08T22:07:28.577559+00:00","id":"turn_evt_78b9e199ffb9","role":"assistant","text":"Angela here \ud83d\ude04 I\u2019m doing well\u2014thanks for asking. My name is Angela. I don\u2019t know your name yet from this thread, but tell me what you\u2019d like me to call you."},{"at":"2026-04-08T22:08:14.588780+00:00","id":"turn_evt_cfdf0e7afc40","role":"user","text":"I'm your owner haha"},{"at":"2026-04-08T22:08:25.674664+00:00","id":"turn_evt_070ec4731ebf","role":"assistant","text":"Haha got it \ud83d\ude04 I\u2019m Angela\u2014your calm, sharp LifeOS operator. What should I call you, Omid?"}],"middle_chunks":[{"end_turn":7,"start_turn":5,"summary":"2U/1A/0S; start U:Omid is good lol. Anyway tell me a funny original joke; end U:hahha this is funny. Now put this in an email message to my girlfriend Marian saying that I thought of her and I wanted"}],"tail_turns":[{"at":"2026-04-08T22:11:15.407157+00:00","id":"turn_evt_19229ebbd675","role":"assistant","text":"I can do that\u2014what email address should I send it to (Marian\u2019s), and do you want the subject line to be something specific or should I choose one?"},{"at":"2026-04-08T22:11:38.714819+00:00","id":"turn_evt_a602dd8f2383","role":"user","text":"<mailto:mare0987@gmail.com|mare0987@gmail.com> and you can choose one"},{"at":"2026-04-08T22:11:51.622785+00:00","id":"turn_evt_f806c7533fcc","role":"assistant","text":"Perfect\u2014Marian\u2019s email is mare0987@gmail.com. What subject line do you want, or should I pick one? (If you say \u201cpick one,\u201d I\u2019ll send it right away.)"},{"at":"2026-04-08T22:12:05.733215+00:00","id":"turn_evt_680353590205","role":"user","text":"pick one"},{"at":"2026-04-08T22:12:18.227662+00:00","id":"turn_evt_9f95d248782c","role":"assistant","text":"Got it \ud83d\ude04 I\u2019ll pick a subject line and send the email to Marian (mare0987@gmail.com) now."},{"at":"2026-04-08T22:13:49.265594+00:00","id":"turn_evt_e3ed340ab037","role":"assistant","text":"*Approval needed* *email send* _tier:_ `T2` _risk:_ `tier_requires_approval` _User requested to email Marian with a specific friendly message; subject line can be chosen automatically since user said "},{"at":"2026-04-08T22:14:05.903774+00:00","id":"turn_evt_7b2af2a9eb37","role":"user","text":"approve"},{"at":"2026-04-08T22:14:10.731138+00:00","id":"turn_evt_e87cc178ab3e","role":"assistant","text":"Done: Email sent: A little smile from Omid -> mare0987@gmail.com Evidence: action_id=`act_72fcc1f3d303`, approval_id=`appr_6c0e976788`, proposal_id=`prop_94edb86c29771573e0ca4433`"}],"total_turns":15,"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_a323a945dfd434d4fa in conversation_compaction