[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_259":260,"_261":262},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_191":-5,"_20":192,"_22":193,"_194":195,"_196":197,"_26":198,"_24":199,"_200":201,"_202":203,"_204":51,"_205":206,"_207":73,"_208":-5,"_209":-5,"_210":211},"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":29,"_30":-5,"_31":32,"_33":34,"_35":-5},"handle","pchinjr","name","retro-guestbook","branchName","main","version","path","components","project",{"_36":144,"_13":14,"_38":145,"_49":-5,"_146":51,"_52":53,"_147":53,"_148":149,"_150":-5,"_151":152,"_153":107,"_154":73,"_155":-5,"_156":-5,"_157":34,"_56":158,"_159":160,"_161":162,"_163":164,"_165":-5,"_166":167,"_168":167,"_169":170,"_171":170,"_172":170,"_173":167,"_174":167,"_175":176,"_177":178,"_179":180,"_50":51},"tree",[101,102,103,104],"file",{"_36":97,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":44,"_72":73,"_38":98,"_17":34,"_75":99,"_77":-5,"_79":51,"_80":-5,"_18":100},"contents",[60,61,62],"upstream",{"_36":37,"_38":39,"_40":41,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"pull","ahead",8,"behind",0,"envVars","id","fb141f8d-047d-43b3-b09c-7fd59d8ddcfe","createdAt",["D",1781134761362],"updatedAt",["D",1781134761362],"projectId","a35fc79f-ccd4-4375-94dc-260d312636c6",1,"forkedBranchId","forkedBranchVersion","lockfileKey","1781135021367-esm.town_v_templates_form-to-sqlite@1-main","deletedAt","isOwned",false,"privacy","public","userHandle","templates","orgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","form-to-sqlite",{"_36":89,"_13":90,"_65":91,"_67":68,"_69":70,"_71":92,"_72":73,"_38":93,"_17":94,"_75":76,"_77":95,"_79":51,"_80":-5,"_18":96},{"_36":82,"_13":83,"_65":84,"_67":68,"_69":70,"_71":85,"_72":73,"_38":86,"_17":44,"_75":76,"_77":87,"_79":51,"_80":-5,"_18":88},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":44,"_72":73,"_38":74,"_17":34,"_75":76,"_77":78,"_79":51,"_80":-5,"_18":81},"de8a81b6-d52c-4b78-8ca4-07a3be299d74","SubmissionsPage.tsx","fileId","019faed6-9ece-7043-8a84-90dd333745c9","parentId","019faed6-9ece-7043-8a84-95bd498b9e3a","branchId","a9ae7f52-e6f6-4e59-a1c9-5c5571f8e3b3","branchVersion","latest",true,["D",1785344728700],"fileType","script","content","/** @jsxImportSource npm:hono/jsx */\nimport type { Submission } from \"../db.ts\";\nimport Layout from \"./Layout.tsx\";\n\nexport default function SubmissionsPage({ submissions }: { submissions: Submission[] }) {\n return (\n \n

Submissions ({submissions.length})

\n {submissions.length === 0\n ?

Nothing yet. Be the first to submit the form.

\n : (\n

\n
\n {s.name}\n {s.created_at}\n
\n
{s.email}
\n
{s.message}
\n

\n )}\n

\n back to form\n view source\n

\n \n );\n}\n","deleted","label",[19,64],"dc173261-bd2f-4af7-8928-681cc6c6d992","Layout.tsx","019faed6-9ece-7043-8a84-8fd21b23d730",5,["D",1785344844334],"/** @jsxImportSource npm:hono/jsx */\n\nexport default function Layout({ title, children }: { title: string; children?: unknown }) {\n return (\n \n \n \n \n \n {title}\n \n \n \n \n

{children}

\n \n \n );\n}\n",[19,83],"efe8449e-d265-43ae-9ab5-f5c50eb31d41","FormPage.tsx","019faed6-9ece-7043-8a84-8bd210cf90ea",9,["D",1785344928752],2,"/** @jsxImportSource npm:hono/jsx */\nimport type { GuestbookEntry } from \"../db.ts\";\nimport Layout from \"./Layout.tsx\";\n\nfunction formatDate(value: string) {\n const normalized = value.includes(\"T\") ? value : value.replace(\" \", \"T\") + \"Z\";\n return new Intl.DateTimeFormat(\"en-US\", {\n dateStyle: \"medium\",\n timeStyle: \"short\",\n timeZone: \"America/New_York\",\n }).format(new Date(normalized));\n}\n\nexport default function FormPage({\n entries,\n visitorCount,\n error,\n}: {\n entries: GuestbookEntry[];\n visitorCount: number;\n error?: string;\n}) {\n const counter = String(visitorCount).padStart(6, \"0\");\n\n return (\n \n

