[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_232":233,"_234":235},"routes/_app.x.$handle.$name",{"_104":103,"_32":45,"_113":90,"_27":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_20":-5,"_125":126,"_127":128,"_129":25,"_130":131,"_132":59,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","019f8a2a-024f-740a-9a80-ce9122a4adf4","name","fileType","script","content","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","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","createdAt",["D",1784729518212],"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",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_18":55,"_109":110,"_111":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":93,"_94":95,"_96":50,"_97":98,"_99":100,"_101":45,"_102":103},"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",{"_43":44,"_32":45,"_38":227,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":228,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":229,"_84":230,"_86":231,"_88":25},"tree",[186,190,191,192],"files",[186,187,188,189,190,191,192],"counts",{"_176":63,"_177":95,"_178":63,"_179":180,"_181":182},"contents",[147,148,149,150],"upstreamProject",{"_43":98,"_32":143,"_52":144,"_54":-5,"_49":50,"_82":145},"upstreamBranch",{"_43":93,"_38":137,"_138":139,"_32":90,"_91":98,"_13":95,"_92":-5,"_94":-5,"_140":141,"_47":-5,"_88":25,"_49":50,"_102":142,"_64":100,"_101":143},"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",{"_104":142,"_112":146},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789541999&sig=156ae2b8ac752fc06f52d45eab428b512e0d31e2aab99a830d8bb32149c64f0f",{"_43":170,"_32":171,"_30":172,"_153":-5,"_41":42,"_40":95,"_154":59,"_38":173,"_13":63,"_33":174,"_35":-5,"_24":25,"_158":-5,"_27":175},{"_43":164,"_32":165,"_30":166,"_153":-5,"_41":42,"_40":95,"_154":59,"_38":167,"_13":63,"_33":20,"_35":168,"_24":25,"_158":-5,"_27":169},{"_43":161,"_32":28,"_30":31,"_153":-5,"_41":42,"_40":14,"_154":59,"_38":162,"_13":95,"_33":34,"_35":37,"_24":25,"_158":-5,"_27":163},{"_43":151,"_32":152,"_30":57,"_153":-5,"_41":42,"_40":95,"_154":25,"_38":155,"_13":63,"_33":156,"_35":157,"_24":25,"_158":159,"_27":160},"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",[152],"76413ec1-eb15-4475-ab95-761d9e5d9344",["D",1784729518212],[28],"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",[165],"3aab88c1-13c9-4d65-ab2f-dcb246e9dc50","components","019f8a2a-024f-740a-9a80-c72ac8a94a86",["D",1784729435570],"directory",[171],"pulls","branches","forks","envVars",{"_183":63,"_185":63},"connections",{"_183":63,"_184":63},"count","unfilledCount","emptyCount",{"_43":170,"_32":171,"_30":172,"_153":-5,"_41":42,"_40":95,"_154":59,"_38":224,"_13":63,"_33":174,"_35":-5,"_24":25,"_158":-5,"_194":225,"_27":226},{"_43":217,"_32":218,"_30":219,"_153":172,"_41":42,"_40":95,"_154":25,"_38":220,"_13":63,"_33":34,"_35":221,"_24":25,"_158":-5,"_194":222,"_27":223},{"_43":210,"_32":211,"_30":212,"_153":172,"_41":42,"_40":95,"_154":25,"_38":213,"_13":63,"_33":34,"_35":214,"_24":25,"_158":-5,"_194":215,"_27":216},{"_43":203,"_32":204,"_30":205,"_153":172,"_41":42,"_40":95,"_154":25,"_38":206,"_13":63,"_33":34,"_35":207,"_24":25,"_158":-5,"_194":208,"_27":209},{"_43":164,"_32":165,"_30":166,"_153":-5,"_41":42,"_40":95,"_154":59,"_38":200,"_13":63,"_33":20,"_35":168,"_24":25,"_158":-5,"_194":201,"_27":202},{"_43":161,"_32":28,"_30":31,"_153":-5,"_41":42,"_40":14,"_154":59,"_38":197,"_13":95,"_33":34,"_35":37,"_24":25,"_158":-5,"_194":198,"_27":199},{"_43":151,"_32":152,"_30":57,"_153":-5,"_41":42,"_40":95,"_154":25,"_38":193,"_13":63,"_33":156,"_35":157,"_24":25,"_158":159,"_194":195,"_27":196},["D",1784729435570],"children",[],[152],["D",1784729518212],[],[28],["D",1784729435570],[],[165],"55fdadc2-dea3-4a4e-8b05-038080b2b47a","SubmissionsPage.tsx","019f8a2a-024f-740a-9a80-c3d77289637a",["D",1784729435570],"/** @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",[],[171,204],"fbd6051f-ae55-4158-9ac5-b1e264f8395e","Layout.tsx","019f8a2a-024f-740a-9a80-bc65133ec8f9",["D",1784729435570],"/** @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",[],[171,211],"0375088c-4ca9-42d3-a5cf-1c4fccd97ade","FormPage.tsx","019f8a2a-024f-740a-9a80-bb93c6ff9228",["D",1784729435570],"/** @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",[],[171,218],["D",1784729435570],[187,188,189],[171],["D",1784729435570],["D",1789473046147],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_18":55,"_109":110,"_111":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":93,"_94":95,"_96":50,"_97":98,"_99":100,"_101":45,"_102":103},"ctx",{"_82":-5,"_134":265,"_266":267,"_268":269,"_270":25,"_271":25,"_272":25,"_273":59,"_274":-5,"_275":-7,"_276":-7,"_277":63,"_278":25,"_279":25,"_280":-5,"_281":25,"_282":25,"_283":25,"_284":-5},"ENV",{"_236":237,"_238":239,"_240":90,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264},"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 · v2