[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_256":257,"_258":259},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_188":-5,"_20":189,"_22":190,"_191":192,"_193":194,"_26":195,"_24":196,"_197":198,"_199":200,"_201":50,"_202":203,"_204":72,"_205":-5,"_206":-5,"_207":208},"routes/_app.x.$handle.$name.branch.$branch.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":32,"_34":-5},"handle","mathansankar","name","form-website","branchName","main","version","path","components","project",{"_35":140,"_13":14,"_37":141,"_48":-5,"_142":50,"_51":52,"_143":52,"_144":145,"_146":-5,"_147":148,"_149":103,"_150":72,"_151":-5,"_152":-5,"_153":32,"_55":154,"_155":156,"_157":158,"_159":160,"_161":-5,"_162":163,"_164":163,"_165":166,"_167":166,"_168":166,"_169":163,"_170":163,"_171":172,"_173":174,"_175":176,"_49":50},"tree",[97,98,99,100],"file",{"_35":93,"_13":19,"_64":67,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":94,"_17":32,"_74":95,"_76":-5,"_78":50,"_79":-5,"_18":96},"contents",[59,60,61],"upstream",{"_35":36,"_37":38,"_39":40,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"pull","ahead",0,"behind","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",{"_35":87,"_13":88,"_64":89,"_66":67,"_68":69,"_70":43,"_71":72,"_37":90,"_17":32,"_74":75,"_76":91,"_78":50,"_79":-5,"_18":92},{"_35":81,"_13":82,"_64":83,"_66":67,"_68":69,"_70":43,"_71":72,"_37":84,"_17":32,"_74":75,"_76":85,"_78":50,"_79":-5,"_18":86},{"_35":62,"_13":63,"_64":65,"_66":67,"_68":69,"_70":43,"_71":72,"_37":73,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_18":80},"03e48a27-0ea9-4c09-9c36-400f101f1c51","SubmissionsPage.tsx","fileId","01a0103c-cb92-777b-83f7-6be7dee8f146","parentId","01a0103c-cb92-777b-83f7-6e96d7fe91d9","branchId","a3e8a7c0-4836-4537-8ea3-497001887695","branchVersion","latest",true,["D",1786978814750],"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,63],"89bd7747-c30d-483e-9084-488065e46b88","Layout.tsx","01a0103c-cb92-777b-83f7-64de03a2e1a0",["D",1786978814750],"/** @jsxImportSource npm:hono/jsx */\n\nexport default function Layout({ title, children }: { title: string; children?: unknown }) {\n return (\n \n \n \n \n {title}\n \n \n \n \n

{children}

\n \n \n );\n}\n",[19,82],"85e5b826-2c47-4a6f-80fb-2906418d566e","FormPage.tsx","01a0103c-cb92-777b-83f7-6044613bfa6f",["D",1786978814750],"/** @jsxImportSource npm:hono/jsx */\nimport Layout from \"./Layout.tsx\";\n\nexport default function FormPage() {\n return (\n \n

Contact form

\n Submissions are saved to this val's SQLite database.\n

\n \n

\n view submissions\n view source\n

