[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_237":238,"_239":240},"routes/_app.x.$handle.$name",{"_102":101,"_33":47,"_111":92,"_28":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_20":-5,"_123":-5,"_124":-5,"_125":27,"_126":127,"_128":25,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_45":46,"_33":47,"_40":48,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":55,"_56":57,"_18":58,"_59":60,"_61":25,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":65,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":27},"version",124,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":34,"_35":36,"_37":39,"_40":41,"_42":14,"_43":44,"_24":27},"previous",{"_31":32,"_33":34,"_35":36,"_37":38},"deleted",true,"deletedHere",false,"path","sqlite/read.ts","latestPath","fileId","dee07514-6280-11f0-b268-0224a6c84d84","name","read.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\n\nawait sqlite.execute(\n `DELETE FROM subscribers WHERE email IN ('pdm8dc@virginia.edu', 'pete+040925@petemillspaugh.com', 'pete+071525@petemillspaugh.com');`,\n);\n\nconsole.log(await sqlite.execute(`SELECT * FROM subscribers;`));\nconsole.log(await sqlite.execute(`SELECT * FROM newsletters;`));\nconsole.log(await sqlite.execute(`SELECT * FROM email_logs;`));","import { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\n\nawait sqlite.execute(\n `UPDATE subscribers SET verified = 1 WHERE email = 'juan@membrane.io';`,\n);\n\nconsole.log(await sqlite.execute(`SELECT * FROM subscribers;`));\nconsole.log(await sqlite.execute(`SELECT * FROM newsletters;`));\nconsole.log(await sqlite.execute(`SELECT * FROM email_logs;`));","createdAt",["D",1752696983172],"branchVersion","branchId","798e355a-2772-11f0-b46e-569c3dd06744","id","798de9ec-2772-11f0-b46e-569c3dd06744","garden",["D",1746203306756],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","https://petemillspaugh.com","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/ccc02d2f-ec0d-49a2-d1de-8e476f454c00/square512?exp=1789588652&sig=70a89d51a980e4b7f569d5c209fb95e6e89cc796dcac1264a2d5061ec479e0c6","6906d0a1-0165-46b9-8717-60dfd935316a","pinnedFileId","7990876a-2772-11f0-b46e-569c3dd06744","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","631c5cff-7089-4994-8427-c7580df789cd","tursoName","798de9ec277211f0b46e569c3dd06744","tursoHostname","798de9ec277211f0b46e569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789504321592],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_110":106},"org",{"_102":101,"_103":104,"_105":106,"_18":58,"_107":108,"_109":27},"branch",{"_13":91,"_33":92,"_45":44,"_93":46,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":47,"_100":101},"isOwned",362,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pmillspaugh","handle","displayName","Pete Millspaugh","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c3c0aadf-86a9-4c2e-ef01-fb649d6fb000/square512?exp=1789588652&sig=fbe9a6779963f4abe7c132ac3c464ba75c4f25f286419c7f0256bc8f8b4436b1","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_45":46,"_33":47,"_40":232,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":55,"_56":57,"_18":58,"_59":60,"_61":25,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":233,"_74":65,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":234,"_86":235,"_88":236,"_90":27},"tree",[180,183,186,187],"files",[180,181,182,183,184,185,186,187],"counts",{"_169":170,"_171":65,"_172":65,"_173":174,"_175":176},"contents",[133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_45":163,"_33":164,"_31":165,"_139":-5,"_43":44,"_42":166,"_141":25,"_40":167,"_13":65,"_35":161,"_37":-5,"_24":27,"_146":-5,"_28":168},{"_45":156,"_33":157,"_31":158,"_139":-5,"_43":44,"_42":159,"_141":25,"_40":160,"_13":65,"_35":161,"_37":-5,"_24":27,"_146":-5,"_28":162},{"_45":148,"_33":149,"_31":150,"_139":-5,"_43":44,"_42":151,"_141":27,"_40":152,"_13":153,"_35":20,"_37":154,"_24":27,"_146":-5,"_28":155},{"_45":137,"_33":138,"_31":60,"_139":-5,"_43":44,"_42":140,"_141":27,"_40":142,"_13":143,"_35":144,"_37":145,"_24":27,"_146":47,"_28":147},"cc5b6b6a-6280-11f0-963f-0224a6c84d84","main.ts","parentId",118,"latest",["D",1752696577222],91,"http","import Confirm from \"https://esm.town/v/petermillspaugh/garden/jsx/confirm.tsx\";\nimport Signup from \"https://esm.town/v/petermillspaugh/garden/jsx/signup.tsx\";\nimport { email } from \"https://esm.town/v/std/email?v=11\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\nimport { Context, Hono } from \"npm:hono\";\n\nconst app = new Hono();\n\n// Signup form to test in val town preview\napp.get(\"/\", async (c: Context) => {\n return c.html(Signup().toString());\n});\n\n// Sends verification email upon signup\napp.post(\"/send-verification\", async (c: Context) => {\n const formData = await c.req.formData();\n const name = formData.get(\"name\");\n const emailAddress = formData.get(\"email\");\n\n if (typeof name !== \"string\" || typeof emailAddress !== \"string\") {\n return Response.json({ message: \"Missing name or email\" });\n }\n\n const token = crypto.randomUUID();\n await sqlite.execute({\n sql: `\n INSERT INTO subscribers (name, email, verification_token)\n VALUES (?, ?, ?)\n ON CONFLICT(email)\n DO UPDATE SET\n name = excluded.name,\n verification_token = excluded.verification_token,\n subscribed_at = CURRENT_TIMESTAMP;\n `,\n args: [name, emailAddress, token],\n });\n\n // email a confirmation link to the subscriber\n await email({\n to: emailAddress,\n from: {\n name: \"Pete Millspaugh\",\n email: \"petermillspaugh.garden@valtown.email\",\n },\n replyTo: \"pete@petemillspaugh.com\",\n subject: \"Confirm your subscription to petemillspaugh.com\",\n html: Confirm({ email: emailAddress, token }).toString(),\n });\n\n // No need to await: just emailing myself a notification\n email({\n subject: `${emailAddress} subscribed to petemillspaugh.com`,\n text: `A notification for ${emailAddress} verification should come in any minute now.`,\n });\n\n return Response.json({ success: true, message: \"Sent verification email.\" });\n});\n\n// Endpoint petemillspaugh.com/email-confirmation hits from email verification link\napp.put(\"/confirm-verification\", async (c: Context) => {\n const emailAddress = c.req.query(\"email\");\n const token = c.req.query(\"token\");\n\n // If the token is >24h old, refresh the token\n const newToken = crypto.randomUUID();\n const { rowsAffected } = await sqlite.execute({\n sql: `\n UPDATE subscribers\n SET \n verification_token = ?,\n subscribed_at = CURRENT_TIMESTAMP\n WHERE email = ?\n AND verification_token = ?\n AND subscribed_at < datetime('now', '-24 hours');\n `,\n args: [newToken, emailAddress, token],\n });\n\n // Send another confirmation email if the token was refreshed\n if (rowsAffected === 1) {\n await email({\n subject: \"Confirm your subscription to petemillspaugh.com\",\n to: emailAddress,\n from: {\n name: \"Pete Millspaugh\",\n email: \"petermillspaugh.garden@valtown.email\",\n },\n replyTo: \"pete@petemillspaugh.com\",\n html: (Confirm({ email: emailAddress, token: newToken }).toString()),\n });\n\n return Response.json({ message: \"Resent confirmation email.\" });\n }\n\n await sqlite.execute({\n sql: `UPDATE subscribers SET verified = 1 WHERE email = ?;`,\n args: [emailAddress],\n });\n\n // No need to await: just emailing myself a notification\n email({\n subject: `${emailAddress} verified for petemillspaugh.com subscription`,\n text: `Verification complete for ${emailAddress}'s subscription to petemillspaugh.com`,\n });\n\n return Response.json({ confirmed: true, message: \"Verified email address.\" });\n});\n\n// Endpoint to unsubscribe\napp.get(\"/unsubscribe\", async (c: Context) => {\n const emailAddress = c.req.query(\"email\");\n\n if (!emailAddress) {\n return c.html(`\n

