[{"_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",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_149":-5,"_20":150,"_22":151,"_152":153,"_154":155,"_26":156,"_24":157,"_158":-5,"_159":-5,"_160":52,"_161":162,"_163":43,"_164":-5,"_165":-5,"_166":167},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","ivanzhovannik","name","strata-fit-board","branchName","main","version","path","db.ts","project",{"_33":90,"_13":14,"_44":91,"_92":-5,"_93":52,"_94":95,"_96":95,"_97":98,"_99":-5,"_100":101,"_102":80,"_103":43,"_104":-5,"_105":-5,"_106":107,"_108":109,"_110":111,"_112":113,"_114":115,"_116":-5,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":127,"_128":129,"_130":131,"_132":52},"tree",[55,56,57,58],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","6c13aec2-edb3-4033-b33a-4f2fa715d25a","fileId","ee938882-b1f5-11f1-b8b2-1607ee4eb77e","parentId","branchId","36e9c483-8011-4cee-9897-5cea25dc6ac2","branchVersion",26,"latest",true,"createdAt",["D",1789583127113],3,"fileType","script","content","// 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/main.ts\";\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}","deleted",false,"label",[19],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":87,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_66":88,"_18":89},{"_33":78,"_13":79,"_35":80,"_37":-5,"_38":39,"_40":81,"_42":43,"_44":82,"_17":74,"_47":83,"_49":84,"_51":52,"_53":-5,"_66":85,"_18":86},{"_33":69,"_13":70,"_35":71,"_37":-5,"_38":39,"_40":72,"_42":43,"_44":73,"_17":74,"_47":24,"_49":75,"_51":52,"_53":-5,"_66":76,"_18":77},{"_33":59,"_13":60,"_35":61,"_37":-5,"_38":39,"_40":62,"_42":43,"_44":63,"_17":64,"_47":48,"_49":65,"_51":52,"_53":-5,"_66":67,"_18":68},"67e2bb2c-25fc-47e6-add8-bb46b3ad3573","markdown.ts","17ecf128-b1f6-11f1-bc56-1607ee4eb77e",14,["D",1789580761831],2,"// 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}","children",[],[60],"ce16c279-ab87-44ee-adb1-95b09d216b2f","index.html","24b387b4-b1f6-11f1-92fa-1607ee4eb77e",24,["D",1789581220008],4,"\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",[],[70],"a094953a-037c-4b8d-8ff2-af2cfbff0ea3","http.ts","166430f4-b1f7-11f1-bd53-1607ee4eb77e",25,["D",1789582241541],"http","// 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}\n",[],[79],["D",1789583127113],[],[19],"31856024-73f2-4985-b3c5-d15fb530b917",["D",1789580405959],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Chat board","imageUrl","userId","5655f697-f970-446c-930e-7aa57f6e7aa6","pinnedFileId","pinPreview","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",{"_11":12,"_148":144},"org",{"_11":12,"_141":142,"_143":144,"_100":101,"_145":146,"_147":52},"branch",{"_17":41,"_13":16,"_33":39,"_133":90,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Ivan Zhovannik","avatar","https://lh3.googleusercontent.com/a/ACg8ocKggA35N2ptIs8Od95m-QCDdcK-XaH-2tmlhnjXjErkvnxNgxki=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":90,"_13":14,"_44":191,"_92":-5,"_93":52,"_94":95,"_96":95,"_97":98,"_99":-5,"_100":101,"_102":80,"_103":43,"_104":-5,"_105":-5,"_106":107,"_108":109,"_110":111,"_112":113,"_114":192,"_116":-5,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":193,"_128":194,"_130":195,"_132":52},[179,180,181,182],"files",[179,180,181,182],"counts",{"_169":107,"_170":171,"_172":107,"_32":173,"_174":175},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_18":168},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches",1,"forks",{"_176":171,"_178":107},"connections",{"_176":107,"_177":107},"count","unfilledCount","emptyCount",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":87,"_17":46,"_47":48,"_49":50,"_51":52,"_53":-5,"_66":189,"_18":190},{"_33":78,"_13":79,"_35":80,"_37":-5,"_38":39,"_40":81,"_42":43,"_44":82,"_17":74,"_47":83,"_49":84,"_51":52,"_53":-5,"_66":187,"_18":188},{"_33":69,"_13":70,"_35":71,"_37":-5,"_38":39,"_40":72,"_42":43,"_44":73,"_17":74,"_47":24,"_49":75,"_51":52,"_53":-5,"_66":185,"_18":186},{"_33":59,"_13":60,"_35":61,"_37":-5,"_38":39,"_40":62,"_42":43,"_44":63,"_17":64,"_47":48,"_49":65,"_51":52,"_53":-5,"_66":183,"_18":184},[],[60],[],[70],[],[79],[],[19],["D",1789580405959],["D",1789582272237],{"_11":12,"_148":144},{"_11":12,"_141":142,"_143":144,"_100":101,"_145":146,"_147":52},{"_17":41,"_13":16,"_33":39,"_133":90,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"ctx",{"_126":-5,"_165":229,"_230":231,"_232":233,"_234":52,"_235":52,"_236":52,"_237":43,"_238":-5,"_239":-7,"_240":-7,"_241":107,"_242":52,"_243":52,"_244":-5,"_245":52,"_246":52,"_247":52,"_248":-5},"ENV",{"_200":201,"_202":203,"_204":16,"_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"]