${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",[118],"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`.",[135],"pulls",1,"forks","envVars",{"_147":53,"_149":53},"connections",{"_147":53,"_148":53},"count","unfilledCount","emptyCount",{"_20":134,"_13":135,"_119":136,"_120":-5,"_121":21,"_122":30,"_124":49,"_22":156,"_29":126,"_127":104,"_129":138,"_131":38,"_132":-5,"_153":157,"_92":158},{"_20":117,"_13":118,"_119":47,"_120":-5,"_121":21,"_122":123,"_124":49,"_22":152,"_29":126,"_127":128,"_129":130,"_131":38,"_132":-5,"_153":154,"_92":155},["D",1770704768236],"children",[],[118],["D",1770705265250],[],[135],["D",1770703694087],["D",1789528252206],{"_11":12,"_90":86},{"_11":12,"_84":-5,"_85":86,"_44":45,"_87":88,"_89":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_79":-5,"_80":-5,"_81":-5,"_82":14,"_83":12},"ctx",{"_72":-5,"_112":197,"_198":199,"_200":201,"_202":38,"_203":38,"_204":38,"_205":49,"_206":-5,"_207":-7,"_208":-7,"_209":53,"_210":38,"_211":38,"_212":-5,"_213":38,"_214":38,"_215":38,"_216":-5},"ENV",{"_168":169,"_170":171,"_172":26,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196},"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"]

Branches1

Branches
1