\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",[],[214],["D",1789582241541],[],[18],"6c13aec2-edb3-4033-b33a-4f2fa715d25a","db.ts","ee938882-b1f5-11f1-b8b2-1607ee4eb77e",["D",1789583127113],3,"// 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}",[],[225],["D",1789580405959],["D",1789582272237],{"_11":12,"_156":73},{"_11":12,"_151":152,"_72":73,"_30":71,"_153":154,"_155":24},{"_42":142,"_13":16,"_36":39,"_143":104,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":14,"_150":12},"ctx",{"_55":-5,"_175":270,"_271":272,"_273":274,"_275":24,"_276":24,"_277":24,"_278":116,"_279":-5,"_280":-7,"_281":-7,"_282":26,"_283":24,"_284":24,"_285":-5,"_286":24,"_287":24,"_288":24,"_289":-5},"ENV",{"_241":242,"_243":244,"_245":16,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269},"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"]

History · http.ts