[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_196":197,"_198":199},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_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":58,"_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":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",21,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","http.ts","latestPath","fileId","166430f4-b1f7-11f1-bd53-1607ee4eb77e","name","fileType","http","content","// Learn more: https://docs.val.town/vals/http/\nexport default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","// http.ts — the val's HTTP entry point. Same routes as server.js\n// (minus /api/agent, which we dropped along with the summaries),\n// rebuilt on Web-standard Request/Response instead of Node's http\n// module, and on db.ts instead of in-memory state.\n\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport * as db from \"./db.ts\";\nimport { toMarkdown } from \"./markdown.ts\";\n\nconst KINDS = [\"idea\", \"usecase\", \"concern\", \"question\", \"offer\"];\nconst TOKEN = Deno.env.get(\"PRESENTER_TOKEN\") || \"\";\nconst MAX_NOTES = 1000;\n\nfunction json(body: unknown, status = 200): Response {\n return new Response(JSON.stringify(body), {\n status,\n headers: {\n \"content-type\": \"application/json; charset=utf-8\",\n \"cache-control\": \"no-store\",\n \"x-content-type-options\": \"nosniff\",\n \"referrer-policy\": \"no-referrer\",\n },\n });\n}\n\n// Same-length, full-scan comparison — not exploitably timing-sensitive\n// at this traffic scale, and avoids pulling in Node's crypto module.\nfunction sameToken(given: unknown): boolean {\n if (!TOKEN || typeof given !== \"string\" || given.length !== TOKEN.length) {\n return false;\n }\n let diff = 0;\n for (let i = 0; i < TOKEN.length; i++) {\n diff |= given.charCodeAt(i) ^ TOKEN.charCodeAt(i);\n }\n return diff === 0;\n}\n\nfunction clientIp(req: Request): string {\n return (\n req.headers.get(\"x-forwarded-for\")?.split(\",\")[0].trim() ||\n req.headers.get(\"cf-connecting-ip\") ||\n \"unknown\"\n );\n}\n\nasync function readJson(req: Request): Promise {\n try {\n return await req.json();\n } catch {\n return {};\n }\n}\n\nexport default async function (req: Request): Promise {\n if (!TOKEN) {\n return json({ error: \"PRESENTER_TOKEN is not set on this val\" }, 500);\n }\n\n const url = new URL(req.url);\n const ip = clientIp(req);\n\n if (\n req.method === \"GET\" &&\n (url.pathname === \"/\" || url.pathname === \"/index.html\")\n ) {\n const html = await readFile(\"index.html\", import.meta.url);\n return new Response(html, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-store\",\n },\n });\n }\n\n if (req.method === \"GET\" && url.pathname === \"/api/state\") {\n await db.touchPresence(ip);\n const since = Number(url.searchParams.get(\"since\") || 0);\n const [notes, votes, seq, online, total, prompt] = await Promise.all([\n db.notesSince(since),\n db.votesUpTo(since),\n db.maxSeq(),\n db.onlineCount(),\n db.totalCount(),\n db.getPrompt(),\n ]);\n return json({ notes, votes, seq, prompt, online, total });\n }\n\n if (req.method === \"POST\" && url.pathname === \"/api/notes\") {\n const okToPost = await db.checkRate(ip, 2500);\n if (!okToPost) {\n return json({ error: \"One at a time — try again in a moment.\" }, 429);\n }\n if ((await db.totalCount()) >= MAX_NOTES) {\n return json({ error: \"The board is full.\" }, 507);\n }\n\n const b = await readJson(req);\n const text = String(b.text || \"\").trim().slice(0, 600);\n if (text.length < 3) {\n return json({ error: \"Add a line of text first.\" }, 400);\n }\n\n const n = await db.addNote({\n id: crypto.randomUUID().slice(0, 8),\n t: Date.now(),\n kind: KINDS.includes(b.kind) ? b.kind : \"idea\",\n text,\n name: String(b.name || \"\").trim().slice(0, 40),\n centre: String(b.centre || \"\").trim().slice(0, 60),\n });\n return json({ ok: true, id: n.id });\n }\n\n if (req.method === \"POST\" && url.pathname === \"/api/vote\") {\n const b = await readJson(req);\n const votes = await db.castVote(String(b.id || \"\"), ip);\n if (votes === null) return json({ error: \"no such note\" }, 404);\n return json({ ok: true, votes });\n }\n\n if (req.method === \"POST\" && url.pathname === \"/api/unlock\") {\n const b = await readJson(req);\n return sameToken(b.token)\n ? json({ ok: true })\n : json({ error: \"wrong passcode\" }, 403);\n }\n\n if (req.method === \"POST\" && url.pathname === \"/api/prompt\") {\n const b = await readJson(req);\n if (!sameToken(b.token)) return json({ error: \"wrong passcode\" }, 403);\n const prompt = await db.setPrompt(\n String(b.text || \"\").trim().slice(0, 200),\n );\n return json({ ok: true, prompt });\n }\n\n if (req.method === \"GET\" && url.pathname === \"/api/export\") {\n if (!sameToken(url.searchParams.get(\"token\"))) {\n return json({ error: \"wrong passcode\" }, 403);\n }\n const notes = await db.allNotes();\n if (url.searchParams.get(\"format\") === \"md\") {\n return new Response(toMarkdown(notes), {\n headers: {\n \"content-type\": \"text/markdown; charset=utf-8\",\n \"cache-control\": \"no-store\",\n },\n });\n }\n return json({\n session: \"EULAR Big Data & AI Study Group, 18 September 2026\",\n exported: new Date().toISOString(),\n notes: notes.map((n) => ({\n at: new Date(n.t).toISOString(),\n kind: n.kind,\n votes: n.votes,\n text: n.text,\n name: n.name,\n centre: n.centre,\n })),\n });\n }\n\n return json({ error: \"not found\" }, 404);\n}","createdAt",["D",1789581065304],"branchVersion","branchId","36e9c483-8011-4cee-9897-5cea25dc6ac2","id","31856024-73f2-4985-b3c5-d15fb530b917","strata-fit-board",["D",1789580405959],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Chat board","imageUrl","5655f697-f970-446c-930e-7aa57f6e7aa6","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0ab4c-476b-763b-a1b6-c99244cfd606","tursoName","3185602473f24985b3c5d15fb530b917","tursoHostname","3185602473f24985b3c5d15fb530b917-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789582272237],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ivanzhovannik","handle","displayName","Ivan Zhovannik","avatar","https://lh3.googleusercontent.com/a/ACg8ocKggA35N2ptIs8Od95m-QCDdcK-XaH-2tmlhnjXjErkvnxNgxki=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":191,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":192,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":193,"_83":194,"_85":195,"_87":25},"tree",[174,175,176,177],"files",[174,175,176,177],"counts",{"_163":62,"_164":165,"_166":62,"_167":168,"_169":170},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":156,"_32":157,"_30":158,"_137":-5,"_41":42,"_40":159,"_139":25,"_38":160,"_13":141,"_33":142,"_35":161,"_24":25,"_144":-5,"_27":162},{"_43":153,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":154,"_13":141,"_33":34,"_35":37,"_24":25,"_144":-5,"_27":155},{"_43":146,"_32":147,"_30":148,"_137":-5,"_41":42,"_40":149,"_139":25,"_38":150,"_13":141,"_33":142,"_35":151,"_24":25,"_144":-5,"_27":152},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":58,"_38":140,"_13":141,"_33":142,"_35":143,"_24":25,"_144":-5,"_27":145},"67e2bb2c-25fc-47e6-add8-bb46b3ad3573","markdown.ts","17ecf128-b1f6-11f1-bc56-1607ee4eb77e","parentId",14,"latest",["D",1789580761831],2,"script","// markdown.ts — the same grouped, vote-sorted wrap-up server.js produced,\n// just taking notes as an argument instead of reading a module-level array.\n\nconst KINDS = [\"idea\", \"usecase\", \"concern\", \"question\", \"offer\"];\nconst LABEL: Record = {\n idea: \"Idea\",\n usecase: \"Use case\",\n concern: \"Concern\",\n question: \"Question\",\n offer: \"Wants to collaborate\",\n};\n\nexport function toMarkdown(notes: any[]): string {\n const lines = [\n \"# STRATA-FIT live board — EULAR Big Data & AI Study Group, 18 September 2026\",\n \"\",\n notes.length + \" notes.\",\n \"\",\n ];\n KINDS.forEach((k) => {\n const set = notes.filter((n) => n.kind === k);\n if (!set.length) return;\n lines.push(\"## \" + LABEL[k], \"\");\n set.slice().sort((a, b) => b.votes - a.votes).forEach((n) => {\n const who = [n.name, n.centre].filter(Boolean).join(\", \") || \"anonymous\";\n lines.push(\n \"- \" + n.text + \" \\n _\" + who + (n.votes ? \" · +\" + n.votes : \"\") +\n \" · \" + new Date(n.t).toISOString() + \"_\",\n );\n });\n lines.push(\"\");\n });\n return lines.join(\"\\n\");\n}","label",[135],"bd222455-6a7c-43cd-8fc1-944260d38c41","index.ts","24b387b4-b1f6-11f1-92fa-1607ee4eb77e",12,["D",1789580719681],"\n\n\n\n\n\nSTRATA-FIT live board\n\n\n\n

