\n dot com et al.\n

\n The secret life of Internet domains\n

\n Click to confirm your spot on the mailing list.{\" \"}\n You can unsubscribe whenever, no hard feelings.\n

If you have a minute, reply with any domain stories or topics you'd like the book to cover.

Thanks!

-Pete

\n \n \n );\n}",[],[213,221],{"_105":230,"_96":231,"_159":232,"_161":214,"_162":144,"_163":233,"_165":22,"_107":234,"_101":235,"_168":199,"_170":236,"_171":22,"_172":-5,"_173":237,"_99":238},"4e6a5ac6-6286-11f0-a4b4-0224a6c84d84","Signup.tsx","9229b57c-6245-11f0-b687-0224a6c84d84",99,["D",1752698942913],7,"/** @jsxImportSource npm:hono@3/jsx */\n\nexport default function Signup() {\n return (\n \n \n

dot com et al: The secret life of Internet domains

Read email before reading the book.

\n \n \n \n );\n}",[],[213,231],[213],{"_105":241,"_96":242,"_159":243,"_161":-5,"_162":144,"_163":188,"_165":121,"_107":244,"_101":167,"_168":169,"_170":-5,"_171":22,"_172":-5,"_173":245,"_99":266},"f273655c-623d-11f0-9082-0224a6c84d84","sqlite","ef121598-623d-11f0-846c-0224a6c84d84",["D",1752667864856],[246,256],{"_105":247,"_96":248,"_159":249,"_161":243,"_162":144,"_163":250,"_165":22,"_107":251,"_101":252,"_168":199,"_170":253,"_171":22,"_172":-5,"_173":254,"_99":255},"c309a1e4-623f-11f0-96f0-0224a6c84d84","init.ts","f4869e4a-623d-11f0-8c5d-0224a6c84d84",14,["D",1752668644304],6,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS dotcom_subs (\n id INTEGER PRIMARY KEY,\n email TEXT NOT NULL UNIQUE,\n verification_token TEXT UNIQUE,\n verified_at TIMESTAMP,\n subscribed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n );\n`);",[],[242,248],{"_105":257,"_96":258,"_159":259,"_161":243,"_162":144,"_163":260,"_165":22,"_107":261,"_101":262,"_168":199,"_170":263,"_171":22,"_172":-5,"_173":264,"_99":265},"fc077224-6725-11f0-8f21-0224a6c84d84","read.ts","f3a00826-623e-11f0-8eb8-0224a6c84d84",108,["D",1753207328809],8,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// await sqlite.execute({\n// sql: `UPDATE dotcom_subs SET verified_at = CURRENT_TIMESTAMP WHERE email IN (?);`,\n// args: [\"wesulloway@gmail.com\"],\n// });\n\nconsole.log(await sqlite.execute(`select * from dotcom_subs;`));",[],[242,258],[242],{"_105":268,"_96":269,"_159":270,"_161":-5,"_162":144,"_163":271,"_165":22,"_107":272,"_101":188,"_168":189,"_170":273,"_171":22,"_172":-5,"_173":274,"_99":275},"1b233d18-6277-11f0-8e20-0224a6c84d84","README.md","00b96fe2-6277-11f0-9b1d-0224a6c84d84",93,["D",1752692414426],"## dotcom\n\nPowers the email signup and verification on [dotcom.press](https://dotcom.press)",[],[269],{"_105":277,"_96":195,"_159":119,"_161":-5,"_162":144,"_163":278,"_165":22,"_107":279,"_101":280,"_168":281,"_170":282,"_171":22,"_172":97,"_173":283,"_99":284},"e3b7493e-663e-11f0-b047-0224a6c84d84",103,["D",1753108074282],52,"http","import { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { Context, Hono } from \"npm:hono@3\";\nimport Confirm from \"./jsx/Confirm.tsx\";\nimport Signup from \"./jsx/Signup.tsx\";\n\nconst app = new Hono();\n\n// Used to test signup on val town preview\napp.get(\"/\", async (c: Context) => {\n return c.html(Signup().toString());\n});\n\n// Endpoint hit by signup form on dotcom.press\napp.post(\"/signup\", async (c: Context) => {\n const formData = await c.req.formData();\n const emailAddress = formData.get(\"email\");\n if (typeof emailAddress !== \"string\") {\n return Response.json({ message: \"email is a required field\" }, { status: 400 });\n }\n\n const token = crypto.randomUUID();\n\n // Insert subscriber\n // No await: faster optimistic response on frontend\n sqlite.execute({\n sql: `\n INSERT INTO dotcom_subs (email, verification_token)\n VALUES (?, ?)\n ON CONFLICT(email)\n DO UPDATE SET\n verification_token = excluded.verification_token,\n subscribed_at = CURRENT_TIMESTAMP;\n `,\n args: [emailAddress, token],\n });\n\n // Email subscriber verification link\n // No await: faster optimistic response on frontend\n email({\n subject: \"Confirm your email for dot com et al.\",\n to: emailAddress,\n from: { email: \"petermillspaugh.dotcom@valtown.email\", name: \"Dot Com Press\" },\n replyTo: \"hello@dotcom.press\",\n html: (Confirm({ email: emailAddress, token }).toString()),\n });\n\n // Email myself a notification\n email({\n subject: `${emailAddress} subscribed to dot com et al.`,\n text: `${emailAddress} should verify any minute now...`,\n });\n\n return Response.json({ ok: true });\n});\n\n// Endpoint hit by verify page on dotcom.press\napp.post(\"/verify\", 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 dotcom_subs\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 email for dot com et al.\",\n to: emailAddress,\n from: { email: \"petermillspaugh.dotcom@valtown.email\", name: \"Dot Com Press\" },\n replyTo: \"pete@petemillspaugh.com\",\n html: (Confirm({ email: emailAddress, token: newToken }).toString()),\n });\n\n return Response.json({ refresh: true });\n }\n\n await sqlite.execute({\n sql: `UPDATE dotcom_subs SET verified_at = CURRENT_TIMESTAMP WHERE email = ?;`,\n args: [emailAddress],\n });\n\n // No need to await: just emailing myself a notification\n email({\n subject: `${emailAddress} verified for dot com et al.`,\n text: `${emailAddress} verified for the Dot Com Press mailing list :)`,\n });\n\n return Response.json({ ok: true });\n});\n\nexport default app.fetch;",[],[195],"files",[156,175,182,193,202,211,219,229,240,246,256,267,276],"counts",{"_289":32,"_290":167,"_291":167,"_292":293},"pulls","branches","forks","envVars",{"_294":217,"_295":32},"count","emptyCount","contents",[],{"_105":203,"_96":204,"_159":205,"_161":178,"_162":144,"_163":102,"_165":22,"_107":299,"_101":32,"_168":199,"_170":73,"_171":22,"_172":-5,"_99":300},["D",1753301680141],[158,177,204],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_94":95,"_96":97,"_98":44,"_101":102,"_99":100,"_103":309,"_154":314,"_285":354,"_189":355,"_296":357,"_358":-5,"_359":-5,"_360":-5,"_361":-5,"_362":363},{"_105":106,"_96":97,"_107":310,"_109":-5,"_110":22,"_111":112,"_113":114,"_115":116,"_14":117,"_118":119,"_120":121,"_122":121,"_123":-5,"_124":32,"_16":125,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":311,"_138":312,"_141":313,"_153":22},["D",1752667510190],{"_94":95,"_136":137},{"_94":95,"_140":137,"_14":117},{"_101":143,"_96":44,"_105":144,"_145":106,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":97,"_152":95},[315,330,339,348,351],{"_105":157,"_96":158,"_159":160,"_161":-5,"_162":144,"_163":164,"_165":22,"_107":166,"_101":167,"_168":169,"_170":-5,"_171":22,"_172":-5,"_173":316,"_99":329},[317],{"_105":176,"_96":177,"_159":178,"_161":160,"_162":144,"_163":179,"_165":22,"_107":180,"_101":167,"_168":169,"_170":-5,"_171":22,"_172":-5,"_173":318,"_99":328},[319,322,325],{"_105":183,"_96":184,"_159":185,"_161":178,"_162":144,"_163":186,"_165":22,"_107":187,"_101":188,"_168":189,"_170":190,"_171":22,"_172":-5,"_173":320,"_99":321},[],[158,177,184],{"_105":194,"_96":195,"_159":196,"_161":178,"_162":144,"_163":197,"_165":22,"_107":198,"_101":167,"_168":199,"_170":73,"_171":22,"_172":-5,"_173":323,"_99":324},[],[158,177,195],{"_105":203,"_96":204,"_159":205,"_161":178,"_162":144,"_163":102,"_165":22,"_107":206,"_101":32,"_168":199,"_170":73,"_171":22,"_172":-5,"_173":326,"_99":327},[],[158,177,204],[158,177],[158],{"_105":212,"_96":213,"_159":214,"_161":-5,"_162":144,"_163":215,"_165":121,"_107":216,"_101":217,"_168":169,"_170":-5,"_171":22,"_172":-5,"_173":331,"_99":338},[332,335],{"_105":220,"_96":221,"_159":222,"_161":214,"_162":144,"_163":223,"_165":121,"_107":224,"_101":225,"_168":199,"_170":226,"_171":22,"_172":-5,"_173":333,"_99":334},[],[213,221],{"_105":230,"_96":231,"_159":232,"_161":214,"_162":144,"_163":233,"_165":22,"_107":234,"_101":235,"_168":199,"_170":236,"_171":22,"_172":-5,"_173":336,"_99":337},[],[213,231],[213],{"_105":241,"_96":242,"_159":243,"_161":-5,"_162":144,"_163":188,"_165":121,"_107":244,"_101":167,"_168":169,"_170":-5,"_171":22,"_172":-5,"_173":340,"_99":347},[341,344],{"_105":247,"_96":248,"_159":249,"_161":243,"_162":144,"_163":250,"_165":22,"_107":251,"_101":252,"_168":199,"_170":253,"_171":22,"_172":-5,"_173":342,"_99":343},[],[242,248],{"_105":257,"_96":258,"_159":259,"_161":243,"_162":144,"_163":260,"_165":22,"_107":261,"_101":262,"_168":199,"_170":263,"_171":22,"_172":-5,"_173":345,"_99":346},[],[242,258],[242],{"_105":268,"_96":269,"_159":270,"_161":-5,"_162":144,"_163":271,"_165":22,"_107":272,"_101":188,"_168":189,"_170":273,"_171":22,"_172":-5,"_173":349,"_99":350},[],[269],{"_105":277,"_96":195,"_159":119,"_161":-5,"_162":144,"_163":278,"_165":22,"_107":279,"_101":280,"_168":281,"_170":282,"_171":22,"_172":97,"_173":352,"_99":353},[],[195],[315,317,319,322,325,330,332,335,339,341,344,348,351],{"_105":203,"_96":204,"_159":205,"_161":178,"_162":144,"_163":102,"_165":22,"_107":299,"_101":32,"_168":199,"_170":73,"_171":22,"_172":-5,"_99":356},[158,177,204],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]