Your email address is missing in the URL.

If you tried to unsubscribe and are still getting emails, send me a note at pete@petemillspaugh.com (no hard feelings).

\n `);\n }\n\n await sqlite.execute({\n sql: `\n UPDATE subscribers \n SET subscribed_at = NULL \n WHERE email = ?\n `,\n args: [emailAddress],\n });\n\n // No need to await, just notifying myself\n email({\n subject: `${emailAddress} unsubscribed from petemillspaugh.com`,\n text: `It's ok 😢`,\n });\n\n return c.html(`\n

You've successfully unsubscribed. No hard feelings.

Take care, Pete

\n `);\n});\n\nexport default app.fetch;","label",[138],"7825e684-627f-11f0-9fec-0224a6c84d84","README.md","79908d6e-2772-11f0-b46e-569c3dd06744",113,["D",1752696006448],8,"# Email subscriptions\n\nHandles email subscription signup, verification, and sending.\n\n## Steps\n\n1. Run [`init.ts`](./sqlite/init.ts) to create SQLite tables for subscribers, newsletters, and logs (to record sent newsletters)\n2. Update [`main.ts`](./main.ts) for your use case (e.g. confirmation link, `email` args, form fields, etc.)\n3. Add an HTML form to your frontend that calls `/send-verification`, or just use `/` to return a simple HTML form\n4. Add a confirmation page to your frontend that calls `/confirm-verification`\n5. When you're ready to send email, create a template and individual newsletters\n\n## Frontend form\n\nYou should have a form that hits the `/send-verification` API endpoint on submit. **Remember to adjust the endpoint URL to that of your fork**, otherwise you'll be signing people up for my garden! As a simple alternative, you could use the `/` handler of this Val, which returns a simple HTML form. Here's a simple example using React:\n\n```tsx\nconst EmailSignupForm = () => {\n const [name, setName] = useState(\"\");\n const [email, setEmail] = useState(\"\");\n\n async function handleSubmit(e) {\n e.preventDefault();\n setName(\"\");\n setEmail(\"\");\n\n const formData = new FormData();\n formData.append(\"name\", name);\n formData.append(\"email\", email);\n\n await fetch(\"https://garden.val.run/send-verification\", {\n method: \"POST\",\n body: formData,\n });\n }\n\n return (\n

\n First name\n setName(e.target.value)}\n type=\"text\"\n required={true}\n />\n Email\n setEmail(e.target.value)}\n type=\"email\"\n required={true}\n />\n \n \n );\n};\n```\n\nYou can see a full example on petemillspaugh.com: [signup in the footer](https://www.petemillspaugh.com/) and [code on github](https://github.com/pmillspaugh/petemillspaugh.com/blob/main/src/components/EmailSignup/EmailSignup.tsx).\n\nYou can add/remove input fields as you wish, of course (e.g. maybe you don't need a name, or maybe you want a how'd-you-hear-about-us field). Just adjust the SQL and frontend implementation accordingly.\n\n## Frontend confirmation page\n\nCreate a confirmation page that accepts an email and token as query params and calls the `/confirm-verification` endpoint. Simple example using React (and Next.js /page directory):\n\n```tsx\nconst EmailConfirmationPage = () => {\n const router = useRouter();\n const { email, token } = router.query;\n const [isConfirmed, setIsConfirmed] = useState(false);\n\n useEffect(() => {\n async function confirmEmail() {\n if (!email || !token) return;\n\n const response = await fetch(`https://garden.val.run/confirm-verification?email=${email}&token=${token}`, {\n method: \"PUT\",\n });\n const { confirmed } = await response.json();\n if (confirmed) setIsConfirmed(true);\n }\n\n confirmEmail();\n }, [email, token]);\n\n if (!isConfirmed) return null;\n\n return (\n

You’re all set!

\n );\n};\n```\n\nFull example is [here](https://www.petemillspaugh.com/email-confirmation) and code is [here](https://github.com/pmillspaugh/petemillspaugh.com/blob/main/src/components/EmailConfirmation/EmailConfirmation.tsx).\n\nAs an alternative, you could make `/confirm-verification` a GET route and have your email confirmation link sent by the first route be `https://garden.val.run/confirm-verification?email=${email}&token=${token}` (swapping in your namespace). That would be marginally faster, probably, but you'd still need some way to convey confirmation to the user (e.g. add some \"You're all set\" message to the return). Plus, the route writes to the `subscribers` table, so a PUT feels more appropriate.\n\n## Notes\n\nSending emails to people other than yourself on Val Town is a paid feature—if you want to stay on the free plan, you could go with a package like [nodemailer](https://www.npmjs.com/package/nodemailer) or [@sendgrid/mail](https://www.npmjs.com/package/@sendgrid/mail), or an API like [Resend](https://resend.com).",[149],"c6739bfe-627c-11f0-bda3-0224a6c84d84","sqlite","c4693db4-627c-11f0-a86c-0224a6c84d84",100,["D",1752694849332],"directory",[157],"7dac099c-6277-11f0-9fc4-0224a6c84d84","jsx","7b9a23e6-6277-11f0-b3a7-0224a6c84d84",81,["D",1752692579741],[164],"pulls",0,"branches","forks","envVars",{"_177":65,"_179":170},"connections",{"_177":170,"_178":170},"count","unfilledCount","emptyCount",{"_45":163,"_33":164,"_31":165,"_139":-5,"_43":44,"_42":166,"_141":25,"_40":229,"_13":65,"_35":161,"_37":-5,"_24":27,"_146":-5,"_189":230,"_28":231},{"_45":221,"_33":222,"_31":223,"_139":165,"_43":44,"_42":224,"_141":27,"_40":225,"_13":205,"_35":36,"_37":226,"_24":27,"_146":-5,"_189":227,"_28":228},{"_45":212,"_33":213,"_31":214,"_139":165,"_43":44,"_42":215,"_141":27,"_40":216,"_13":217,"_35":36,"_37":218,"_24":27,"_146":-5,"_189":219,"_28":220},{"_45":156,"_33":157,"_31":158,"_139":-5,"_43":44,"_42":159,"_141":25,"_40":209,"_13":65,"_35":161,"_37":-5,"_24":27,"_146":-5,"_189":210,"_28":211},{"_45":200,"_33":201,"_31":202,"_139":158,"_43":44,"_42":203,"_141":27,"_40":204,"_13":205,"_35":36,"_37":206,"_24":27,"_146":-5,"_189":207,"_28":208},{"_45":195,"_33":34,"_31":32,"_139":158,"_43":44,"_42":14,"_141":27,"_40":196,"_13":197,"_35":36,"_37":39,"_24":27,"_146":-5,"_189":198,"_28":199},{"_45":148,"_33":149,"_31":150,"_139":-5,"_43":44,"_42":151,"_141":27,"_40":192,"_13":153,"_35":20,"_37":154,"_24":27,"_146":-5,"_189":193,"_28":194},{"_45":137,"_33":138,"_31":60,"_139":-5,"_43":44,"_42":140,"_141":27,"_40":188,"_13":143,"_35":144,"_37":145,"_24":27,"_146":47,"_189":190,"_28":191},["D",1752696577222],"children",[],[138],["D",1752696006448],[],[149],"be522062-6281-11f0-b479-0224a6c84d84",["D",1752696983172],5,[],[157,34],"77520b36-627d-11f0-b9d1-0224a6c84d84","init.ts","e36b61e2-627c-11f0-9cf2-0224a6c84d84",106,["D",1752695146067],4,"import { sqlite } from \"https://esm.town/v/std/sqlite?v=4\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS subscribers (\n id INTEGER PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n verified BOOLEAN DEFAULT 0,\n verification_token TEXT UNIQUE,\n subscribed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n );\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS newsletters (\n id INTEGER PRIMARY KEY,\n subject TEXT NOT NULL UNIQUE,\n web_url TEXT NOT NULL UNIQUE,\n target_send_date TIMESTAMP NOT NULL UNIQUE\n );\n`);\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS email_logs (\n id INTEGER PRIMARY KEY,\n subscriber_id INTEGER NOT NULL,\n newsletter_id INTEGER NOT NULL,\n sent_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (subscriber_id) REFERENCES subscribers (id) ON DELETE CASCADE,\n FOREIGN KEY (newsletter_id) REFERENCES newsletters (id) ON DELETE CASCADE\n );\n`);",[],[157,201],["D",1752694849332],[184,185],[157],"70f5e4ea-627a-11f0-a989-0224a6c84d84","signup.tsx","7ff41442-6277-11f0-9fc4-0224a6c84d84",93,["D",1752693846906],3,"/** @jsxImportSource npm:hono@3/jsx */\n\nexport default function Signup() {\n return (\n \n \n