\n\n

STRATA-FIT

EULAR Big Data & AI Study Group · 18 September 2026, 17:00 CEST

\n \n

\n\n \n

On screen now

\n\n

We are showing a federated analysis dashboard running on vantage6 across six rheumatology centres. Tell us what you would need from it — or what you think is wrong with it. Everything lands on our screen while we talk.

\n\n

\n \n \n \n \n \n

\n \n

\n \n \n

Free text only — please don't paste patient data. Your note is visible to everyone on this page. Notes stay on the STRATA-FIT board for this session. Leave the name fields empty to stay anonymous.

\n\n

On the board

\n 0 notes\n

Press +1 on anything you agree with — it moves that note up our list.

\n\n \n

\n Passcode\n

\n \n \n

The PRESENTER_TOKEN from the server environment. It is checked on the server and never appears in this page.

\n\n

0notes

0last 5 min

0on the page

0concerns

0collab offers

\n\n

Question on the audience screen

\n \n \n \n

\n\n

\n \n Download JSON\n Download markdown\n

Pull \"Download JSON\" whenever you want a read on the room — paste it into a Claude chat with the summary prompt to get themes, objections and who to follow up with.

\n\n

Raw notes

\n Open big-screen view\n

\n\n \n

STRATA-FIT · the room is saying

