[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_223":224,"_225":226},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_168":-5,"_20":169,"_22":170,"_171":172,"_173":174,"_26":175,"_24":176,"_177":-5,"_178":-5,"_179":54,"_180":181,"_182":45,"_183":-5,"_184":-5,"_185":186},"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","aurorinmagazine","name","one-hr-with-god-sqlite-base","branchName","main","version","path","components/Layout.tsx","project",{"_33":110,"_13":14,"_46":111,"_112":-5,"_113":54,"_114":115,"_116":115,"_117":118,"_119":-5,"_120":121,"_122":64,"_123":45,"_124":-5,"_125":-5,"_126":48,"_127":128,"_129":130,"_131":132,"_133":134,"_135":-5,"_136":137,"_138":137,"_139":140,"_141":140,"_142":140,"_143":137,"_144":137,"_145":146,"_147":148,"_149":150,"_151":54},"tree",[58,59,60,61],"file",{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"contents",[],"upstream","pull","ahead","behind","envVars","id","7a2a3a2c-b824-4053-a0ef-59188a8445c7","Layout.tsx","fileId","01a0367e-5017-722e-bddc-1d6cdf9bfe65","parentId","01a0367e-5017-722e-bddc-24040ead425c","branchId","9df2fcff-6995-4795-b341-6ff8481833aa","branchVersion",1,"latest",true,"createdAt",["D",1787620642768],0,"fileType","script","content","/** @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","deleted",false,"label",[57,35],"components",{"_33":85,"_13":57,"_36":39,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":86,"_17":48,"_49":87,"_51":-5,"_53":54,"_55":-5,"_68":88,"_18":89},{"_33":78,"_13":79,"_36":80,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":81,"_17":48,"_49":24,"_51":82,"_53":54,"_55":-5,"_68":83,"_18":84},{"_33":71,"_13":72,"_36":73,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":74,"_17":48,"_49":50,"_51":75,"_53":54,"_55":-5,"_68":76,"_18":77},{"_33":62,"_13":63,"_36":64,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":65,"_17":48,"_49":66,"_51":67,"_53":54,"_55":-5,"_68":69,"_18":70},"45acdbec-6189-4870-a5c2-fe23b6c295c7","main.tsx","01a0367e-5017-722e-bddc-303c560f40e0",["D",1787620642768],"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",[],[63],"660b8308-722b-42b0-bb10-b95fbf63a216","db.ts","01a0367e-5017-722e-bddc-2d79914881aa",["D",1787620642768],"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",[],[72],"6746ccc1-1f93-4167-852c-89bc41da2aa1","README.md","01a0367e-5017-722e-bddc-29b165cd31d8",["D",1787620642768],"# 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",[],[79],"a178c489-5d86-4d94-8146-fc362cf9db3c",["D",1787620642768],"directory",[90,91,92],[57],{"_33":103,"_13":104,"_36":105,"_38":39,"_40":41,"_42":43,"_44":45,"_46":106,"_17":48,"_49":50,"_51":107,"_53":54,"_55":-5,"_68":108,"_18":109},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":100,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":101,"_18":102},{"_33":93,"_13":94,"_36":95,"_38":39,"_40":41,"_42":43,"_44":45,"_46":96,"_17":48,"_49":50,"_51":97,"_53":54,"_55":-5,"_68":98,"_18":99},"dc0804a6-3cfa-4861-ab50-b4a13bb1073a","SubmissionsPage.tsx","01a0367e-5017-722e-bddc-205820cdb9d6",["D",1787620642768],"/** @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",[],[57,94],["D",1787620642768],[],[57,35],"45c5583f-b03c-49fa-9c77-b902795ca72f","FormPage.tsx","01a0367e-5016-761e-bfce-eb7189f60beb",["D",1787620642768],"/** @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",[],[57,104],"3d3ddb57-4e1f-4cbd-b0a1-6b9c41a33d12",["D",1787620642768],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","SQLite foundation for 1Hr With God","imageUrl","userId","1066b61b-f70a-46a7-8125-91c596378659","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a02a5a-86ef-7312-9a9e-ddcd707af361","tursoName","3d3ddb574e1f4cbdb0a16b9c41a33d12","tursoHostname","3d3ddb574e1f4cbdb0a16b9c41a33d12-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789533091345],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_167":163},"org",{"_11":12,"_160":161,"_162":163,"_120":121,"_164":165,"_166":54},"branch",{"_17":43,"_13":16,"_33":41,"_152":110,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":14,"_159":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Aurorin Magazine","avatar","https://lh3.googleusercontent.com/a/ACg8ocJ8i2UIZrlsQap-nn3UPmSBKMkeYfBAHCiy5Y-K4y1DhFt-Bh4=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":110,"_13":14,"_46":218,"_112":-5,"_113":54,"_114":115,"_116":115,"_117":118,"_119":-5,"_120":121,"_122":64,"_123":45,"_124":-5,"_125":-5,"_126":48,"_127":128,"_129":130,"_131":132,"_133":219,"_135":-5,"_136":137,"_138":137,"_139":140,"_141":140,"_142":140,"_143":137,"_144":137,"_145":220,"_147":221,"_149":222,"_151":54},[197,201,202,203],"files",[197,198,199,200,201,202,203],"counts",{"_188":48,"_189":43,"_190":48,"_32":191,"_192":193},[],{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":187},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[57,35],"pulls","branches","forks",{"_194":48,"_196":48},"connections",{"_194":48,"_195":48},"count","unfilledCount","emptyCount",{"_33":85,"_13":57,"_36":39,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":86,"_17":48,"_49":87,"_51":-5,"_53":54,"_55":-5,"_68":216,"_18":217},{"_33":103,"_13":104,"_36":105,"_38":39,"_40":41,"_42":43,"_44":45,"_46":106,"_17":48,"_49":50,"_51":107,"_53":54,"_55":-5,"_68":214,"_18":215},{"_33":34,"_13":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":100,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":212,"_18":213},{"_33":93,"_13":94,"_36":95,"_38":39,"_40":41,"_42":43,"_44":45,"_46":96,"_17":48,"_49":50,"_51":97,"_53":54,"_55":-5,"_68":210,"_18":211},{"_33":78,"_13":79,"_36":80,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":81,"_17":48,"_49":24,"_51":82,"_53":54,"_55":-5,"_68":208,"_18":209},{"_33":71,"_13":72,"_36":73,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":74,"_17":48,"_49":50,"_51":75,"_53":54,"_55":-5,"_68":206,"_18":207},{"_33":62,"_13":63,"_36":64,"_38":-5,"_40":41,"_42":43,"_44":45,"_46":65,"_17":48,"_49":66,"_51":67,"_53":54,"_55":-5,"_68":204,"_18":205},[],[63],[],[72],[],[79],[],[57,94],[],[57,35],[],[57,104],[198,199,200],[57],["D",1787620642768],["D",1789533091345],{"_11":12,"_167":163},{"_11":12,"_160":161,"_162":163,"_120":121,"_164":165,"_166":54},{"_17":43,"_13":16,"_33":41,"_152":110,"_153":-5,"_154":-5,"_155":-5,"_156":-5,"_157":-5,"_158":14,"_159":12},"ctx",{"_145":-5,"_184":256,"_257":258,"_259":260,"_261":54,"_262":54,"_263":54,"_264":45,"_265":-5,"_266":-7,"_267":-7,"_268":48,"_269":54,"_270":54,"_271":-5,"_272":54,"_273":54,"_274":54,"_275":-5},"ENV",{"_227":228,"_229":230,"_231":16,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255},"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"]