{title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_514":515,"_516":517},"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",183,"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/0002-blocking-graph-integrity.md","latestPath","fileId","eedbe340-7bf2-11f1-a9f4-1607ee4eb77e","name","0002-blocking-graph-integrity.md","fileType","content","# 0002 — Blocking graph is a strict DAG (reject all cycles)\n\n## Status\nAccepted\n\n## Context\nIssues can block each other, forming a directed graph stored as edges in\n`issue_tracker_issue_blocks(blocker_id, blocked_id)` (edge direction: blocker → blocked).\nSuch a graph can contain degenerate or cyclic edges:\n\n- **Self-edge** — A blocks A.\n- **Direct reciprocal** — A blocks B and B blocks A.\n- **Longer cycle** — A blocks B, B blocks C, C blocks A.\n\nGitHub, empirically, rejects self-edges and direct reciprocals but *allows* longer\ncycles like A→B→C→A (verified against its GraphQL `blockedBy`/`blocking` API). We\ndeliberately do **not** follow GitHub here.\n\n## Decision\nEnforce a strict DAG — reject **any** edge that would create a cycle. All three cases\nabove collapse into one rule, checked on insert of edge `blocker → blocked`:\n\n> Reject if `blocked` can already reach `blocker` by following block-edges — i.e. a\n> path `blocked → … → blocker` already exists (a self-edge is the degenerate\n> `blocked == blocker` case).\n\nImplemented as a reachability query (SQLite `WITH RECURSIVE`) run in the database on\neach insert. `UNIQUE(blocker_id, blocked_id)` additionally prevents duplicate edges.\n\n## Rationale\nA cycle in a dependency graph is logically incoherent: a loop of issues that can never\nbe satisfied in dependency order. Keeping the graph a strict DAG also preserves the\noption to add topological \"what's workable now\" ordering later without retrofitting\ncycle detection.\n\n## Consequences\n- Every edge insert pays for one reachability traversal. For a personal/small-team\n tracker's graph size this is negligible, and it runs entirely in SQLite.\n- The block graph is guaranteed acyclic, so downstream features may safely assume a\n topological order exists.\n- This is stricter than GitHub; anyone porting expectations from GitHub should know\n that A→B→C→A is refused here.\n","# 0002 — Blocking graph is a strict DAG (reject all cycles)\n\n## Status\n\nAccepted\n\n## Context\n\nIssues can block each other, forming a directed graph stored as edges in\n`issue_tracker_issue_blocks(blocker_id, blocked_id)` (edge direction: blocker →\nblocked). Such a graph can contain degenerate or cyclic edges:\n\n- **Self-edge** — A blocks A.\n- **Direct reciprocal** — A blocks B and B blocks A.\n- **Longer cycle** — A blocks B, B blocks C, C blocks A.\n\nGitHub, empirically, rejects self-edges and direct reciprocals but _allows_\nlonger cycles like A→B→C→A (verified against its GraphQL `blockedBy`/`blocking`\nAPI). We deliberately do **not** follow GitHub here.\n\n## Decision\n\nEnforce a strict DAG — reject **any** edge that would create a cycle. All three\ncases above collapse into one rule, checked on insert of edge\n`blocker → blocked`:\n\n> Reject if `blocked` can already reach `blocker` by following block-edges —\n> i.e. a path `blocked → … → blocker` already exists (a self-edge is the\n> degenerate `blocked == blocker` case).\n\nImplemented as a reachability query (SQLite `WITH RECURSIVE`) run in the\ndatabase on each insert. `UNIQUE(blocker_id, blocked_id)` additionally prevents\nduplicate edges.\n\n## Rationale\n\nA cycle in a dependency graph is logically incoherent: a loop of issues that can\nnever be satisfied in dependency order. Keeping the graph a strict DAG also\npreserves the option to add topological \"what's workable now\" ordering later\nwithout retrofitting cycle detection.\n\n## Consequences\n\n- Every edge insert pays for one reachability traversal. For a\n personal/small-team tracker's graph size this is negligible, and it runs\n entirely in SQLite.\n- The block graph is guaranteed acyclic, so downstream features may safely\n assume a topological order exists.\n- This is stricter than GitHub; anyone porting expectations from GitHub should\n know that A→B→C→A is refused here.\n","createdAt",["D",1783653141615],"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":509,"_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":510,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":511,"_84":512,"_86":513,"_88":25},"tree",[304,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337],"files",[304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337],"counts",{"_294":63,"_295":197,"_296":63,"_297":298,"_299":300},"contents",[130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":287,"_32":288,"_30":289,"_152":-5,"_41":42,"_40":290,"_154":59,"_38":291,"_13":63,"_34":292,"_35":-5,"_24":25,"_159":-5,"_27":293},{"_43":280,"_32":281,"_30":282,"_152":-5,"_41":42,"_40":283,"_154":59,"_38":284,"_13":63,"_34":20,"_35":285,"_24":25,"_159":-5,"_27":286},{"_43":274,"_32":275,"_30":276,"_152":-5,"_41":42,"_40":277,"_154":25,"_38":278,"_13":197,"_34":20,"_35":272,"_24":25,"_159":-5,"_27":279},{"_43":267,"_32":268,"_30":269,"_152":-5,"_41":42,"_40":270,"_154":25,"_38":271,"_13":197,"_34":20,"_35":272,"_24":25,"_159":-5,"_27":273},{"_43":260,"_32":261,"_30":262,"_152":-5,"_41":42,"_40":263,"_154":25,"_38":264,"_13":197,"_34":20,"_35":265,"_24":25,"_159":-5,"_27":266},{"_43":252,"_32":253,"_30":254,"_152":-5,"_41":42,"_40":255,"_154":25,"_38":256,"_13":257,"_34":20,"_35":258,"_24":25,"_159":-5,"_27":259},{"_43":245,"_32":246,"_30":247,"_152":-5,"_41":42,"_40":248,"_154":25,"_38":249,"_13":197,"_34":157,"_35":250,"_24":25,"_159":-5,"_27":251},{"_43":237,"_32":238,"_30":239,"_152":-5,"_41":42,"_40":240,"_154":25,"_38":241,"_13":242,"_34":157,"_35":243,"_24":25,"_159":-5,"_27":244},{"_43":230,"_32":231,"_30":232,"_152":-5,"_41":42,"_40":233,"_154":25,"_38":234,"_13":63,"_34":157,"_35":235,"_24":25,"_159":-5,"_27":236},{"_43":223,"_32":224,"_30":225,"_152":-5,"_41":42,"_40":226,"_154":25,"_38":227,"_13":63,"_34":20,"_35":228,"_24":25,"_159":-5,"_27":229},{"_43":215,"_32":216,"_30":217,"_152":-5,"_41":42,"_40":218,"_154":25,"_38":219,"_13":220,"_34":157,"_35":221,"_24":25,"_159":-5,"_27":222},{"_43":207,"_32":208,"_30":209,"_152":-5,"_41":42,"_40":210,"_154":25,"_38":211,"_13":212,"_34":157,"_35":213,"_24":25,"_159":-5,"_27":214},{"_43":200,"_32":201,"_30":202,"_152":-5,"_41":42,"_40":203,"_154":25,"_38":204,"_13":63,"_34":157,"_35":205,"_24":25,"_159":-5,"_27":206},{"_43":192,"_32":193,"_30":194,"_152":-5,"_41":42,"_40":195,"_154":25,"_38":196,"_13":197,"_34":20,"_35":198,"_24":25,"_159":-5,"_27":199},{"_43":184,"_32":185,"_30":186,"_152":-5,"_41":42,"_40":187,"_154":25,"_38":188,"_13":189,"_34":157,"_35":190,"_24":25,"_159":-5,"_27":191},{"_43":176,"_32":177,"_30":57,"_152":-5,"_41":42,"_40":178,"_154":25,"_38":179,"_13":180,"_34":181,"_35":182,"_24":25,"_159":-5,"_27":183},{"_43":168,"_32":169,"_30":170,"_152":-5,"_41":42,"_40":171,"_154":25,"_38":172,"_13":173,"_34":157,"_35":174,"_24":25,"_159":-5,"_27":175},{"_43":161,"_32":162,"_30":163,"_152":-5,"_41":42,"_40":164,"_154":25,"_38":165,"_13":63,"_34":157,"_35":166,"_24":25,"_159":-5,"_27":167},{"_43":149,"_32":150,"_30":151,"_152":-5,"_41":42,"_40":153,"_154":25,"_38":155,"_13":156,"_34":157,"_35":158,"_24":25,"_159":-5,"_27":160},"6516dd91-8c76-4357-ab20-f54e296757c4","ui.tsx","fca19e20-7b48-11f1-8cf9-1607ee4eb77e","parentId",181,"latest",["D",1783653143543],31,"script","/** @jsxImportSource npm:hono@4.6.14/jsx */\nimport type { FC, PropsWithChildren } from \"npm:hono@4.6.14/jsx\";\nimport type { IssueStatus, Label, StateReason } from \"./db.ts\";\n\nexport const FIELD =\n\t\"bg-[#1f232c] border border-[#2a2f3a] rounded-md min-h-10 px-3.5 text-sm font-medium text-[#e6e9ef] focus:outline-none focus:border-[#6ea8fe]\";\nconst BUTTON =\n\t\"inline-flex items-center gap-1.5 rounded-md min-h-10 px-3.5 text-sm font-medium cursor-pointer no-underline\";\nconst VARIANTS = {\n\tsolid: \"bg-[#3d7bf0] border border-[#3d7bf0] text-white hover:brightness-110\",\n\tghost:\n\t\t\"bg-transparent border border-[#3d7bf0] text-[#e6e9ef] hover:brightness-110\",\n\tdanger:\n\t\t\"bg-transparent border border-[#f06e7b] text-[#f06e7b] hover:bg-[#f06e7b] hover:text-white\",\n} as const;\n\nexport const STATUS_LABELS: Record = {\n\topen: \"Open\",\n\tclosed: \"Closed\",\n};\nexport const STATE_REASON_LABELS: Record, string> = {\n\tcompleted: \"Completed\",\n\tnot_planned: \"Not planned\",\n\tduplicate: \"Duplicate\",\n\treopened: \"Reopened\",\n};\n\nexport const Card: FC> = ({\n\tchildren,\n\tclass: cls,\n}) => (\n\t\n\t\t{children}\n\t\n);\n\nexport const Button: FC<\n\tPropsWithChildren<{\n\t\tvariant?: keyof typeof VARIANTS;\n\t\thref?: string;\n\t\ttype?: \"button\" | \"submit\";\n\t\tclass?: string;\n\t\tname?: string;\n\t\tvalue?: string;\n\t}>\n> = ({\n\tvariant = \"solid\",\n\thref,\n\ttype = \"button\",\n\tclass: cls,\n\tname,\n\tvalue,\n\tchildren,\n}) => {\n\tconst classes = `${BUTTON} ${VARIANTS[variant]} ${cls ?? \"\"}`;\n\treturn href ? (\n\t\t\n\t\t\t{children}\n\t\t\n\t) : (\n\t\t\n\t);\n};\n\nexport const Select: FC<\n\tPropsWithChildren<{ name: string; id?: string; class?: string }>\n> = ({ name, id, class: cls, children }) => (\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; reason?: StateReason }> = ({\n\tstatus,\n\treason,\n}) => (\n\t\n\t\t{STATUS_LABELS[status]}\n\t\t{reason ? ` · ${STATE_REASON_LABELS[reason]}` : \"\"}\n\t\n);\n\nexport const LabelTag: FC<{ label: Label }> = ({ label }) => (\n\t\n\t\t{label.name}\n\t\n);\n","label",[150],"d01523f3-a791-45be-9ba0-d5290866a864","test_sqlite.ts","2bb2ce86-7c0d-11f1-9a68-1607ee4eb77e",180,["D",1783653141033],"// @ts-ignore Deno 2 provides node:sqlite; an older transitive @types/node may shadow it.\nimport { DatabaseSync } from \"node:sqlite\";\n\nexport interface TestResultSet {\n\tcolumns: string[];\n\trows: Record[];\n\trowsAffected: number;\n\tlastInsertRowid: bigint | undefined;\n}\n\nexport function createTestSqlite() {\n\tconst database = new DatabaseSync(\":memory:\");\n\tdatabase.exec(\"PRAGMA foreign_keys = ON\");\n\n\tconst execute = (\n\t\tstatement: string | { sql: string; args?: unknown[] },\n\t): Promise => {\n\t\tconst sql = typeof statement === \"string\" ? statement : statement.sql;\n\t\tconst args = typeof statement === \"string\" ? [] : (statement.args ?? []);\n\t\tconst prepared = database.prepare(sql);\n\t\tif (/^\\s*(SELECT|PRAGMA|WITH)\\b/i.test(sql)) {\n\t\t\tconst rows = prepared.all(...(args as never[])) as Record<\n\t\t\t\tstring,\n\t\t\t\tunknown\n\t\t\t>[];\n\t\t\treturn Promise.resolve({\n\t\t\t\tcolumns: rows[0] ? Object.keys(rows[0]) : [],\n\t\t\t\trows,\n\t\t\t\trowsAffected: 0,\n\t\t\t\tlastInsertRowid: undefined,\n\t\t\t});\n\t\t}\n\t\tconst result = prepared.run(...(args as never[]));\n\t\treturn Promise.resolve({\n\t\t\tcolumns: [],\n\t\t\trows: [],\n\t\t\trowsAffected: Number(result.changes),\n\t\t\tlastInsertRowid: BigInt(result.lastInsertRowid),\n\t\t});\n\t};\n\n\treturn {\n\t\tdatabase,\n\t\texecute,\n\t\tasync batch(statements: Array) {\n\t\t\tdatabase.exec(\"BEGIN IMMEDIATE\");\n\t\t\ttry {\n\t\t\t\tconst results = [];\n\t\t\t\tfor (const statement of statements) {\n\t\t\t\t\tresults.push(await execute(statement));\n\t\t\t\t}\n\t\t\t\tdatabase.exec(\"COMMIT\");\n\t\t\t\treturn results;\n\t\t\t} catch (error) {\n\t\t\t\tdatabase.exec(\"ROLLBACK\");\n\t\t\t\tthrow error;\n\t\t\t}\n\t\t},\n\t};\n}\n",[162],"cd8a9ea8-1579-4629-9a43-c9a3525477d5","mod.ts","d1e3fc5c-7b3c-11f1-af1c-1607ee4eb77e",30,["D",1783568883064],11,"export {\n\tcreateIssueTracker,\n\tdefault,\n\ttype IssueTrackerOptions,\n} from \"./app.tsx\";\n",[169],"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",[177],"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 · v183