\n 0 notes\n

Question on screen

\n\n

\n\n\n\n\n",[147],"1a491775-1a56-4442-9301-55c3d67572b8",["D",1789581065304],[28],"d8f33c4d-e47c-4d1a-88ae-be2d6e65d15a","db.ts","ee938882-b1f5-11f1-b8b2-1607ee4eb77e",13,["D",1789580742075],"// db.ts — persistence for the STRATA-FIT board.\n//\n// server.js kept everything in memory (an array, a couple of Maps) and\n// only used notes.jsonl as a replay log on boot, because it was one\n// always-running process. A Val Town HTTP val is NOT always running —\n// the worker can cold-start between requests (10s idle timeout) and\n// wipe any in-memory state. So here, *everything* server.js held in\n// memory has to live in SQLite instead: notes, per-note vote dedup,\n// the \"who's online\" tracker, and the per-IP post rate limit.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nlet ready: Promise | null = null;\n\nexport function ensureSchema(): Promise {\n if (!ready) {\n ready = (async () => {\n await sqlite.execute(`create table if not exists notes (\n seq integer primary key autoincrement,\n id text unique not null,\n t integer not null,\n kind text not null,\n text text not null,\n name text default '',\n centre text default '',\n votes integer default 0\n )`);\n await sqlite.execute(`create table if not exists votes (\n note_id text not null,\n ip text not null,\n primary key (note_id, ip)\n )`);\n await sqlite.execute(`create table if not exists presence (\n ip text primary key,\n last_seen integer not null\n )`);\n await sqlite.execute(`create table if not exists rate_limit (\n ip text primary key,\n last_post integer not null\n )`);\n await sqlite.execute(`create table if not exists state (\n key text primary key,\n value text\n )`);\n })();\n }\n return ready;\n}\n\n// Different std/sqlite versions return rows as arrays or as objects.\n// Normalize to objects so the rest of the code doesn't care.\nfunction rowsAsObjects(result: any): any[] {\n return result.rows.map((row: any) =>\n Array.isArray(row)\n ? Object.fromEntries(\n result.columns.map((c: string, i: number) => [c, row[i]]),\n )\n : row\n );\n}\n\nexport async function addNote(n: {\n id: string;\n t: number;\n kind: string;\n text: string;\n name: string;\n centre: string;\n}) {\n await ensureSchema();\n await sqlite.execute({\n sql:\n `insert into notes (id, t, kind, text, name, centre, votes) values (?, ?, ?, ?, ?, ?, 0)`,\n args: [n.id, n.t, n.kind, n.text, n.name, n.centre],\n });\n const r = await sqlite.execute({\n sql: `select * from notes where id = ?`,\n args: [n.id],\n });\n return rowsAsObjects(r)[0];\n}\n\nexport async function notesSince(seq: number) {\n await ensureSchema();\n const r = await sqlite.execute({\n sql: `select * from notes where seq > ? order by seq asc`,\n args: [seq],\n });\n return rowsAsObjects(r);\n}\n\nexport async function votesUpTo(seq: number) {\n await ensureSchema();\n const r = await sqlite.execute({\n sql: `select id, votes from notes where seq <= ? and votes > 0`,\n args: [seq],\n });\n return rowsAsObjects(r);\n}\n\nexport async function allNotes() {\n await ensureSchema();\n const r = await sqlite.execute(`select * from notes order by seq asc`);\n return rowsAsObjects(r);\n}\n\nexport async function maxSeq(): Promise {\n await ensureSchema();\n const r = await sqlite.execute(\n `select coalesce(max(seq), 0) as m from notes`,\n );\n return Number(rowsAsObjects(r)[0].m);\n}\n\nexport async function totalCount(): Promise {\n await ensureSchema();\n const r = await sqlite.execute(`select count(*) as n from notes`);\n return Number(rowsAsObjects(r)[0].n);\n}\n\n// Returns the new vote count, or null if the note doesn't exist.\n// One vote per (note, ip) — same rule as server.js's in-memory Set,\n// just backed by a unique constraint instead.\nexport async function castVote(\n noteId: string,\n ip: string,\n): Promise {\n await ensureSchema();\n const existing = await sqlite.execute({\n sql: `select votes from notes where id = ?`,\n args: [noteId],\n });\n const rows = rowsAsObjects(existing);\n if (!rows.length) return null;\n try {\n await sqlite.execute({\n sql: `insert into votes (note_id, ip) values (?, ?)`,\n args: [noteId, ip],\n });\n await sqlite.execute({\n sql: `update notes set votes = votes + 1 where id = ?`,\n args: [noteId],\n });\n } catch {\n // already voted — unique constraint rejected it, fall through\n }\n const r = await sqlite.execute({\n sql: `select votes from notes where id = ?`,\n args: [noteId],\n });\n return Number(rowsAsObjects(r)[0].votes);\n}\n\nexport async function touchPresence(ip: string) {\n await ensureSchema();\n await sqlite.execute({\n sql: `insert into presence (ip, last_seen) values (?, ?)\n on conflict(ip) do update set last_seen = excluded.last_seen`,\n args: [ip, Date.now()],\n });\n}\n\nexport async function onlineCount(): Promise {\n await ensureSchema();\n const cutoff = Date.now() - 45000;\n const r = await sqlite.execute({\n sql: `select count(*) as n from presence where last_seen > ?`,\n args: [cutoff],\n });\n return Number(rowsAsObjects(r)[0].n);\n}\n\n// Returns true if this ip is allowed to post now, and records the attempt.\nexport async function checkRate(\n ip: string,\n minGapMs: number,\n): Promise {\n await ensureSchema();\n const r = await sqlite.execute({\n sql: `select last_post from rate_limit where ip = ?`,\n args: [ip],\n });\n const rows = rowsAsObjects(r);\n const last = rows.length ? Number(rows[0].last_post) : 0;\n const now = Date.now();\n if (now - last < minGapMs) return false;\n await sqlite.execute({\n sql: `insert into rate_limit (ip, last_post) values (?, ?)\n on conflict(ip) do update set last_post = excluded.last_post`,\n args: [ip, now],\n });\n return true;\n}\n\nexport async function getPrompt(): Promise<{ text: string; t: number } | null> {\n await ensureSchema();\n const r = await sqlite.execute({\n sql: `select value from state where key = 'prompt'`,\n args: [],\n });\n const rows = rowsAsObjects(r);\n if (!rows.length || !rows[0].value) return null;\n return JSON.parse(rows[0].value as string);\n}\n\nexport async function setPrompt(text: string) {\n await ensureSchema();\n const value = text ? JSON.stringify({ text, t: Date.now() }) : null;\n await sqlite.execute({\n sql: `insert into state (key, value) values ('prompt', ?)\n on conflict(key) do update set value = excluded.value`,\n args: [value],\n });\n return value ? JSON.parse(value) : null;\n}",[157],"pulls","branches",1,"forks","envVars",{"_171":165,"_173":62},"connections",{"_171":62,"_172":62},"count","unfilledCount","emptyCount",{"_43":156,"_32":157,"_30":158,"_137":-5,"_41":42,"_40":159,"_139":25,"_38":188,"_13":141,"_33":142,"_35":161,"_24":25,"_144":-5,"_179":189,"_27":190},{"_43":153,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":185,"_13":141,"_33":34,"_35":37,"_24":25,"_144":-5,"_179":186,"_27":187},{"_43":146,"_32":147,"_30":148,"_137":-5,"_41":42,"_40":149,"_139":25,"_38":182,"_13":141,"_33":142,"_35":151,"_24":25,"_144":-5,"_179":183,"_27":184},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":58,"_38":178,"_13":141,"_33":142,"_35":143,"_24":25,"_144":-5,"_179":180,"_27":181},["D",1789580761831],"children",[],[135],["D",1789580719681],[],[147],["D",1789581065304],[],[28],["D",1789580742075],[],[157],["D",1789580405959],["D",1789582272237],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_127":229,"_230":231,"_232":233,"_234":25,"_235":25,"_236":25,"_237":58,"_238":-5,"_239":-7,"_240":-7,"_241":62,"_242":25,"_243":25,"_244":-5,"_245":25,"_246":25,"_247":25,"_248":-5},"ENV",{"_200":201,"_202":203,"_204":89,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v21