[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_176":-5,"_20":177,"_22":178,"_179":180,"_181":182,"_26":183,"_24":184,"_185":-5,"_186":-5,"_187":57,"_188":189,"_190":48,"_191":-5,"_192":-5,"_193":194},"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":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","templates","name","form-to-sqlite","branchName","main","version","path","components","project",{"_36":118,"_13":14,"_49":119,"_120":-5,"_121":57,"_122":123,"_124":123,"_125":126,"_127":-5,"_128":129,"_130":82,"_131":48,"_132":-5,"_133":-5,"_134":51,"_135":136,"_137":138,"_139":140,"_141":142,"_143":-5,"_144":145,"_146":145,"_147":148,"_149":148,"_150":148,"_151":145,"_152":145,"_153":154,"_155":156,"_157":158,"_159":57},"tree",[76,77,78,79],"file",{"_36":72,"_43":44,"_39":42,"_13":19,"_54":-5,"_52":73,"_17":51,"_41":-5,"_49":74,"_45":46,"_58":-5,"_18":75},"contents",[33,34,35],"upstream","pull","ahead","behind","envVars",{"_36":66,"_13":67,"_39":68,"_41":42,"_43":44,"_45":46,"_47":48,"_49":69,"_17":51,"_52":53,"_54":70,"_56":57,"_58":-5,"_18":71},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":46,"_47":48,"_49":63,"_17":51,"_52":53,"_54":64,"_56":57,"_58":-5,"_18":65},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":59},"id","691b3474-6bf0-417c-9095-c4af0e6735aa","SubmissionsPage.tsx","fileId","019eb3e7-9e0e-75d5-89dd-c21d1fee16ae","parentId","019eb3e7-9e0e-75d5-89dd-c676b3994f07","branchId","fb141f8d-047d-43b3-b09c-7fd59d8ddcfe","branchVersion",1,"latest",true,"createdAt",["D",1781134761362],0,"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",false,"label",[19,38],"40e83c0d-3089-4920-8dc8-7de707bfa83b","Layout.tsx","019eb3e7-9e0e-75d5-89dd-bc3144787be0",["D",1781134761362],"/** @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,61],"08b65428-ac5c-40c7-ab6e-e17652aa1862","FormPage.tsx","019eb3e7-9e0e-75d5-89dd-b84986c1d8ca",["D",1781134761362],"/** @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,67],"5b60cf5d-97a3-4870-922f-40d7e46100ce","directory",["D",1781134761362],[19],{"_36":72,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":46,"_47":48,"_49":103,"_17":51,"_52":73,"_54":-5,"_56":57,"_58":-5,"_86":104,"_18":105},{"_36":96,"_13":97,"_39":98,"_41":-5,"_43":44,"_45":46,"_47":48,"_49":99,"_17":51,"_52":24,"_54":100,"_56":57,"_58":-5,"_86":101,"_18":102},{"_36":89,"_13":90,"_39":91,"_41":-5,"_43":44,"_45":46,"_47":48,"_49":92,"_17":51,"_52":53,"_54":93,"_56":57,"_58":-5,"_86":94,"_18":95},{"_36":80,"_13":81,"_39":82,"_41":-5,"_43":44,"_45":46,"_47":48,"_49":83,"_17":51,"_52":84,"_54":85,"_56":57,"_58":-5,"_86":87,"_18":88},"0bcd4b7b-4987-4fd6-8d3a-452a7bd57b5c","main.tsx","019eb3e7-9e0e-75d5-89dd-d1cbbcb576b4",["D",1781134761362],"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","children",[],[81],"de425f0c-092f-42c8-85b0-92ccf1f6de9b","db.ts","019eb3e7-9e0e-75d5-89dd-cc01edb75581",["D",1781134761362],"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",[],[90],"2ee5cb45-2544-47d0-9ae8-da34010b27d2","README.md","019eb3e7-9e0e-75d5-89dd-ca52d704a484",["D",1781134761362],"# 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",[],[97],["D",1781134761362],[106,107,108],[19],{"_36":66,"_13":67,"_39":68,"_41":42,"_43":44,"_45":46,"_47":48,"_49":115,"_17":51,"_52":53,"_54":70,"_56":57,"_58":-5,"_86":116,"_18":117},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":46,"_47":48,"_49":112,"_17":51,"_52":53,"_54":64,"_56":57,"_58":-5,"_86":113,"_18":114},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":109,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_86":110,"_18":111},["D",1781134761362],[],[19,38],["D",1781134761362],[],[19,61],["D",1781134761362],[],[19,67],"a35fc79f-ccd4-4375-94dc-260d312636c6",["D",1781134761362],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Put a form online and save submissions to SQLite","imageUrl","userId","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019aa807-52c2-709c-928b-2029bae9a558","tursoName","a35fc79fccd4437594dc260d312636c6","tursoHostname","a35fc79fccd4437594dc260d312636c6-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789508444194],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_175":171},"org",{"_11":12,"_168":169,"_170":171,"_128":-5,"_172":173,"_174":48},"branch",{"_17":46,"_13":16,"_36":44,"_160":118,"_161":-5,"_162":-5,"_163":-5,"_164":-5,"_165":-5,"_166":14,"_167":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Templates","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789559999&sig=5c07b77d973a9a7831cc1779f4bd4ec152796753863d0aeae4088e1e0ae03921","tier","business","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":118,"_13":14,"_49":234,"_120":-5,"_121":57,"_122":123,"_124":123,"_125":126,"_127":-5,"_128":129,"_130":82,"_131":48,"_132":-5,"_133":-5,"_134":51,"_135":136,"_137":138,"_139":140,"_141":235,"_143":-5,"_144":145,"_146":145,"_147":148,"_149":148,"_150":148,"_151":145,"_152":145,"_153":236,"_155":237,"_157":238,"_159":57},[213,217,218,219],"files",[213,214,215,216,217,218,219],"counts",{"_203":51,"_204":46,"_205":206,"_32":207,"_208":209},[197,198,199],{"_36":72,"_43":44,"_39":42,"_13":19,"_54":-5,"_52":73,"_17":51,"_41":-5,"_49":195,"_45":46,"_58":-5,"_18":196},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781134761362],[19],{"_36":66,"_13":67,"_39":68,"_41":42,"_43":44,"_45":46,"_47":48,"_49":69,"_17":51,"_52":53,"_54":70,"_56":57,"_58":-5,"_18":202},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":46,"_47":48,"_49":63,"_17":51,"_52":53,"_54":64,"_56":57,"_58":-5,"_18":201},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":200},[19,38],[19,61],[19,67],"pulls","branches","forks",10,{"_210":51,"_212":51},"connections",{"_210":51,"_211":51},"count","unfilledCount","emptyCount",{"_36":72,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":46,"_47":48,"_49":103,"_17":51,"_52":73,"_54":-5,"_56":57,"_58":-5,"_86":232,"_18":233},{"_36":66,"_13":67,"_39":68,"_41":42,"_43":44,"_45":46,"_47":48,"_49":115,"_17":51,"_52":53,"_54":70,"_56":57,"_58":-5,"_86":230,"_18":231},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":46,"_47":48,"_49":112,"_17":51,"_52":53,"_54":64,"_56":57,"_58":-5,"_86":228,"_18":229},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":109,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_86":226,"_18":227},{"_36":96,"_13":97,"_39":98,"_41":-5,"_43":44,"_45":46,"_47":48,"_49":99,"_17":51,"_52":24,"_54":100,"_56":57,"_58":-5,"_86":224,"_18":225},{"_36":89,"_13":90,"_39":91,"_41":-5,"_43":44,"_45":46,"_47":48,"_49":92,"_17":51,"_52":53,"_54":93,"_56":57,"_58":-5,"_86":222,"_18":223},{"_36":80,"_13":81,"_39":82,"_41":-5,"_43":44,"_45":46,"_47":48,"_49":83,"_17":51,"_52":84,"_54":85,"_56":57,"_58":-5,"_86":220,"_18":221},[],[81],[],[90],[],[97],[],[19,38],[],[19,61],[],[19,67],[214,215,216],[19],["D",1781134761362],["D",1789508444194],{"_11":12,"_175":171},{"_11":12,"_168":169,"_170":171,"_128":-5,"_172":173,"_174":48},{"_17":46,"_13":16,"_36":44,"_160":118,"_161":-5,"_162":-5,"_163":-5,"_164":-5,"_165":-5,"_166":14,"_167":12},"ctx",{"_153":-5,"_192":272,"_273":274,"_275":276,"_277":57,"_278":57,"_279":57,"_280":48,"_281":-5,"_282":-7,"_283":-7,"_284":51,"_285":57,"_286":57,"_287":-5,"_288":57,"_289":57,"_290":57,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":16,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"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"]