[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_259":260,"_261":262},"routes/_app.x.$handle.$name",{"_102":101,"_37":48,"_110":92,"_32":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_26":-5,"_122":-5,"_123":-5,"_124":30,"_125":126,"_127":62,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_46":47,"_37":48,"_41":49,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":30},"version",12,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","9dc51cca-00dc-45e5-9d16-c365a5fc6548","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":26,"_39":40,"_41":42,"_43":14,"_44":45,"_29":30},"previous","deleted",false,"deletedHere","path","README.md","latestPath","fileId","5b50c3ac-3c0f-11f1-83a6-42b51c65c3df","name","fileType","content","# NYU Workshop Email Collection\n\nA simple fullstack form that collects email addresses for the NYU workshop. Built with Hono + Hono JSX on the server, Twind for styling, and Val Town SQLite for storage.\n\n## Routes\n\n- `GET /` — renders the email collection form\n- `POST /submit` — validates the email and inserts it into SQLite\n- `GET /count` — returns `{ count }` of total stored emails (JSON)\n- `GET /source` — redirects to the val source on Val Town\n\n## Architecture\n\n```mermaid\nflowchart LR\n user([User]) -->|GET /| form[EmailForm.tsx]\n user -->|POST /submit| server[server/app.tsx]\n server -->|INSERT| db[(SQLite
workshop_emails_v1)]\n server -->|render| success[SuccessPage.tsx]\n```\n\n## Files\n\n- `main.tsx` — HTTP entrypoint, re-exports `app.fetch`\n- `server/app.tsx` — Hono app with all routes, uses Hono JSX to render pages\n- `database/migrations.ts` — creates the `workshop_emails_v1` table\n- `database/queries.ts` — `addEmail()` and `getEmailCount()` helpers\n- `frontend/Layout.tsx` — shared HTML shell (Twind + catch script)\n- `frontend/EmailForm.tsx` — the form UI with optional error state\n- `frontend/SuccessPage.tsx` — confirmation page after submit\n\n## Schema\n\n```sql\nCREATE TABLE workshop_emails_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n);\n```\n\nEmails are normalized to lowercase and trimmed before being stored. Duplicate submissions are silently treated as success thanks to the `UNIQUE` constraint.\n","createdAt",["D",1776617207925],"branchVersion","branchId","1ede3cba-3c0f-11f1-9e22-42b51c65c3df","id","1edd7cd0-3c0f-11f1-9e22-42b51c65c3df","nyu-workshop-email-collection",["D",1776617106516],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Email collection form for NYU workshop","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","1ee3bea6-3c0f-11f1-9e22-42b51c65c3df","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","tursoName","1edd7cd03c0f11f19e2242b51c65c3df","tursoHostname","1edd7cd03c0f11f19e2242b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789508444194],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_19":58,"_106":107,"_108":30},"branch",{"_13":14,"_37":92,"_46":45,"_93":47,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":48,"_100":101},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","stevekrouse","handle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_46":47,"_37":48,"_41":254,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":255,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":256,"_87":257,"_89":258,"_91":30},"tree",[179,182,186,188,189],"files",[179,180,181,182,183,184,185,186,187,188,189],"counts",{"_169":66,"_170":140,"_171":66,"_172":173,"_174":175},"contents",[132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_46":163,"_37":164,"_35":165,"_139":-5,"_44":45,"_43":166,"_141":62,"_41":167,"_13":66,"_38":155,"_39":-5,"_29":30,"_145":-5,"_32":168},{"_46":157,"_37":158,"_35":159,"_139":-5,"_44":45,"_43":160,"_141":62,"_41":161,"_13":66,"_38":155,"_39":-5,"_29":30,"_145":-5,"_32":162},{"_46":150,"_37":151,"_35":152,"_139":-5,"_44":45,"_43":153,"_141":62,"_41":154,"_13":66,"_38":155,"_39":-5,"_29":30,"_145":-5,"_32":156},{"_46":147,"_37":33,"_35":36,"_139":-5,"_44":45,"_43":14,"_141":62,"_41":148,"_13":66,"_38":26,"_39":40,"_29":30,"_145":-5,"_32":149},{"_46":137,"_37":138,"_35":60,"_139":-5,"_44":45,"_43":140,"_141":62,"_41":142,"_13":66,"_38":143,"_39":144,"_29":30,"_145":-5,"_32":146},"1ee3bdb6-3c0f-11f1-9e22-42b51c65c3df","main.tsx","parentId",1,"latest",["D",1776617106549],"http","// Entrypoint - see routes in this file\nimport app from './server/app.tsx';\nexport default app.fetch;\n","label",[138],"5b50c2ee-3c0f-11f1-83a6-42b51c65c3df",["D",1776617207925],[33],"288becd0-3c0f-11f1-aa2e-42b51c65c3df","server","71d78af3-f849-4a74-ad7f-e50e41084ae1",4,["D",1776617122746],"directory",[151],"2b19ad5c-3c0f-11f1-8e97-42b51c65c3df","frontend","401b0c76-aea6-49d8-9a14-5692b0f9cd62",5,["D",1776617127001],[158],"2228f432-3c0f-11f1-9e22-42b51c65c3df","database","772094f8-bd5b-4b57-b12d-f17d6bd6b6e8",2,["D",1776617112032],[164],"pulls","branches","forks","envVars",{"_176":66,"_178":66},"connections",{"_176":66,"_177":66},"count","unfilledCount","emptyCount",{"_46":163,"_37":164,"_35":165,"_139":-5,"_44":45,"_43":166,"_141":62,"_41":251,"_13":66,"_38":155,"_39":-5,"_29":30,"_145":-5,"_191":252,"_32":253},{"_46":244,"_37":245,"_35":246,"_139":165,"_44":45,"_43":166,"_141":62,"_41":247,"_13":66,"_38":202,"_39":248,"_29":30,"_145":-5,"_191":249,"_32":250},{"_46":236,"_37":237,"_35":238,"_139":165,"_44":45,"_43":239,"_141":62,"_41":240,"_13":66,"_38":202,"_39":241,"_29":30,"_145":-5,"_191":242,"_32":243},{"_46":157,"_37":158,"_35":159,"_139":-5,"_44":45,"_43":160,"_141":62,"_41":233,"_13":66,"_38":155,"_39":-5,"_29":30,"_145":-5,"_191":234,"_32":235},{"_46":225,"_37":226,"_35":227,"_139":159,"_44":45,"_43":228,"_141":62,"_41":229,"_13":140,"_38":202,"_39":230,"_29":30,"_145":-5,"_191":231,"_32":232},{"_46":217,"_37":218,"_35":219,"_139":159,"_44":45,"_43":220,"_141":62,"_41":221,"_13":140,"_38":202,"_39":222,"_29":30,"_145":-5,"_191":223,"_32":224},{"_46":209,"_37":210,"_35":211,"_139":159,"_44":45,"_43":212,"_141":62,"_41":213,"_13":140,"_38":202,"_39":214,"_29":30,"_145":-5,"_191":215,"_32":216},{"_46":150,"_37":151,"_35":152,"_139":-5,"_44":45,"_43":153,"_141":62,"_41":206,"_13":66,"_38":155,"_39":-5,"_29":30,"_145":-5,"_191":207,"_32":208},{"_46":197,"_37":198,"_35":199,"_139":152,"_44":45,"_43":200,"_141":62,"_41":201,"_13":140,"_38":202,"_39":203,"_29":30,"_145":-5,"_191":204,"_32":205},{"_46":147,"_37":33,"_35":36,"_139":-5,"_44":45,"_43":14,"_141":62,"_41":194,"_13":66,"_38":26,"_39":40,"_29":30,"_145":-5,"_191":195,"_32":196},{"_46":137,"_37":138,"_35":60,"_139":-5,"_44":45,"_43":140,"_141":62,"_41":190,"_13":66,"_38":143,"_39":144,"_29":30,"_145":-5,"_191":192,"_32":193},["D",1776617106549],"children",[],[138],["D",1776617207925],[],[33],"3eb9de72-3c0f-11f1-89e8-42b51c65c3df","app.tsx","288bc8cc-3c0f-11f1-aa2e-42b51c65c3df",8,["D",1776617159948],"script","/** @jsxImportSource npm:hono/jsx */\nimport { Hono } from \"npm:hono\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"../database/migrations.ts\";\nimport { addEmail, getEmailCount } from \"../database/queries.ts\";\nimport Layout from \"../frontend/Layout.tsx\";\nimport EmailForm from \"../frontend/EmailForm.tsx\";\nimport SuccessPage from \"../frontend/SuccessPage.tsx\";\n\nawait runMigrations();\n\nconst app = new Hono();\n\n// Full stack traces during development\napp.onError((err) => {\n throw err;\n});\n\napp.get(\"/\", (c) => {\n return c.html(\n \n \n ,\n );\n});\n\napp.post(\"/submit\", async (c) => {\n const form = await c.req.formData();\n const emailRaw = form.get(\"email\");\n const email = typeof emailRaw === \"string\" ? emailRaw.trim().toLowerCase() : \"\";\n\n // Simple email validation\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!email || !emailRegex.test(email)) {\n return c.html(\n \n \n ,\n );\n }\n\n try {\n await addEmail(email);\n } catch (err: any) {\n // Unique constraint violation — treat as success but show a friendly note\n if (!String(err?.message ?? \"\").includes(\"UNIQUE\")) {\n console.error(\"Failed to save email:\", err);\n return c.html(\n \n \n ,\n );\n }\n }\n\n return c.html(\n \n \n ,\n );\n});\n\napp.get(\"/count\", async (c) => {\n const count = await getEmailCount();\n return c.json({ count });\n});\n\n// View source\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default app;\n",[],[151,198],["D",1776617122746],[187],[151],"474eac5c-3c0f-11f1-83a6-42b51c65c3df","SuccessPage.tsx","319bfb62-3c0f-11f1-ad14-42b51c65c3df",11,["D",1776617174336],"/** @jsxImportSource npm:hono/jsx */\nimport type { FC } from \"npm:hono/jsx\";\n\ntype Props = {\n email: string;\n};\n\nconst SuccessPage: FC = ({ email }) => {\n return (\n

\n ✓\n

You're on the list!

\n We saved {email}. Thanks for signing up.\n

\n \n Back to form\n \n

\n );\n};\n\nexport default SuccessPage;\n",[],[158,210],"4141adc8-3c0f-11f1-83a6-42b51c65c3df","Layout.tsx","2b199e34-3c0f-11f1-8e97-42b51c65c3df",9,["D",1776617164192],"/** @jsxImportSource npm:hono/jsx */\nimport type { FC } from \"npm:hono/jsx\";\n\nconst Layout: FC = ({ children }) => {\n return (\n \n \n \n \n NYU Workshop Email Collection\n \n \n \n \n

\n {children}\n

\n \n \n \n );\n};\n\nexport default Layout;\n",[],[158,218],"45276252-3c0f-11f1-83a6-42b51c65c3df","EmailForm.tsx","2f3fdcda-3c0f-11f1-83a6-42b51c65c3df",10,["D",1776617170731],"/** @jsxImportSource npm:hono/jsx */\nimport type { FC } from \"npm:hono/jsx\";\n\ntype Props = {\n error?: string;\n defaultValue?: string;\n};\n\nconst EmailForm: FC = ({ error, defaultValue = \"\" }) => {\n return (\n

\n NYU Workshop\n

Join the list

\n Enter your email to stay in the loop about the workshop.\n

\n\n

\n );\n};\n\nexport default EmailForm;\n",[],[158,226],["D",1776617127001],[183,184,185],[158],"238e2d9c-3c0f-11f1-8e97-42b51c65c3df","queries.ts","238e2e3c-3c0f-11f1-8e97-42b51c65c3df",3,["D",1776617114373],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { TABLE_NAME } from \"./migrations.ts\";\n\nexport async function addEmail(email: string) {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAME} (email) VALUES (?)`,\n args: [email],\n });\n}\n\nexport async function getEmailCount(): Promise {\n const result = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${TABLE_NAME}`,\n );\n return Number((result.rows[0] as any).count);\n}\n",[],[164,237],"2228e71c-3c0f-11f1-9e22-42b51c65c3df","migrations.ts","2228e884-3c0f-11f1-9e22-42b51c65c3df",["D",1776617112032],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport const TABLE_NAME = \"workshop_emails_v1\";\n\nexport async function runMigrations() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n",[],[164,245],["D",1776617112032],[180,181],[164],["D",1776617106516],["D",1789508444194],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_19":58,"_106":107,"_108":30},{"_13":14,"_37":92,"_46":45,"_93":47,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":48,"_100":101},"ctx",{"_85":-5,"_129":292,"_293":294,"_295":296,"_297":30,"_298":30,"_299":30,"_300":62,"_301":-5,"_302":-7,"_303":-7,"_304":66,"_305":30,"_306":30,"_307":-5,"_308":30,"_309":30,"_310":30,"_311":-5},"ENV",{"_263":264,"_265":266,"_267":92,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291},"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 · v12