${esc(error)}

` : \"\";\n const val = value ? ` value=\"${esc(value)}\"` : \"\";\n return page(`\n ${errorBlock}\n \n `);\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n\n // One-time setup: POST /setup\n if (path === \"/setup\" && req.method === \"POST\") {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS bigmessage_entries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n ip_address TEXT NOT NULL,\n created_on DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `);\n return new Response(\"Table created.\", { status: 200 });\n }\n\n // GET /\n if ((path === \"/\" || path === \"\") && req.method === \"GET\") {\n const result = await sqlite.execute(\n \"SELECT text FROM bigmessage_entries ORDER BY created_on DESC LIMIT 1\",\n );\n const text = result.rows.length > 0 ? esc(String(result.rows[0][0])) : \"\";\n return page(`\n Go ahead and change the text!\n

${text}

\n `);\n }\n\n // GET /change\n if (path === \"/change\" && req.method === \"GET\") {\n return formHtml();\n }\n\n // POST /change\n if (path === \"/change\" && req.method === \"POST\") {\n const form = await req.formData();\n const text = String(form.get(\"text\") || \"\").trim();\n\n const error = validate(text);\n if (error) return formHtml(error, text);\n\n const ip = req.headers.get(\"x-forwarded-for\")?.split(\",\")[0]?.trim() ||\n \"unknown\";\n\n await sqlite.execute({\n sql: \"INSERT INTO bigmessage_entries (text, ip_address) VALUES (?, ?)\",\n args: [text, ip],\n });\n\n // prune old entries\n await sqlite.execute({\n sql: `DELETE FROM bigmessage_entries WHERE id NOT IN (\n SELECT id FROM bigmessage_entries ORDER BY created_on DESC LIMIT ?\n )`,\n args: [MAX_LOG_ENTRIES],\n });\n\n return new Response(null, { status: 303, headers: { Location: \"/\" } });\n }\n\n // GET /log\n if (path === \"/log\" && req.method === \"GET\") {\n const result = await sqlite.execute({\n sql:\n \"SELECT text, ip_address, created_on FROM bigmessage_entries ORDER BY created_on DESC LIMIT ?\",\n args: [MAX_LOG_ENTRIES],\n });\n const rows = result.rows\n .map((r) =>\n `

${esc(String(r[2]))} ${\n esc(String(r[1]))\n } — ${esc(String(r[0]))}

`\n )\n .join(\"\\n\");\n return page(rows || \"

No entries yet.

\");\n }\n\n return new Response(\"Not Found\", { status: 404 });\n}","deleted","label",[112],"8ae236a0-064a-11f1-ba7a-42dde27851f2","README.md","22bed144-0647-11f1-906b-42dde27851f2",["D",1770705265250],"# bigmessage — Val Town\n\nA trivial web app — anyone can change the big message on the front page, and all\nchanges are logged by date and IP.\n\nPart of the [bigmessage](https://github.com/t1merickson/bigmessage) project.\nThis version runs on **Val Town** as an HTTP val with **built-in SQLite** for\nstorage.\n\n## Stack\n\n- **Compute:** Val Town HTTP val\n- **Storage:** Built-in SQLite (10 MB cap)\n- **Single file:** `bigmessage.ts`\n\n## Deploy\n\n1. Go to [val.town](https://val.town)\n2. Create a new HTTP val\n3. Paste the contents of `bigmessage.ts`\n4. Save — it's live immediately\n\n## Routes\n\n- `GET /` — display the current big message\n- `GET/POST /change` — form to submit a new message\n- `GET /log` — history of all changes\n\n## Validation\n\nInline TLD and word lists are embedded in `bigmessage.ts`. To update them, edit\nthe canonical files in the main\n[bigmessage](https://github.com/t1merickson/bigmessage) repo's `data/` folder\nand run `data/sync-lists.sh`.",[129],"pulls","branches",1,"forks","envVars",{"_142":41,"_144":41},"connections",{"_142":41,"_143":41},"count","unfilledCount","emptyCount",{"_18":128,"_20":129,"_113":130,"_114":-5,"_115":70,"_116":68,"_118":37,"_22":151,"_67":120,"_121":98,"_123":132,"_125":26,"_126":-5,"_148":152,"_87":153},{"_18":111,"_20":112,"_113":35,"_114":-5,"_115":70,"_116":117,"_118":37,"_22":147,"_67":120,"_121":122,"_123":124,"_125":26,"_126":-5,"_148":149,"_87":150},["D",1770704768236],"children",[],[112],["D",1770705265250],[],[129],["D",1770703694087],["D",1789528252206],{"_16":17,"_85":81},{"_16":17,"_79":-5,"_80":81,"_32":33,"_82":83,"_84":26},{"_67":68,"_20":69,"_18":70,"_71":19,"_72":-5,"_73":-5,"_74":-5,"_75":-5,"_76":-5,"_77":21,"_78":17},"ctx",{"_60":-5,"_106":192,"_193":194,"_195":196,"_197":26,"_198":26,"_199":26,"_200":37,"_201":-5,"_202":-7,"_203":-7,"_204":41,"_205":26,"_206":26,"_207":-5,"_208":26,"_209":26,"_210":26,"_211":-5},"ENV",{"_163":164,"_165":166,"_167":69,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

Search