[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_262":263,"_264":265},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_194":-5,"_20":195,"_22":196,"_197":198,"_199":200,"_26":201,"_24":202,"_203":204,"_205":206,"_207":51,"_208":209,"_210":74,"_211":-5,"_212":-5,"_213":214},"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","dcm31","name","email-signup-admin","branchName","main","version","path","components","project",{"_36":146,"_13":14,"_38":147,"_49":-5,"_148":51,"_52":53,"_149":53,"_150":151,"_152":-5,"_153":154,"_155":107,"_156":74,"_157":-5,"_158":-5,"_159":34,"_56":160,"_161":162,"_163":164,"_165":166,"_167":-5,"_168":169,"_170":169,"_171":172,"_173":172,"_174":172,"_175":169,"_176":169,"_177":178,"_179":180,"_181":182,"_50":51},"tree",[101,102,103,104],"file",{"_36":97,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":44,"_73":74,"_38":98,"_17":34,"_76":99,"_78":-5,"_80":51,"_81":-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",6,"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":90,"_13":91,"_65":92,"_67":68,"_69":70,"_71":93,"_73":74,"_38":94,"_17":44,"_76":77,"_78":95,"_80":51,"_81":-5,"_18":96},{"_36":83,"_13":84,"_65":85,"_67":68,"_69":70,"_71":86,"_73":74,"_38":87,"_17":44,"_76":77,"_78":88,"_80":51,"_81":-5,"_18":89},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":75,"_17":44,"_76":77,"_78":79,"_80":51,"_81":-5,"_18":82},"09cc9b07-92e4-4b80-94c5-06b157f24b2f","SubmissionsPage.tsx","fileId","019f8a2a-024f-740a-9a80-c3d77289637a","parentId","019f8a2a-024f-740a-9a80-c72ac8a94a86","branchId","b839aef4-ff9d-455f-bd2e-ed8cfe7cb731","branchVersion",5,"latest",true,["D",1784729579543],"fileType","script","content","/** @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","deleted","label",[19,64],"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",[19,84],"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",[19,91],"3aab88c1-13c9-4d65-ab2f-dcb246e9dc50",["D",1784729435570],"directory",[19],{"_36":97,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":44,"_73":74,"_38":131,"_17":34,"_76":99,"_78":-5,"_80":51,"_81":-5,"_114":132,"_18":133},{"_36":124,"_13":125,"_65":126,"_67":-5,"_69":70,"_71":44,"_73":74,"_38":127,"_17":34,"_76":24,"_78":128,"_80":51,"_81":-5,"_114":129,"_18":130},{"_36":117,"_13":118,"_65":119,"_67":-5,"_69":70,"_71":110,"_73":74,"_38":120,"_17":44,"_76":77,"_78":121,"_80":51,"_81":-5,"_114":122,"_18":123},{"_36":105,"_13":106,"_65":107,"_67":-5,"_69":70,"_71":108,"_73":74,"_38":109,"_17":110,"_76":111,"_78":112,"_80":51,"_81":113,"_114":115,"_18":116},"e2c0143f-05e5-49ea-b5ae-7d9e2df99c74","main.tsx","019f8a2a-024f-740a-9a80-d293a1263259",7,["D",1784729678311],2,"http","/** @jsxImportSource npm:hono/jsx */\nimport { Hono } from \"npm:hono\";\nimport {\n getOAuthUserData,\n oauthMiddleware,\n} from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport AdminPage from \"./components/SubmissionsPage.tsx\";\nimport FormPage from \"./components/FormPage.tsx\";\nimport Layout from \"./components/Layout.tsx\";\nimport { addEmailSignup, listEmailSignups } from \"./db.ts\";\n\nconst OWNER_USER_ID = \"9319c175-2593-4f88-ba21-04f2ef7b1c28\";\nconst app = new Hono();\n\nfunction normalizeEmail(value: string): string {\n return value.trim().toLowerCase();\n}\n\nfunction isValidEmail(email: string): boolean {\n return email.length <= 320 && /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(email);\n}\n\nfunction csvCell(value: string | number): string {\n return `\"${String(value).replaceAll('\"', '\"\"')}\"`;\n}\n\napp.get(\"/\", (c) => c.html());\n\napp.post(\"/signup\", async (c) => {\n const form = new URLSearchParams(await c.req.text());\n const honeypot = String(form.get(\"company\") ?? \"\").trim();\n if (honeypot) return c.redirect(\"/?status=joined\", 303);\n\n const email = normalizeEmail(String(form.get(\"email\") ?? \"\"));\n if (!isValidEmail(email)) return c.redirect(\"/?status=invalid\", 303);\n\n const result = await addEmailSignup(email);\n return c.redirect(result === \"created\" ? \"/?status=joined\" : \"/?status=exists\", 303);\n});\n\napp.get(\"/admin\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return c.redirect(\"/auth/login\");\n\n if (session.user.id !== OWNER_USER_ID) {\n return c.html(\n \n

