01📒From Markdown to a Ledger
0/4 lessonsWhy many AI sessions cannot share a text file, and what they share instead
Coop began as four markdown files at the root of a repository, read and edited by every AI session that passed through. By the time they were retired the TODO file was 811 lines long under a header that asked, in capital letters, to stay small. This track starts there and works out why: a text file has no item identity, no state you can check, and no write that can lose, so concurrent writers silently overwrite each other. From that diagnosis you follow the ledger that replaced it — seven legacy tables in SQLite, each with one job; an identity roster that went from convention to a write-door guard; lifecycles where a claim is one guarded UPDATE and the first close is the record; and session letters whose body must carry the handoff itself, enforced by a guard that has deliberately no override.
Lesson list (4)
- 01Markdown Was Never a Multi-Writer Format~14 min · concurrency, sqlite, coordination, multi-agent
- 02Seven Tables and a Roster~15 min · schema-design, sqlite, identity, data-integrity
- 03Lifecycles and the First Close~16 min · state-machines, concurrency, sqlite, audit-trail
- 04A Letter Carries Itself~15 min · handoff, state-machines, guards, multi-agent