Sign up for clippings from Pete's garden (petemillspaugh.com)

\n \n \n \n );\n}",[],[164,213],"375d50d4-6279-11f0-b40a-0224a6c84d84","confirm.tsx","c5223480-6278-11f0-b684-0224a6c84d84",89,["D",1752693320782],"/** @jsxImportSource npm:hono@3/jsx */\n\ninterface ConfirmProps {\n email: string;\n token: string;\n}\n\nexport default function Confirm({ email, token }: ConfirmProps) {\n const confirmationLink = `https://petemillspaugh.com/email-confirmation?email=${email}&token=${token}`;\n\n return (\n

\n Click here to confirm your subscription. And if you have a minute, reply to this\n email to introduce yourself and lmk why you signed up!\n

\n );\n}",[],[164,222],["D",1752692579741],[181,182],[164],["D",1746203306756],["D",1789504321592],{"_102":101,"_110":106},{"_102":101,"_103":104,"_105":106,"_18":58,"_107":108,"_109":27},{"_13":91,"_33":92,"_45":44,"_93":46,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":47,"_100":101},"ctx",{"_84":-5,"_130":270,"_271":272,"_273":274,"_275":27,"_276":27,"_277":27,"_278":25,"_279":-5,"_280":-7,"_281":-7,"_282":170,"_283":27,"_284":27,"_285":-5,"_286":27,"_287":27,"_288":27,"_289":-5},"ENV",{"_241":242,"_243":244,"_245":92,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v124