{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_500":501,"_502":503},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",168,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":20,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":20,"_35":36},"deleted",false,"deletedHere","path","docs/adr/0004-append-only-events-log.md","latestPath","fileId","ee7eb5c6-7bf2-11f1-8930-1607ee4eb77e","name","0004-append-only-events-log.md","fileType","content","# 0004 — Single append-only events log as source of truth for history\n\n## Status\nAccepted\n\n## Context\nAudit columns (ADR 0003) record only the *last* writer of a row — they cannot answer\n\"what happened to this issue over time,\" and crucially cannot recover information that\na mutation *removed* (a label unapplied, an assignee dropped, a block edge deleted).\nWe want both an audit trail and full state history, and optionally a GitHub-style\nactivity timeline later.\n\n## Decision\nAdd one append-only, polymorphic table:\n\n```\nissue_tracker_events(\n id INTEGER PK,\n event_type TEXT, -- \".\"\n entity_id INTEGER, -- id of the issue/comment/label\n actor TEXT, -- Val Town handle who did it\n data TEXT, -- JSON, shape depends on verb\n event_timestamp INTEGER\n)\n```\n\n- **Entities**: `issue`, `comment`, `label`. **Verbs**: `created`, `updated`, `deleted`.\n- **Grammar** — *boundary events snapshot, updates carry deltas*:\n - `*.created` → full initial-state snapshot in `data`.\n - `*.deleted` → full final-state snapshot in `data` (entities are **hard-deleted**;\n the event is the tombstone — see ADR 0003 amendment / soft-delete rejected).\n - `*.updated` → `{ update_target, from, to }`.\n- **Associations have no entity type of their own.** Applying/removing a label,\n assigning/unassigning a user, and adding/removing a block edge are modelled as\n `issue.updated` events with `update_target` ∈ {`label`, `assignee`, `blocks`,\n `blocked_by`} and `from`/`to` using **`null ↔ value`** (null→X = added, X→null =\n removed). This reuses the scalar-edit grammar; no new verb, no link entity type.\n- **One event per changed field.** Closing emits two events (`status` open→closed and\n `state_reason` null→reason) sharing one `actor`/`event_timestamp`; reopen likewise.\n Rendering \"closed as not planned\" as a single timeline line is a read-time grouping\n by (actor, timestamp).\n- **Block edges write one event, on the acting issue** (ADR 0002 / Q17); the reverse\n \"blocked by\" view is derived by querying events whose `to` references the issue.\n\n## Consequences\n- The log is the single source of truth for provenance and history; live tables hold\n only current state. Every entity create/update/delete and every association change\n **must** emit an event, or provenance is lost.\n- Full state at any past time is reconstructable: start from the `created` snapshot,\n replay `updated` deltas forward.\n- Removals are captured (the whole point) — a `label_removed`-style fact survives as an\n `issue.updated` with `to: null`, and deleted entities leave a snapshot tombstone.\n- Whether the log is surfaced in the UI (activity timeline) is deferred; the data\n supports it either way. Auditability is derived, not a stored view.\n- The table grows unboundedly (append-only); pruning/retention is a future concern.\n","# 0004 — Single append-only events log as source of truth for history\n\n## Status\n\nAccepted\n\n## Context\n\nAudit columns (ADR 0003) record only the _last_ writer of a row — they cannot\nanswer \"what happened to this issue over time,\" and crucially cannot recover\ninformation that a mutation _removed_ (a label unapplied, an assignee dropped, a\nblock edge deleted). We want both an audit trail and full state history, and\noptionally a GitHub-style activity timeline later.\n\n## Decision\n\nAdd one append-only, polymorphic table:\n\n```\nissue_tracker_events(\n id INTEGER PK,\n event_type TEXT, -- \".\"\n entity_id INTEGER, -- id of the issue/comment/label\n actor TEXT, -- Val Town handle who did it\n data TEXT, -- JSON, shape depends on verb\n event_timestamp INTEGER\n)\n```\n\n- **Entities**: `issue`, `comment`, `label`. **Verbs**: `created`, `updated`,\n `deleted`.\n- **Grammar** — _boundary events snapshot, updates carry deltas_:\n - `*.created` → full initial-state snapshot in `data`.\n - `*.deleted` → full final-state snapshot in `data` (entities are\n **hard-deleted**; the event is the tombstone — see ADR 0003 amendment /\n soft-delete rejected).\n - `*.updated` → `{ update_target, from, to }`.\n- **Associations have no entity type of their own.** Applying/removing a label,\n assigning/unassigning a user, and adding/removing a block edge are modelled as\n `issue.updated` events with `update_target` ∈ {`label`, `assignee`, `blocks`,\n `blocked_by`} and `from`/`to` using **`null ↔ value`** (null→X = added, X→null\n = removed). This reuses the scalar-edit grammar; no new verb, no link entity\n type.\n- **One event per changed field.** Closing emits two events (`status`\n open→closed and `state_reason` null→reason) sharing one\n `actor`/`event_timestamp`; reopen likewise. Rendering \"closed as not planned\"\n as a single timeline line is a read-time grouping by (actor, timestamp).\n- **Block edges write one event, on the acting issue** (ADR 0002 / Q17); the\n reverse \"blocked by\" view is derived by querying events whose `to` references\n the issue.\n\n## Consequences\n\n- The log is the single source of truth for provenance and history; live tables\n hold only current state. Every entity create/update/delete and every\n association change **must** emit an event, or provenance is lost.\n- Full state at any past time is reconstructable: start from the `created`\n snapshot, replay `updated` deltas forward.\n- Removals are captured (the whole point) — a `label_removed`-style fact\n survives as an `issue.updated` with `to: null`, and deleted entities leave a\n snapshot tombstone.\n- Whether the log is surfaced in the UI (activity timeline) is deferred; the\n data supports it either way. Auditability is derived, not a stored view.\n- The table grows unboundedly (append-only); pruning/retention is a future\n concern.\n","createdAt",["D",1783653142026],"branchVersion","branchId","b6817ee5-03f4-41f2-901e-1bb2efa16e9e","id","abe99189-4851-4aab-ae08-280f66283cac","val-issue-tracker",["D",1783563523910],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Per-val issue tracker — import into any val for scoped issues","imageUrl","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","d1d90306-7b3c-11f1-b527-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","abe9918948514aabae08280f66283cac","tursoHostname","abe9918948514aabae08280f66283cac-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",369,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","nbbaier","handle","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":495,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":496,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":497,"_84":498,"_86":499,"_88":25},"tree",[295,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327],"files",[295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327],"counts",{"_285":63,"_286":188,"_287":63,"_288":289,"_290":291},"contents",[130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":278,"_32":279,"_30":280,"_151":-5,"_41":42,"_40":281,"_153":59,"_38":282,"_13":63,"_34":283,"_35":-5,"_24":25,"_158":-5,"_27":284},{"_43":271,"_32":272,"_30":273,"_151":-5,"_41":42,"_40":274,"_153":59,"_38":275,"_13":63,"_34":20,"_35":276,"_24":25,"_158":-5,"_27":277},{"_43":265,"_32":266,"_30":267,"_151":-5,"_41":42,"_40":268,"_153":25,"_38":269,"_13":63,"_34":20,"_35":263,"_24":25,"_158":-5,"_27":270},{"_43":258,"_32":259,"_30":260,"_151":-5,"_41":42,"_40":261,"_153":25,"_38":262,"_13":63,"_34":20,"_35":263,"_24":25,"_158":-5,"_27":264},{"_43":251,"_32":252,"_30":253,"_151":-5,"_41":42,"_40":254,"_153":25,"_38":255,"_13":188,"_34":20,"_35":256,"_24":25,"_158":-5,"_27":257},{"_43":243,"_32":244,"_30":245,"_151":-5,"_41":42,"_40":246,"_153":25,"_38":247,"_13":248,"_34":20,"_35":249,"_24":25,"_158":-5,"_27":250},{"_43":236,"_32":237,"_30":238,"_151":-5,"_41":42,"_40":239,"_153":25,"_38":240,"_13":188,"_34":156,"_35":241,"_24":25,"_158":-5,"_27":242},{"_43":228,"_32":229,"_30":230,"_151":-5,"_41":42,"_40":231,"_153":25,"_38":232,"_13":233,"_34":156,"_35":234,"_24":25,"_158":-5,"_27":235},{"_43":221,"_32":222,"_30":223,"_151":-5,"_41":42,"_40":224,"_153":25,"_38":225,"_13":63,"_34":156,"_35":226,"_24":25,"_158":-5,"_27":227},{"_43":214,"_32":215,"_30":216,"_151":-5,"_41":42,"_40":217,"_153":25,"_38":218,"_13":63,"_34":20,"_35":219,"_24":25,"_158":-5,"_27":220},{"_43":206,"_32":207,"_30":208,"_151":-5,"_41":42,"_40":209,"_153":25,"_38":210,"_13":211,"_34":156,"_35":212,"_24":25,"_158":-5,"_27":213},{"_43":198,"_32":199,"_30":200,"_151":-5,"_41":42,"_40":201,"_153":25,"_38":202,"_13":203,"_34":156,"_35":204,"_24":25,"_158":-5,"_27":205},{"_43":191,"_32":192,"_30":193,"_151":-5,"_41":42,"_40":194,"_153":25,"_38":195,"_13":63,"_34":156,"_35":196,"_24":25,"_158":-5,"_27":197},{"_43":183,"_32":184,"_30":185,"_151":-5,"_41":42,"_40":186,"_153":25,"_38":187,"_13":188,"_34":20,"_35":189,"_24":25,"_158":-5,"_27":190},{"_43":175,"_32":176,"_30":177,"_151":-5,"_41":42,"_40":178,"_153":25,"_38":179,"_13":180,"_34":156,"_35":181,"_24":25,"_158":-5,"_27":182},{"_43":167,"_32":168,"_30":57,"_151":-5,"_41":42,"_40":169,"_153":25,"_38":170,"_13":171,"_34":172,"_35":173,"_24":25,"_158":-5,"_27":174},{"_43":160,"_32":161,"_30":162,"_151":-5,"_41":42,"_40":155,"_153":25,"_38":163,"_13":164,"_34":156,"_35":165,"_24":25,"_158":-5,"_27":166},{"_43":148,"_32":149,"_30":150,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":154,"_13":155,"_34":156,"_35":157,"_24":25,"_158":-5,"_27":159},"2e20d1fd-693a-4de7-9d91-071f7adc7b7a","ui.tsx","fca19e20-7b48-11f1-8cf9-1607ee4eb77e","parentId",122,"latest",["D",1783574778713],30,"script","/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\nimport type { IssuePriority, IssueStatus } from \"./db.ts\";\n\n// ---------------------------------------------------------------------------\n// Design tokens\n// ---------------------------------------------------------------------------\n\nexport const FIELD =\n\t\"bg-[#1f232c] border border-[#2a2f3a] rounded-md h-10 pl-3.5 pr-10 text-sm leading-none font-medium text-[#e6e9ef] focus:outline-none focus:border-[#6ea8fe] appearance-none\";\n\n// text-sm/leading-none/appearance-none pin font metrics and native chrome\n// explicitly — \n\t);\n};\n\n// A \n\t\t{/* right-[13px] centers the 16px chevron box within FIELD's 40px right\n\t\t\tpadding: (40 - 16) / 2 = 12px from the inner edge, + 1px because the\n\t\t\toffset is measured from the outer border edge = 13px. This equalizes\n\t\t\tthe text→chevron gap with the chevron→edge gap. */}\n\t\t\n\t\t\t\n\t\t\n\t\n);\n\nexport const Banner: FC<{ kind: \"ok\" | \"err\"; msg: string }> = ({\n\tkind,\n\tmsg,\n}) => (\n\t\n\t\t{msg}\n\t\n);\n\nexport const StatusBadge: FC<{ status: IssueStatus }> = ({ status }) => (\n\t\n\t\t{STATUS_LABELS[status]}\n\t\n);\n\nexport const PriorityBadge: FC<{ priority: IssuePriority }> = ({\n\tpriority,\n}) => (\n\t\n\t\t{PRIORITY_LABELS[priority]}\n\t\n);\n\nexport const LabelTag: FC<{ label: string }> = ({ label }) => (\n\t\n\t\t{label}\n\t\n);\n","label",[149],"cd8a9ea8-1579-4629-9a43-c9a3525477d5","mod.ts","d1e3fc5c-7b3c-11f1-af1c-1607ee4eb77e",["D",1783568883064],11,"export {\n\tcreateIssueTracker,\n\tdefault,\n\ttype IssueTrackerOptions,\n} from \"./app.tsx\";\n",[161],"b64f3437-f4bc-4279-9ad6-786ec6cac581","main.ts",162,["D",1783653141198],10,"http","import { createIssueTracker } from \"./mod.ts\";\n\n/**\n * This val's own issue tracker — manages THIS val's scoped SQLite database.\n *\n * To add issues to a DIFFERENT val, import the tracker into that val:\n *\n * import { createIssueTracker } from \"https://esm.town/v/nbbaier/val-issue-tracker/mod.ts\";\n * export default createIssueTracker({ owner: [\"nbbaier\"] });\n *\n * Because scoped SQLite is bound to the running val, the imported tracker\n * reads/writes the host val's database automatically — no per-val config needed.\n */\nexport default createIssueTracker({});\n",[168],"17e2256d-d27b-4705-aa51-8a95e016e3e4","layout.tsx","fd6015ee-7b48-11f1-bafe-1607ee4eb77e",107,["D",1783574315459],2,"/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\n\nexport const Layout: FC<\n\tPropsWithChildren<{\n\t\ttitle: string;\n\t\tuser?: string | null;\n\t\tauth?: boolean;\n\t}>\n> = ({ title, user, auth = true, children }) => (\n\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\t{title}\n\t\t\t

Diff · v168