[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_225":226,"_227":228},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_107":88,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":57,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","probe_common.ts","latestPath","fileId","ece68ce2-aad8-11f1-bd95-1607ee4eb77e","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nexport async function reset(tag:string){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS crash_probe(\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n case_tag TEXT NOT NULL,\n marker TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n await sqlite.execute(\"DELETE FROM crash_probe\");\n await sqlite.execute({sql:\"INSERT INTO crash_probe(case_tag,marker) VALUES (?,?)\",args:[tag,\"baseline\"]});\n}\nexport async function snapshot(){\n const r:any=await sqlite.execute(\"SELECT id,case_tag,marker,created_at FROM crash_probe ORDER BY id\");\n return r.rows||[];\n}\nexport async function verifyAndWrite(tag:string){\n const before=await snapshot();\n const tx:any=await (sqlite as any).transaction(\"write\");\n let committed=false;\n try{\n await tx.execute({sql:\"INSERT INTO crash_probe(case_tag,marker) VALUES (?,?)\",args:[tag,\"postcheck_commit\"]});\n await tx.commit();\n committed=true;\n }catch(e){\n try{await tx.rollback()}catch{}\n return {ok:false,before,postcheck_error:e instanceof Error?e.message:String(e),committed:false,after:await snapshot()};\n }\n return {ok:true,before,committed,after:await snapshot()};\n}\n","createdAt",["D",1788798408874],"branchVersion","branchId","4231d0f7-7a8c-46f4-8b5e-a340def24c72","id","8749561c-801a-45c3-9193-b0072ae97e31","brain-crash-atomicity-probe-r4-20260907",["D",1788798321398],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Disposable transaction crash atomicity falsifier","imageUrl","6be0fc5c-1fef-4bd6-a1e1-67a3f8c0764e","pinnedFileId","01a07cb0-43cd-76af-a28d-aceb3b1313cb","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0715b-703f-741f-ab35-c85020e4a5e0","tursoName","8749561c801a45c39193b0072ae97e31","tursoHostname","8749561c801a45c39193b0072ae97e31-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789494036282],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","mosadek","handle","displayName","Mo Sadek","avatar","https://lh3.googleusercontent.com/a/ACg8ocL1eT_LHhKSg5px3nXIO6eez79aZXef466qXKh2gak-0iwrvw=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":220,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":221,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":222,"_82":223,"_84":224,"_86":24},"tree",[175,179,180,181,182],"files",[175,176,177,178,179,180,181,182],"counts",{"_165":61,"_166":142,"_167":61,"_168":169,"_170":171},"contents",[129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":159,"_31":160,"_29":161,"_135":-5,"_39":40,"_38":142,"_136":57,"_36":162,"_13":61,"_32":163,"_34":-5,"_23":24,"_138":-5,"_26":164},{"_41":153,"_31":154,"_29":155,"_135":-5,"_39":40,"_38":142,"_136":57,"_36":156,"_13":61,"_32":20,"_34":157,"_23":24,"_138":-5,"_26":158},{"_41":147,"_31":148,"_29":149,"_135":-5,"_39":40,"_38":142,"_136":57,"_36":150,"_13":61,"_32":33,"_34":151,"_23":24,"_138":-5,"_26":152},{"_41":140,"_31":141,"_29":55,"_135":-5,"_39":40,"_38":142,"_136":57,"_36":143,"_13":61,"_32":144,"_34":145,"_23":24,"_138":-5,"_26":146},{"_41":134,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_136":57,"_36":137,"_13":61,"_32":33,"_34":35,"_23":24,"_138":-5,"_26":139},"232a0f99-3d2c-48ce-af93-f3a1d75b0c17","parentId","latest",["D",1788798408874],"label",[27],"d299b32f-5765-48d2-bb08-23dfc215e961","main.tsx",1,["D",1788798321398],"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",[141],"10c0e51d-2edd-49f8-9309-a1b631d1b9bb","db.ts","01a07cb0-43cd-76af-a28d-aaeb8d6030e6",["D",1788798321398],"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",[148],"863c306b-04fa-48f5-9006-6b29008b3b78","README.md","01a07cb0-43cd-76af-a28d-a6b197369275",["D",1788798321398],"# 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",[154],"30c86719-fa09-4411-8723-89423002a43e","components","01a07cb0-43cd-76af-a28d-a30b40ef5c9f",["D",1788798321398],"directory",[160],"pulls","branches","forks","envVars",{"_172":61,"_174":61},"connections",{"_172":61,"_173":61},"count","unfilledCount","emptyCount",{"_41":159,"_31":160,"_29":161,"_135":-5,"_39":40,"_38":142,"_136":57,"_36":217,"_13":61,"_32":163,"_34":-5,"_23":24,"_138":-5,"_184":218,"_26":219},{"_41":210,"_31":211,"_29":212,"_135":161,"_39":40,"_38":142,"_136":57,"_36":213,"_13":61,"_32":33,"_34":214,"_23":24,"_138":-5,"_184":215,"_26":216},{"_41":203,"_31":204,"_29":205,"_135":161,"_39":40,"_38":142,"_136":57,"_36":206,"_13":61,"_32":33,"_34":207,"_23":24,"_138":-5,"_184":208,"_26":209},{"_41":196,"_31":197,"_29":198,"_135":161,"_39":40,"_38":142,"_136":57,"_36":199,"_13":61,"_32":33,"_34":200,"_23":24,"_138":-5,"_184":201,"_26":202},{"_41":153,"_31":154,"_29":155,"_135":-5,"_39":40,"_38":142,"_136":57,"_36":193,"_13":61,"_32":20,"_34":157,"_23":24,"_138":-5,"_184":194,"_26":195},{"_41":147,"_31":148,"_29":149,"_135":-5,"_39":40,"_38":142,"_136":57,"_36":190,"_13":61,"_32":33,"_34":151,"_23":24,"_138":-5,"_184":191,"_26":192},{"_41":140,"_31":141,"_29":55,"_135":-5,"_39":40,"_38":142,"_136":57,"_36":187,"_13":61,"_32":144,"_34":145,"_23":24,"_138":-5,"_184":188,"_26":189},{"_41":134,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_136":57,"_36":183,"_13":61,"_32":33,"_34":35,"_23":24,"_138":-5,"_184":185,"_26":186},["D",1788798408874],"children",[],[27],["D",1788798321398],[],[141],["D",1788798321398],[],[148],["D",1788798321398],[],[154],"c6996dcc-7e2e-4ed5-b390-879db74a5523","SubmissionsPage.tsx","01a07cb0-43cd-76af-a28d-9f39231fd077",["D",1788798321398],"/** @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",[],[160,197],"52870e04-c80f-4f66-ac07-6262bd09eb42","Layout.tsx","01a07cb0-43cd-76af-a28d-9ab27f5b6bcb",["D",1788798321398],"/** @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",[],[160,204],"b1967015-f0f6-43ae-a783-a2c714e5542c","FormPage.tsx","01a07cb0-43cd-76af-a28d-969fa5503eee",["D",1788798321398],"/** @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",[],[160,211],["D",1788798321398],[176,177,178],[160],["D",1788798321398],["D",1789494036282],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_126":258,"_259":260,"_261":262,"_263":24,"_264":24,"_265":24,"_266":57,"_267":-5,"_268":-7,"_269":-7,"_270":61,"_271":24,"_272":24,"_273":-5,"_274":24,"_275":24,"_276":24,"_277":-5},"ENV",{"_229":230,"_231":232,"_233":88,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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