\n 📖 GUESTBOOK.EXE\n \n _□×\n \n

\n\n

★ SIGN MY GUESTBOOK ★

You found my little corner of the World Wide Web!

▶ Please leave your mark before you surf away.

\n\n

\n AWESOME VISITORS WHO SIGNED:\n {counter}\n

\n\n

✍️ Add your name to internet history

\n {error &&

⚠ {error}

}\n \n

\n\n

💬 Messages from cyberspace ({visitorCount})

\n {entries.length === 0\n ?

No messages yet. Be the first cool person to sign!

\n : (\n

\n {entries.map((entry) => (\n

\n #{entry.id} — {entry.name}\n {formatDate(entry.created_at)} ET\n

{entry.message}

\n ))}\n

\n )}\n

\n\n \n

\n \n );\n}\n",[19,90],"470455c6-f29b-4d1d-8763-6bef6c27d0fa",["D",1785344728700],"directory",[19],{"_36":97,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":44,"_72":73,"_38":129,"_17":34,"_75":99,"_77":-5,"_79":51,"_80":-5,"_112":130,"_18":131},{"_36":122,"_13":123,"_65":124,"_67":-5,"_69":70,"_71":44,"_72":73,"_38":125,"_17":34,"_75":24,"_77":126,"_79":51,"_80":-5,"_112":127,"_18":128},{"_36":115,"_13":116,"_65":117,"_67":-5,"_69":70,"_71":94,"_72":73,"_38":118,"_17":44,"_75":76,"_77":119,"_79":51,"_80":-5,"_112":120,"_18":121},{"_36":105,"_13":106,"_65":107,"_67":-5,"_69":70,"_71":32,"_72":73,"_38":108,"_17":109,"_75":110,"_77":111,"_79":51,"_80":-5,"_112":113,"_18":114},"c90707cc-cd61-4308-81ee-07aa9d882f1d","main.tsx","019faed6-9ece-7043-8a84-a25d45fdeec9",["D",1785344925525],4,"http","/** @jsxImportSource npm:hono/jsx */\nimport { Hono } from \"npm:hono\";\nimport FormPage from \"./components/FormPage.tsx\";\nimport { addEntry, getVisitorCount, listEntries } from \"./db.ts\";\n\nconst app = new Hono();\n\nasync function renderGuestbook(error?: string) {\n const [entries, visitorCount] = await Promise.all([\n listEntries(),\n getVisitorCount(),\n ]);\n return ;\n}\n\napp.get(\"/\", async (c) => c.html(await renderGuestbook()));\n\napp.post(\"/sign\", async (c) => {\n const form = new URLSearchParams(await c.req.text());\n const name = String(form.get(\"name\") ?? \"\").trim();\n const message = String(form.get(\"message\") ?? \"\").trim();\n\n if (!name || !message) {\n return c.html(await renderGuestbook(\"Please enter both your name and a message.\"), 400);\n }\n if (name.length > 40 || message.length > 500) {\n return c.html(await renderGuestbook(\"That entry is too long. Names can be 40 characters and messages can be 500.\"), 400);\n }\n\n await addEntry(name, message);\n return c.redirect(\"/#messages\", 303);\n});\n\napp.onError((error, c) => {\n console.error(error);\n return c.text(\"The guestbook hit a totally bogus error. Please try again.\", 500);\n});\n\nexport default app.fetch;\n","children",[],[106],"48477fb8-672a-4940-bb25-f1fb69d03de4","db.ts","019faed6-9ece-7043-8a84-9d32f6615748",["D",1785344832662],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface GuestbookEntry {\n id: number;\n name: string;\n message: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS guestbook_entries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL CHECK(length(name) BETWEEN 1 AND 40),\n message TEXT NOT NULL CHECK(length(message) BETWEEN 1 AND 500),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addEntry(name: string, message: string) {\n await sqlite.execute({\n sql: \"INSERT INTO guestbook_entries (name, message) VALUES (?, ?)\",\n args: [name, message],\n });\n}\n\nexport async function listEntries(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, name, message, created_at FROM guestbook_entries ORDER BY id DESC LIMIT 100\",\n );\n return result.rows as unknown as GuestbookEntry[];\n}\n\nexport async function getVisitorCount(): Promise {\n const result = await sqlite.execute(\n \"SELECT COUNT(*) AS count FROM guestbook_entries\",\n );\n return Number(result.rows[0]?.count ?? 0);\n}\n",[],[116],"06eef483-1608-43c1-b1f6-f4fe6c245d31","README.md","019faed6-9ece-7043-8a84-99e8a3f42394",["D",1785344728700],"# What's the easiest way to put a form online and save submissions?\n\nRemix this val. It serves a contact form (name, email, message) at `/`, saves every submission to the val's own SQLite database, and lists everything received at `/submissions`. No external services, no API keys, no env vars.\n\n## Setup\n\n1. Remix this val.\n2. Open the HTTP endpoint of `main.tsx` — that is your live form. Share the URL.\n3. Visit `/submissions` on the same URL to see what people sent.\n\nEach remix gets its own private SQLite database, so your submissions stay with your copy.\n\n## Files\n\n- `main.tsx` — Hono routes: GET `/` (form), POST `/submit` (save), GET `/submissions` (list)\n- `db.ts` — creates the `submissions` table and holds the two queries\n- `components/Layout.tsx` — shared page shell with Tailwind (via Twind)\n- `components/FormPage.tsx` — the form\n- `components/SubmissionsPage.tsx` — the list\n\n## Notes\n\n- `/submissions` is public by default. If your form collects anything sensitive, protect that route before sharing the form URL.\n- No client-side JavaScript: the form is a plain HTML POST.\n",[],[123],["D",1785344728700],[132,133,134],[19],{"_36":89,"_13":90,"_65":91,"_67":68,"_69":70,"_71":92,"_72":73,"_38":141,"_17":94,"_75":76,"_77":95,"_79":51,"_80":-5,"_112":142,"_18":143},{"_36":82,"_13":83,"_65":84,"_67":68,"_69":70,"_71":85,"_72":73,"_38":138,"_17":44,"_75":76,"_77":87,"_79":51,"_80":-5,"_112":139,"_18":140},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":44,"_72":73,"_38":135,"_17":34,"_75":76,"_77":78,"_79":51,"_80":-5,"_112":136,"_18":137},["D",1785344728700],[],[19,64],["D",1785344844334],[],[19,83],["D",1785344928752],[],[19,90],"da0dbaef-c5e0-4d71-8d41-7fb85f6d00e0",["D",1785344728700],"legacyEnvVars","httpPrivacy","description","Retro guestbook with messages and visitor count","imageUrl","userId","40e69d1a-3254-4858-920b-7b1449761575","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","54bae3d1-8223-41e5-b22d-81eb28a263c7","tursoName","da0dbaefc5e04d718d417fb85f6d00e0","tursoHostname","da0dbaefc5e04d718d417fb85f6d00e0-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789561254403],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_190":186},"org",{"_11":12,"_184":-5,"_185":186,"_151":152,"_187":188,"_189":51},"branch",{"_17":92,"_13":16,"_36":70,"_42":144,"_45":37,"_46":44,"_181":53,"_182":43,"_183":57,"_58":14,"_54":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://images.clerk.dev/oauth_github/img_2OaSpooJk6yZ5KFqyjtIVA4z3SH.jpeg","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":144,"_13":14,"_38":254,"_49":-5,"_146":51,"_52":53,"_147":53,"_148":149,"_150":-5,"_151":152,"_153":107,"_154":73,"_155":-5,"_156":-5,"_157":34,"_56":158,"_159":160,"_161":162,"_163":255,"_165":-5,"_166":167,"_168":167,"_169":170,"_171":170,"_172":170,"_173":167,"_174":167,"_175":256,"_177":257,"_179":258,"_50":51},[233,237,238,239],"files",[233,234,235,236,237,238,239],"counts",{"_224":34,"_225":44,"_226":34,"_35":227,"_228":229},[218,219,220],{"_36":97,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":44,"_72":73,"_38":98,"_17":34,"_75":99,"_77":-5,"_79":51,"_80":-5,"_18":217},"upstreamProject",{"_36":43,"_13":59,"_148":214,"_150":-5,"_52":53,"_175":215},"upstreamBranch",{"_36":37,"_38":212,"_40":213,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781134761362],["D",1781134761362],"Put a form online and save submissions to SQLite",{"_11":55,"_190":216},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789570799&sig=257a5acfa0921f3bba1b6e04c40af81b331d69d65dd78c28728d8fa984364db5",[19],{"_36":89,"_13":90,"_65":91,"_67":68,"_69":70,"_71":92,"_72":73,"_38":93,"_17":94,"_75":76,"_77":95,"_79":51,"_80":-5,"_18":223},{"_36":82,"_13":83,"_65":84,"_67":68,"_69":70,"_71":85,"_72":73,"_38":86,"_17":44,"_75":76,"_77":87,"_79":51,"_80":-5,"_18":222},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":44,"_72":73,"_38":74,"_17":34,"_75":76,"_77":78,"_79":51,"_80":-5,"_18":221},[19,64],[19,83],[19,90],"pulls","branches","forks",{"_230":34,"_232":34},"connections",{"_230":34,"_231":34},"count","unfilledCount","emptyCount",{"_36":97,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":44,"_72":73,"_38":129,"_17":34,"_75":99,"_77":-5,"_79":51,"_80":-5,"_112":252,"_18":253},{"_36":89,"_13":90,"_65":91,"_67":68,"_69":70,"_71":92,"_72":73,"_38":141,"_17":94,"_75":76,"_77":95,"_79":51,"_80":-5,"_112":250,"_18":251},{"_36":82,"_13":83,"_65":84,"_67":68,"_69":70,"_71":85,"_72":73,"_38":138,"_17":44,"_75":76,"_77":87,"_79":51,"_80":-5,"_112":248,"_18":249},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":44,"_72":73,"_38":135,"_17":34,"_75":76,"_77":78,"_79":51,"_80":-5,"_112":246,"_18":247},{"_36":122,"_13":123,"_65":124,"_67":-5,"_69":70,"_71":44,"_72":73,"_38":125,"_17":34,"_75":24,"_77":126,"_79":51,"_80":-5,"_112":244,"_18":245},{"_36":115,"_13":116,"_65":117,"_67":-5,"_69":70,"_71":94,"_72":73,"_38":118,"_17":44,"_75":76,"_77":119,"_79":51,"_80":-5,"_112":242,"_18":243},{"_36":105,"_13":106,"_65":107,"_67":-5,"_69":70,"_71":32,"_72":73,"_38":108,"_17":109,"_75":110,"_77":111,"_79":51,"_80":-5,"_112":240,"_18":241},[],[106],[],[116],[],[123],[],[19,64],[],[19,83],[],[19,90],[234,235,236],[19],["D",1785344728700],["D",1789561254403],{"_11":12,"_190":186},{"_11":12,"_184":-5,"_185":186,"_151":152,"_187":188,"_189":51},{"_17":92,"_13":16,"_36":70,"_42":144,"_45":37,"_46":44,"_181":53,"_182":43,"_183":57,"_58":14,"_54":12},"ctx",{"_175":-5,"_209":292,"_293":294,"_295":296,"_297":51,"_298":51,"_299":51,"_300":73,"_301":-5,"_302":-7,"_303":-7,"_304":34,"_305":51,"_306":51,"_307":-5,"_308":51,"_309":51,"_310":51,"_311":-5},"ENV",{"_263":264,"_265":266,"_267":16,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291},"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"]