[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_236":237,"_238":239},"routes/_app.x.$handle.$name",{"_105":104,"_32":46,"_114":91,"_27":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_20":-5,"_126":127,"_128":129,"_130":25,"_131":132,"_133":60,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",5,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","components/SubmissionsPage.tsx","latestPath","fileId","019f8a2a-024f-740a-9a80-c3d77289637a","name","SubmissionsPage.tsx","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","/** @jsxImportSource npm:hono/jsx */\nimport type { EmailSignup } from \"../db.ts\";\nimport Layout from \"./Layout.tsx\";\n\nexport default function AdminPage({\n signups,\n username,\n}: {\n signups: EmailSignup[];\n username: string;\n}) {\n return (\n \n

Private admin

Email signups

\n {signups.length} {signups.length === 1 ? \"subscriber\" : \"subscribers\"} · signed in as @{username}\n

\n \n Download CSV\n \n \n Public page\n \n \n

\n\n

\n {signups.length === 0\n ? (\n

No signups yet

Share the public page and the first signup will appear here.

\n )\n : (\n

\n \n \n \n \n \n \n \n \n \n {signups.map((signup) => (\n \n \n \n \n \n ))}\n \n

#	Email	Signed up (UTC)
{signup.id}	\n {signup.email}\n	{signup.created_at}

\n )}\n

\n\n \n \n );\n}\n","createdAt",["D",1784729579543],"branchVersion","branchId","b839aef4-ff9d-455f-bd2e-ed8cfe7cb731","id","5261ca2e-1d74-41b4-8caf-8944db26b3f2","email-signup-admin",["D",1784729435570],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Email signup with private admin and CSV","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","019f8a2a-024f-740a-9a80-d293a1263259","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d663a026-6449-42f6-9156-1d4a2d64d38c","tursoName","5261ca2e1d7441b48caf8944db26b3f2","tursoHostname","5261ca2e1d7441b48caf8944db26b3f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789473046147],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_18":56,"_110":111,"_112":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":94,"_95":96,"_97":51,"_98":99,"_100":101,"_102":46,"_103":104},"isOwned",7,"main","projectId","forkedBranchId","fb141f8d-047d-43b3-b09c-7fd59d8ddcfe","forkedBranchVersion",1,"forkedProjectPrivacy","forkedProjectId","a35fc79f-ccd4-4375-94dc-260d312636c6","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","dcm31","handle","displayName","Charlie","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e904faa-3764-4629-c475-f561a49b0000/square512?exp=1789541999&sig=7032040c53bed00f88177505596e579d7fe702ff82f3f97f431146d41baae6d9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":231,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":232,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":233,"_85":234,"_87":235,"_89":25},"tree",[191,195,196,197],"files",[191,192,193,194,195,196,197],"counts",{"_181":64,"_182":96,"_183":64,"_184":185,"_186":187},"contents",[148,149,150,151],"upstreamProject",{"_44":99,"_32":144,"_53":145,"_55":-5,"_50":51,"_83":146},"upstreamBranch",{"_44":94,"_39":138,"_139":140,"_32":91,"_92":99,"_13":96,"_93":-5,"_95":-5,"_141":142,"_48":-5,"_89":25,"_50":51,"_103":143,"_65":101,"_102":144},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781134761362],"updatedAt",["D",1781134761362],"lockfileKey","1781135021367-esm.town_v_templates_form-to-sqlite@1-main","templates","form-to-sqlite","Put a form online and save submissions to SQLite",{"_105":143,"_113":147},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789541999&sig=156ae2b8ac752fc06f52d45eab428b512e0d31e2aab99a830d8bb32149c64f0f",{"_44":175,"_32":176,"_30":177,"_154":-5,"_42":43,"_41":96,"_155":60,"_39":178,"_13":64,"_34":179,"_36":-5,"_24":25,"_159":-5,"_27":180},{"_44":169,"_32":170,"_30":171,"_154":-5,"_42":43,"_41":96,"_155":60,"_39":172,"_13":64,"_34":20,"_36":173,"_24":25,"_159":-5,"_27":174},{"_44":162,"_32":163,"_30":164,"_154":-5,"_42":43,"_41":165,"_155":60,"_39":166,"_13":96,"_34":35,"_36":167,"_24":25,"_159":-5,"_27":168},{"_44":152,"_32":153,"_30":58,"_154":-5,"_42":43,"_41":96,"_155":25,"_39":156,"_13":64,"_34":157,"_36":158,"_24":25,"_159":160,"_27":161},"ddc0dbf6-961e-4afe-bd38-88775973eb93","main.tsx","parentId","latest",["D",1784729435570],"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","label","charlie-email-signup",[153],"76413ec1-eb15-4475-ab95-761d9e5d9344","db.ts","019f8a2a-024f-740a-9a80-ce9122a4adf4",2,["D",1784729518212],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface EmailSignup {\n id: number;\n email: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS email_signups (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE COLLATE NOCASE,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addEmailSignup(email: string): Promise<\"created\" | \"exists\"> {\n const result = await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO email_signups (email) VALUES (?)\",\n args: [email],\n });\n\n return result.rowsAffected === 1 ? \"created\" : \"exists\";\n}\n\nexport async function listEmailSignups(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, email, created_at FROM email_signups ORDER BY id DESC\",\n );\n\n return result.rows as unknown as EmailSignup[];\n}\n",[163],"de476fee-7f6a-45f3-bf22-2e7cc7f080ca","README.md","019f8a2a-024f-740a-9a80-c85300f5c299",["D",1784729435570],"# 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",[170],"3aab88c1-13c9-4d65-ab2f-dcb246e9dc50","components","019f8a2a-024f-740a-9a80-c72ac8a94a86",["D",1784729435570],"directory",[176],"pulls","branches","forks","envVars",{"_188":64,"_190":64},"connections",{"_188":64,"_189":64},"count","unfilledCount","emptyCount",{"_44":175,"_32":176,"_30":177,"_154":-5,"_42":43,"_41":96,"_155":60,"_39":228,"_13":64,"_34":179,"_36":-5,"_24":25,"_159":-5,"_199":229,"_27":230},{"_44":220,"_32":221,"_30":222,"_154":177,"_42":43,"_41":223,"_155":60,"_39":224,"_13":96,"_34":35,"_36":225,"_24":25,"_159":-5,"_199":226,"_27":227},{"_44":212,"_32":213,"_30":214,"_154":177,"_42":43,"_41":215,"_155":60,"_39":216,"_13":96,"_34":35,"_36":217,"_24":25,"_159":-5,"_199":218,"_27":219},{"_44":208,"_32":33,"_30":31,"_154":177,"_42":43,"_41":14,"_155":60,"_39":209,"_13":96,"_34":35,"_36":38,"_24":25,"_159":-5,"_199":210,"_27":211},{"_44":169,"_32":170,"_30":171,"_154":-5,"_42":43,"_41":96,"_155":60,"_39":205,"_13":64,"_34":20,"_36":173,"_24":25,"_159":-5,"_199":206,"_27":207},{"_44":162,"_32":163,"_30":164,"_154":-5,"_42":43,"_41":165,"_155":60,"_39":202,"_13":96,"_34":35,"_36":167,"_24":25,"_159":-5,"_199":203,"_27":204},{"_44":152,"_32":153,"_30":58,"_154":-5,"_42":43,"_41":96,"_155":25,"_39":198,"_13":64,"_34":157,"_36":158,"_24":25,"_159":160,"_199":200,"_27":201},["D",1784729435570],"children",[],[153],["D",1784729518212],[],[163],["D",1784729435570],[],[170],"09cc9b07-92e4-4b80-94c5-06b157f24b2f",["D",1784729579543],[],[176,33],"e3ecbed2-10df-48c1-8d64-8f850e9d7684","Layout.tsx","019f8a2a-024f-740a-9a80-bc65133ec8f9",3,["D",1784729529898],"/** @jsxImportSource npm:hono/jsx */\n\nexport default function Layout({\n title,\n children,\n wide = false,\n}: {\n title: string;\n children?: unknown;\n wide?: boolean;\n}) {\n return (\n \n \n \n \n \n {title}\n \n \n \n \n

\n {children}\n

\n \n \n );\n}\n",[],[176,213],"4fd58d72-6680-4514-b35b-f04c96527aaa","FormPage.tsx","019f8a2a-024f-740a-9a80-bb93c6ff9228",4,["D",1784729552306],"/** @jsxImportSource npm:hono/jsx */\nimport Layout from \"./Layout.tsx\";\n\nexport default function FormPage({ status }: { status?: string }) {\n const joined = status === \"joined\";\n const exists = status === \"exists\";\n const invalid = status === \"invalid\";\n\n return (\n \n

\n \n Email updates\n

\n Stay in the loop.\n

\n Get occasional updates delivered directly to your inbox. No spam, no noise, and you can unsubscribe anytime.\n

\n\n {joined && (\n

\n You’re on the list. Check your inbox for future updates.\n

\n )}\n {exists && (\n

\n That email is already on the list.\n

\n )}\n {invalid && (\n

\n Enter a valid email address.\n

\n )}\n\n \n\n

\n Your email stays private.\n

\n Admin\n View source\n

\n \n );\n}\n",[],[176,221],["D",1784729435570],[192,193,194],[176],["D",1784729435570],["D",1789473046147],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_18":56,"_110":111,"_112":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":94,"_95":96,"_97":51,"_98":99,"_100":101,"_102":46,"_103":104},"ctx",{"_83":-5,"_135":269,"_270":271,"_272":273,"_274":25,"_275":25,"_276":25,"_277":60,"_278":-5,"_279":-7,"_280":-7,"_281":64,"_282":25,"_283":25,"_284":-5,"_285":25,"_286":25,"_287":25,"_288":-5},"ENV",{"_240":241,"_242":243,"_244":91,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268},"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"]

Diff · v5