\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",[149],"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}",[156],"pulls","branches",1,"forks","envVars",{"_170":164,"_172":61},"connections",{"_170":61,"_171":61},"count","unfilledCount","emptyCount",{"_42":155,"_32":156,"_30":157,"_134":-5,"_40":41,"_39":158,"_135":24,"_37":187,"_13":144,"_33":145,"_35":160,"_23":24,"_137":-5,"_178":188,"_26":189},{"_42":148,"_32":149,"_30":150,"_134":-5,"_40":41,"_39":151,"_135":24,"_37":184,"_13":144,"_33":145,"_35":153,"_23":24,"_137":-5,"_178":185,"_26":186},{"_42":139,"_32":140,"_30":141,"_134":-5,"_40":41,"_39":142,"_135":57,"_37":181,"_13":144,"_33":145,"_35":146,"_23":24,"_137":-5,"_178":182,"_26":183},{"_42":133,"_32":27,"_30":31,"_134":-5,"_40":41,"_39":14,"_135":24,"_37":177,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_178":179,"_26":180},["D",1789581021576],"children",[],[27],["D",1789580761831],[],[140],["D",1789580719681],[],[149],["D",1789580742075],[],[156],["D",1789580405959],["D",1789582272237],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":24},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_126":228,"_229":230,"_231":232,"_233":24,"_234":24,"_235":24,"_236":57,"_237":-5,"_238":-7,"_239":-7,"_240":61,"_241":24,"_242":24,"_243":-5,"_244":24,"_245":24,"_246":24,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":88,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"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 · v19