{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_365":366,"_367":368},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_106":88,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":57,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",140,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","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","createdAt",["D",1783641873854],"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",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":53,"_102":103,"_104":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"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",{"_41":42,"_31":43,"_36":360,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":361,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":362,"_82":363,"_84":364,"_86":24},"tree",[252,260,261,262,263,264,265,266,267,268,269,270,271],"files",[252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271],"counts",{"_241":61,"_242":243,"_244":61,"_245":246,"_247":248},"contents",[128,129,130,131,132,133,134,135,136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":234,"_31":235,"_29":236,"_144":-5,"_39":40,"_38":237,"_146":57,"_36":238,"_13":61,"_33":239,"_34":-5,"_23":24,"_151":-5,"_26":240},{"_41":227,"_31":228,"_29":229,"_144":-5,"_39":40,"_38":230,"_146":57,"_36":231,"_13":61,"_33":20,"_34":232,"_23":24,"_151":-5,"_26":233},{"_41":219,"_31":220,"_29":221,"_144":-5,"_39":40,"_38":222,"_146":24,"_36":223,"_13":224,"_33":20,"_34":225,"_23":24,"_151":-5,"_26":226},{"_41":212,"_31":213,"_29":214,"_144":-5,"_39":40,"_38":215,"_146":24,"_36":216,"_13":61,"_33":149,"_34":217,"_23":24,"_151":-5,"_26":218},{"_41":205,"_31":206,"_29":207,"_144":-5,"_39":40,"_38":208,"_146":24,"_36":209,"_13":164,"_33":149,"_34":210,"_23":24,"_151":-5,"_26":211},{"_41":198,"_31":199,"_29":200,"_144":-5,"_39":40,"_38":201,"_146":24,"_36":202,"_13":61,"_33":20,"_34":203,"_23":24,"_151":-5,"_26":204},{"_41":190,"_31":191,"_29":192,"_144":-5,"_39":40,"_38":193,"_146":24,"_36":194,"_13":195,"_33":149,"_34":196,"_23":24,"_151":-5,"_26":197},{"_41":183,"_31":184,"_29":185,"_144":-5,"_39":40,"_38":186,"_146":24,"_36":187,"_13":173,"_33":149,"_34":188,"_23":24,"_151":-5,"_26":189},{"_41":176,"_31":177,"_29":178,"_144":-5,"_39":40,"_38":179,"_146":24,"_36":180,"_13":61,"_33":20,"_34":181,"_23":24,"_151":-5,"_26":182},{"_41":168,"_31":169,"_29":170,"_144":-5,"_39":40,"_38":171,"_146":24,"_36":172,"_13":173,"_33":149,"_34":174,"_23":24,"_151":-5,"_26":175},{"_41":160,"_31":161,"_29":55,"_144":-5,"_39":40,"_38":162,"_146":24,"_36":163,"_13":164,"_33":165,"_34":166,"_23":24,"_151":-5,"_26":167},{"_41":153,"_31":154,"_29":155,"_144":-5,"_39":40,"_38":148,"_146":24,"_36":156,"_13":157,"_33":149,"_34":158,"_23":24,"_151":-5,"_26":159},{"_41":141,"_31":142,"_29":143,"_144":-5,"_39":40,"_38":145,"_146":24,"_36":147,"_13":148,"_33":149,"_34":150,"_23":24,"_151":-5,"_26":152},"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",[142],"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",[154],"436eb8dd-247c-49b2-828b-efc41b7321e8","main.ts",63,["D",1783571917437],7,"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",[161],"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 · v140