\n \n );\n}\n",[19,88],"2cd28e90-f894-45ea-b7e1-576ce61ec8b9",["D",1786978814750],"directory",[19],{"_35":93,"_13":19,"_64":67,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":125,"_17":32,"_74":95,"_76":-5,"_78":50,"_79":-5,"_108":126,"_18":127},{"_35":118,"_13":119,"_64":120,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":121,"_17":32,"_74":24,"_76":122,"_78":50,"_79":-5,"_108":123,"_18":124},{"_35":111,"_13":112,"_64":113,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":114,"_17":32,"_74":75,"_76":115,"_78":50,"_79":-5,"_108":116,"_18":117},{"_35":101,"_13":102,"_64":103,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":104,"_17":32,"_74":105,"_76":106,"_78":50,"_79":107,"_108":109,"_18":110},"1546a392-d258-4146-9fee-0ea725c960eb","main.tsx","01a0103c-cb92-777b-83f7-79a0cf6b12ec",["D",1786978814750],"http","/** @jsxImportSource npm:hono/jsx */\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport FormPage from \"./components/FormPage.tsx\";\nimport SubmissionsPage from \"./components/SubmissionsPage.tsx\";\nimport { addSubmission, listSubmissions } from \"./db.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => c.html());\n\napp.post(\"/submit\", async (c) => {\n const form = await c.req.formData();\n const name = String(form.get(\"name\") ?? \"\").trim();\n const email = String(form.get(\"email\") ?? \"\").trim();\n const message = String(form.get(\"message\") ?? \"\").trim();\n if (!name || !email || !message) {\n return c.text(\"Name, email, and message are all required.\", 400);\n }\n await addSubmission(name, email, message);\n return c.redirect(\"/submissions\");\n});\n\napp.get(\"/submissions\", async (c) => {\n const submissions = await listSubmissions();\n return c.html();\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","mathan-form","children",[],[102],"3833e973-911c-4791-8f1f-fb764dea3946","db.ts","01a0103c-cb92-777b-83f7-742dc6f93fb5",["D",1786978814750],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Submission {\n id: number;\n name: string;\n email: string;\n message: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS submissions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addSubmission(name: string, email: string, message: string) {\n await sqlite.execute({\n sql: \"INSERT INTO submissions (name, email, message) VALUES (?, ?, ?)\",\n args: [name, email, message],\n });\n}\n\nexport async function listSubmissions(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, name, email, message, created_at FROM submissions ORDER BY id DESC\",\n );\n return result.rows as unknown as Submission[];\n}\n",[],[112],"b914d108-96fc-4f2e-b2bb-842a41196236","README.md","01a0103c-cb92-777b-83f7-70485bcce184",["D",1786978814750],"# 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",[],[119],["D",1786978814750],[128,129,130],[19],{"_35":87,"_13":88,"_64":89,"_66":67,"_68":69,"_70":43,"_71":72,"_37":137,"_17":32,"_74":75,"_76":91,"_78":50,"_79":-5,"_108":138,"_18":139},{"_35":81,"_13":82,"_64":83,"_66":67,"_68":69,"_70":43,"_71":72,"_37":134,"_17":32,"_74":75,"_76":85,"_78":50,"_79":-5,"_108":135,"_18":136},{"_35":62,"_13":63,"_64":65,"_66":67,"_68":69,"_70":43,"_71":72,"_37":131,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_108":132,"_18":133},["D",1786978814750],[],[19,63],["D",1786978814750],[],[19,82],["D",1786978814750],[],[19,88],"4dad5123-a5ad-4d27-a5fb-69a88ee3796b",["D",1786978814750],"legacyEnvVars","httpPrivacy","description","A form filling website that saves submissions to SQLite","imageUrl","userId","d67c8e1d-825e-4922-a240-aa45b9a17ac2","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","01a01039-2a1f-72b5-8317-2d5dcb2d6e8c","tursoName","4dad5123a5ad4d27a5fb69a88ee3796b","tursoHostname","4dad5123a5ad4d27a5fb69a88ee3796b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789498239291],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_187":183},"org",{"_11":12,"_180":181,"_182":183,"_147":148,"_184":185,"_186":50},"branch",{"_17":43,"_13":16,"_35":69,"_41":140,"_44":36,"_45":43,"_177":52,"_178":42,"_179":56,"_57":14,"_53":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Mathan Sankar","avatar","https://lh3.googleusercontent.com/a/ACg8ocL3xlqPciVQ8LWDrsbx0-OuTyFYWzP6VN8jqbozFa4r6_YQJw=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":140,"_13":14,"_37":251,"_48":-5,"_142":50,"_51":52,"_143":52,"_144":145,"_146":-5,"_147":148,"_149":103,"_150":72,"_151":-5,"_152":-5,"_153":32,"_55":154,"_155":156,"_157":158,"_159":252,"_161":-5,"_162":163,"_164":163,"_165":166,"_167":166,"_168":166,"_169":163,"_170":163,"_171":253,"_173":254,"_175":255,"_49":50},[230,234,235,236],"files",[230,231,232,233,234,235,236],"counts",{"_221":32,"_222":43,"_223":32,"_34":224,"_225":226},[215,216,217],{"_35":93,"_13":19,"_64":67,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":94,"_17":32,"_74":95,"_76":-5,"_78":50,"_79":-5,"_18":214},"upstreamProject",{"_35":42,"_13":58,"_144":211,"_146":-5,"_51":52,"_171":212},"upstreamBranch",{"_35":36,"_37":209,"_39":210,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781134761362],["D",1781134761362],"Put a form online and save submissions to SQLite",{"_11":54,"_187":213},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789577999&sig=aa7aec25480c67f41f9650e8445afc21cf1a6c5fd3969752b90fbd3f6a604c46",[19],{"_35":87,"_13":88,"_64":89,"_66":67,"_68":69,"_70":43,"_71":72,"_37":90,"_17":32,"_74":75,"_76":91,"_78":50,"_79":-5,"_18":220},{"_35":81,"_13":82,"_64":83,"_66":67,"_68":69,"_70":43,"_71":72,"_37":84,"_17":32,"_74":75,"_76":85,"_78":50,"_79":-5,"_18":219},{"_35":62,"_13":63,"_64":65,"_66":67,"_68":69,"_70":43,"_71":72,"_37":73,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_18":218},[19,63],[19,82],[19,88],"pulls","branches","forks",{"_227":32,"_229":32},"connections",{"_227":32,"_228":32},"count","unfilledCount","emptyCount",{"_35":93,"_13":19,"_64":67,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":125,"_17":32,"_74":95,"_76":-5,"_78":50,"_79":-5,"_108":249,"_18":250},{"_35":87,"_13":88,"_64":89,"_66":67,"_68":69,"_70":43,"_71":72,"_37":137,"_17":32,"_74":75,"_76":91,"_78":50,"_79":-5,"_108":247,"_18":248},{"_35":81,"_13":82,"_64":83,"_66":67,"_68":69,"_70":43,"_71":72,"_37":134,"_17":32,"_74":75,"_76":85,"_78":50,"_79":-5,"_108":245,"_18":246},{"_35":62,"_13":63,"_64":65,"_66":67,"_68":69,"_70":43,"_71":72,"_37":131,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_108":243,"_18":244},{"_35":118,"_13":119,"_64":120,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":121,"_17":32,"_74":24,"_76":122,"_78":50,"_79":-5,"_108":241,"_18":242},{"_35":111,"_13":112,"_64":113,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":114,"_17":32,"_74":75,"_76":115,"_78":50,"_79":-5,"_108":239,"_18":240},{"_35":101,"_13":102,"_64":103,"_66":-5,"_68":69,"_70":43,"_71":72,"_37":104,"_17":32,"_74":105,"_76":106,"_78":50,"_79":107,"_108":237,"_18":238},[],[102],[],[112],[],[119],[],[19,63],[],[19,82],[],[19,88],[231,232,233],[19],["D",1786978814750],["D",1789498239291],{"_11":12,"_187":183},{"_11":12,"_180":181,"_182":183,"_147":148,"_184":185,"_186":50},{"_17":43,"_13":16,"_35":69,"_41":140,"_44":36,"_45":43,"_177":52,"_178":42,"_179":56,"_57":14,"_53":12},"ctx",{"_171":-5,"_206":289,"_290":291,"_292":293,"_294":50,"_295":50,"_296":50,"_297":72,"_298":-5,"_299":-7,"_300":-7,"_301":32,"_302":50,"_303":50,"_304":-5,"_305":50,"_306":50,"_307":50,"_308":-5},"ENV",{"_260":261,"_262":263,"_264":16,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288},"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"]