Access denied

This admin is private.

You are signed in as @{session.user.username ?? \"unknown\"}, but only the owner can view these signups.

\n \n

\n ,\n 403,\n );\n }\n\n const signups = await listEmailSignups();\n return c.html();\n});\n\napp.get(\"/admin.csv\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return c.redirect(\"/auth/login\");\n if (session.user.id !== OWNER_USER_ID) return c.text(\"Forbidden\", 403);\n\n const signups = await listEmailSignups();\n const rows = [\n [\"id\", \"email\", \"created_at\"].map(csvCell).join(\",\"),\n ...signups.map((signup) => [signup.id, signup.email, signup.created_at].map(csvCell).join(\",\")),\n ];\n\n return c.body(rows.join(\"\\r\\n\"), 200, {\n \"Content-Type\": \"text/csv; charset=utf-8\",\n \"Content-Disposition\": 'attachment; filename=\"email-signups.csv\"',\n \"Cache-Control\": \"private, no-store\",\n });\n});\n\napp.get(\"/submissions\", (c) => c.redirect(\"/admin\", 301));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\napp.onError((err) => Promise.reject(err));\n\nexport default oauthMiddleware(app.fetch);\n","charlie-email-signup","children",[],[106],"76413ec1-eb15-4475-ab95-761d9e5d9344","db.ts","019f8a2a-024f-740a-9a80-ce9122a4adf4",["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",[],[118],"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",[],[125],["D",1784729435570],[134,135,136],[19],{"_36":90,"_13":91,"_65":92,"_67":68,"_69":70,"_71":93,"_73":74,"_38":143,"_17":44,"_76":77,"_78":95,"_80":51,"_81":-5,"_114":144,"_18":145},{"_36":83,"_13":84,"_65":85,"_67":68,"_69":70,"_71":86,"_73":74,"_38":140,"_17":44,"_76":77,"_78":88,"_80":51,"_81":-5,"_114":141,"_18":142},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":137,"_17":44,"_76":77,"_78":79,"_80":51,"_81":-5,"_114":138,"_18":139},["D",1784729579543],[],[19,64],["D",1784729529898],[],[19,84],["D",1784729552306],[],[19,91],"5261ca2e-1d74-41b4-8caf-8944db26b3f2",["D",1784729435570],"legacyEnvVars","httpPrivacy","description","Email signup with private admin and CSV","imageUrl","userId","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_193":189},"org",{"_11":12,"_186":187,"_188":189,"_153":154,"_190":191,"_192":51},"branch",{"_17":108,"_13":16,"_36":70,"_42":146,"_45":37,"_46":44,"_183":53,"_184":43,"_185":57,"_58":14,"_54":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","Charlie","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e904faa-3764-4629-c475-f561a49b0000/square512?exp=1789563599&sig=6d4d4bc45e131131f67274a1f94308a04e903573252e7f03fdbea160d142eca1","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":146,"_13":14,"_38":257,"_49":-5,"_148":51,"_52":53,"_149":53,"_150":151,"_152":-5,"_153":154,"_155":107,"_156":74,"_157":-5,"_158":-5,"_159":34,"_56":160,"_161":162,"_163":164,"_165":258,"_167":-5,"_168":169,"_170":169,"_171":172,"_173":172,"_174":172,"_175":169,"_176":169,"_177":259,"_179":260,"_181":261,"_50":51},[236,240,241,242],"files",[236,237,238,239,240,241,242],"counts",{"_227":34,"_228":44,"_229":34,"_35":230,"_231":232},[221,222,223],{"_36":97,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":44,"_73":74,"_38":98,"_17":34,"_76":99,"_78":-5,"_80":51,"_81":-5,"_18":220},"upstreamProject",{"_36":43,"_13":59,"_150":217,"_152":-5,"_52":53,"_177":218},"upstreamBranch",{"_36":37,"_38":215,"_40":216,"_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,"_193":219},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789563599&sig=a969511699ef574c42d646a130422bcd8ffa020e1e59bd8fb5bde6db2cea72c1",[19],{"_36":90,"_13":91,"_65":92,"_67":68,"_69":70,"_71":93,"_73":74,"_38":94,"_17":44,"_76":77,"_78":95,"_80":51,"_81":-5,"_18":226},{"_36":83,"_13":84,"_65":85,"_67":68,"_69":70,"_71":86,"_73":74,"_38":87,"_17":44,"_76":77,"_78":88,"_80":51,"_81":-5,"_18":225},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":75,"_17":44,"_76":77,"_78":79,"_80":51,"_81":-5,"_18":224},[19,64],[19,84],[19,91],"pulls","branches","forks",{"_233":34,"_235":34},"connections",{"_233":34,"_234":34},"count","unfilledCount","emptyCount",{"_36":97,"_13":19,"_65":68,"_67":-5,"_69":70,"_71":44,"_73":74,"_38":131,"_17":34,"_76":99,"_78":-5,"_80":51,"_81":-5,"_114":255,"_18":256},{"_36":90,"_13":91,"_65":92,"_67":68,"_69":70,"_71":93,"_73":74,"_38":143,"_17":44,"_76":77,"_78":95,"_80":51,"_81":-5,"_114":253,"_18":254},{"_36":83,"_13":84,"_65":85,"_67":68,"_69":70,"_71":86,"_73":74,"_38":140,"_17":44,"_76":77,"_78":88,"_80":51,"_81":-5,"_114":251,"_18":252},{"_36":63,"_13":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_38":137,"_17":44,"_76":77,"_78":79,"_80":51,"_81":-5,"_114":249,"_18":250},{"_36":124,"_13":125,"_65":126,"_67":-5,"_69":70,"_71":44,"_73":74,"_38":127,"_17":34,"_76":24,"_78":128,"_80":51,"_81":-5,"_114":247,"_18":248},{"_36":117,"_13":118,"_65":119,"_67":-5,"_69":70,"_71":110,"_73":74,"_38":120,"_17":44,"_76":77,"_78":121,"_80":51,"_81":-5,"_114":245,"_18":246},{"_36":105,"_13":106,"_65":107,"_67":-5,"_69":70,"_71":108,"_73":74,"_38":109,"_17":110,"_76":111,"_78":112,"_80":51,"_81":113,"_114":243,"_18":244},[],[106],[],[118],[],[125],[],[19,64],[],[19,84],[],[19,91],[237,238,239],[19],["D",1784729435570],["D",1789473046147],{"_11":12,"_193":189},{"_11":12,"_186":187,"_188":189,"_153":154,"_190":191,"_192":51},{"_17":108,"_13":16,"_36":70,"_42":146,"_45":37,"_46":44,"_183":53,"_184":43,"_185":57,"_58":14,"_54":12},"ctx",{"_177":-5,"_212":295,"_296":297,"_298":299,"_300":51,"_301":51,"_302":51,"_303":74,"_304":-5,"_305":-7,"_306":-7,"_307":34,"_308":51,"_309":51,"_310":-5,"_311":51,"_312":51,"_313":51,"_314":-5},"ENV",{"_266":267,"_268":269,"_270":16,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294},"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"]