[{"_1":2,"_372":-5,"_373":-5},"loaderData",{"_3":4,"_93":94,"_244":245,"_371":-5},"root",{"_5":6,"_34":35,"_62":63},"ctx",{"_7":8,"_19":20,"_21":-5,"_22":23,"_24":25,"_26":27,"_28":27,"_29":27,"_30":31,"_32":33},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","3a19914115c7f391307c61a673b46d06fa5b5a58","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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/","API_URL","https://api.val.town","WORKER_FINGERPRINT","fd7e47ba602df66e0f857b45e802b861","clerkState",{"_64":65},"__internal_clerk_state",{"_66":67,"_68":45,"_69":70,"_71":70,"_72":27,"_73":70,"_74":70,"_75":70,"_76":70,"_77":70,"_78":70,"_79":70,"_80":70,"_81":82,"_91":27,"_92":27},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_83":27,"_84":70,"_85":86,"_87":70,"_88":45,"_89":27,"_90":70},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_95":96,"_97":98,"_99":43,"_100":70,"_101":-7,"_102":103,"_144":145,"_213":214,"_215":216,"_221":222,"_157":-5,"_241":-5,"_242":27,"_243":27},"handle","neverstew","name","emailHole","branchName","path","version","project",{"_104":105,"_97":98,"_106":107,"_108":-5,"_109":110,"_111":112,"_113":-5,"_114":-5,"_12":115,"_116":117,"_118":110,"_119":120,"_121":122,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":27,"_21":132,"_135":136},"id","29ed15ca-20c4-11f0-bd7c-569c3dd06744","createdAt",["D",1745468733754],"deletedAt","legacyEnvVars",true,"privacy","unlisted","description","imageUrl","8acb974a-4b91-4d4a-b000-6f28827b7e16","pinnedFileId","29f19ffa-20c4-11f0-bd7c-569c3dd06744","pinPreview","screenshotVersion",12,"likeCount",1,"userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","isOwned",{"_95":96,"_133":134},"profileImageUrl","https://secure.gravatar.com/avatar/109fa713caf4e083c57622b7c6dad365.jpg?s=200&d=identicon","branch",{"_101":137,"_97":43,"_104":138,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5},17,"29edde7e-20c4-11f0-bd7c-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectUserId","tree",[146,165,175,185,193,203],{"_104":147,"_97":148,"_149":150,"_151":-5,"_152":138,"_153":122,"_154":110,"_106":155,"_101":33,"_156":157,"_158":159,"_160":27,"_161":-5,"_162":163,"_100":164},"29f1d920-20c4-11f0-bd7c-569c3dd06744","README.md","fileId","29f1d9a2-20c4-11f0-bd7c-569c3dd06744","parentId","branchId","branchVersion","latest",["D",1714013588029],"fileType","file","content","# ️📨🕳️\n\nIt's the last fifteen minutes of fame for your emails (unless a new email arrives...)\n\nSend your landing page signups, WiFi sign-ins and other junk here to never be troubled again.\n\nGot a sensitive one? No problem, just send yourself another email!\n\n## Playground \n[Email me!](mailto:neverstew.peachGoat@valtown.email)\n\n## Get Your Own\n### Related\n[database migrations](https://www.val.town/v/neverstew/emailMigrations)\n\n[email handler](https://www.val.town/v/neverstew/peachGoat)\n\n[cleanup](https://www.val.town/v/neverstew/emailHoleCleanup)\n### Steps\nFork this and the two vals above. Then, run the database migrations in order. \n\nTroublemakers could just use this one...\n\nMigrated from folder: emailHole/emailHole","deleted","label","children",[],[148],{"_104":166,"_97":167,"_149":168,"_151":-5,"_152":138,"_153":169,"_154":110,"_106":170,"_101":33,"_156":171,"_158":172,"_160":27,"_161":-5,"_162":173,"_100":174},"8b000084-20c4-11f0-a0b5-569c3dd06744","blackSilkworm","8b000138-20c4-11f0-a0b5-569c3dd06744",13,["D",1745468896612],"script","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\nconsole.log(await Statement`select * from emails`.execute());",[],[167],{"_104":176,"_97":177,"_149":178,"_151":-5,"_152":138,"_153":179,"_154":110,"_106":180,"_101":33,"_156":181,"_158":182,"_160":27,"_161":-5,"_162":183,"_100":184},"8b060042-20c4-11f0-a01c-569c3dd06744","emailHoleCleanup","8b06011e-20c4-11f0-a01c-569c3dd06744",14,["D",1745468896654],"interval","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\nimport { startOfDay } from \"https://esm.sh/date-fns/startOfDay.mjs\";\n\nexport default async function (interval: Interval) {\n const endPoint = startOfDay(new Date());\n await Statement`delete from emails where timestamp < ${endPoint.getTime()}`.execute();\n}",[],[177],{"_104":186,"_97":187,"_149":188,"_151":-5,"_152":138,"_153":137,"_154":110,"_106":189,"_101":122,"_156":171,"_158":190,"_160":27,"_161":-5,"_162":191,"_100":192},"6b6364f2-20fe-11f0-8181-569c3dd06744","emailMigrations","689c9e46-20fe-11f0-9fd8-569c3dd06744",["D",1745493754383],"import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nawait Statement`alter table emails add column timestamp int`.execute();",[],[187],{"_104":194,"_97":195,"_149":117,"_151":-5,"_152":138,"_153":120,"_154":110,"_106":196,"_101":197,"_156":198,"_158":199,"_160":27,"_161":200,"_162":201,"_100":202},"2a32bd50-20c4-11f0-bd7c-569c3dd06744","main.tsx",["D",1714129929254],11,"http","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nconst DEFAULT = `\n\n\n\n\n\n\nNO EMAILS IN LAST 15 MINUTES
\nEmail me!\n\n\n`;\nexport default async function(req: Request): Promise {\n const now = new Date().getTime();\n const fifteenMins = 15 * 60 * 1000;\n const [latestEmail] = await Statement`select * from emails where timestamp > ${\n now - fifteenMins\n } order by timestamp desc limit 1`.execute();\n return new Response(latestEmail?.content || DEFAULT, { headers: { \"Content-Type\": \"text/html\" } });\n}","emailhole",[],[195],{"_104":204,"_97":205,"_149":206,"_151":-5,"_152":138,"_153":207,"_154":110,"_106":208,"_101":33,"_156":209,"_158":210,"_160":27,"_161":-5,"_162":211,"_100":212},"8b0ca820-20c4-11f0-9ec7-569c3dd06744","peachGoat","8b0ca8de-20c4-11f0-9ec7-569c3dd06744",15,["D",1745468896695],"email","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nexport default async function(e: Email) {\n await Statement`insert into emails (content, timestamp) values (${e.html || e.text}, ${new Date().getTime()})`.execute();\n}",[],[205],"files",[146,165,175,185,193,203],"counts",{"_217":33,"_218":122,"_219":33,"_220":33},"pulls","branches","forks","envVars","contents",[223,226,229,232,235,238],{"_104":147,"_97":148,"_149":150,"_151":-5,"_152":138,"_153":122,"_154":110,"_106":224,"_101":33,"_156":157,"_158":159,"_160":27,"_161":-5,"_100":225},["D",1714013588029],[148],{"_104":166,"_97":167,"_149":168,"_151":-5,"_152":138,"_153":169,"_154":110,"_106":227,"_101":33,"_156":171,"_158":172,"_160":27,"_161":-5,"_100":228},["D",1745468896612],[167],{"_104":176,"_97":177,"_149":178,"_151":-5,"_152":138,"_153":179,"_154":110,"_106":230,"_101":33,"_156":181,"_158":182,"_160":27,"_161":-5,"_100":231},["D",1745468896654],[177],{"_104":186,"_97":187,"_149":188,"_151":-5,"_152":138,"_153":137,"_154":110,"_106":233,"_101":122,"_156":171,"_158":190,"_160":27,"_161":-5,"_100":234},["D",1745493754383],[187],{"_104":194,"_97":195,"_149":117,"_151":-5,"_152":138,"_153":120,"_154":110,"_106":236,"_101":197,"_156":198,"_158":199,"_160":27,"_161":200,"_100":237},["D",1714129929254],[195],{"_104":204,"_97":205,"_149":206,"_151":-5,"_152":138,"_153":207,"_154":110,"_106":239,"_101":33,"_156":209,"_158":210,"_160":27,"_161":-5,"_100":240},["D",1745468896695],[205],"upstream","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.history",{"_95":96,"_97":98,"_99":43,"_102":246,"_250":251,"_369":33,"_370":27},{"_104":105,"_97":98,"_106":247,"_108":-5,"_109":110,"_111":112,"_113":-5,"_114":-5,"_12":115,"_116":117,"_118":110,"_119":120,"_121":122,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":27,"_21":248,"_135":249},["D",1745468733754],{"_95":96,"_133":134},{"_101":137,"_97":43,"_104":138,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5},"history",[252,257,264,269,274,279,284,292,300,308,316,323,330,338,346,353,359],{"_149":188,"_101":137,"_106":253,"_152":138,"_213":254},["D",1745493754383],[255],{"_104":186,"_152":138,"_149":188,"_97":187,"_158":190,"_156":171,"_101":122,"_151":-5,"_106":253,"_153":137,"_161":-5,"_154":110,"_160":27,"_100":256},[187],{"_149":188,"_101":258,"_106":259,"_152":138,"_213":260},16,["D",1745493749727],[261],{"_104":262,"_152":138,"_149":188,"_97":187,"_158":70,"_156":171,"_101":33,"_151":-5,"_106":259,"_153":258,"_161":-5,"_154":27,"_160":27,"_100":263},"689c9d4c-20fe-11f0-9fd8-569c3dd06744",[187],{"_149":206,"_101":207,"_106":265,"_152":138,"_213":266},["D",1745468896695],[267],{"_104":204,"_152":138,"_149":206,"_97":205,"_158":210,"_156":209,"_101":33,"_151":-5,"_106":265,"_153":207,"_161":-5,"_154":110,"_160":27,"_100":268},[205],{"_149":178,"_101":179,"_106":270,"_152":138,"_213":271},["D",1745468896654],[272],{"_104":176,"_152":138,"_149":178,"_97":177,"_158":182,"_156":181,"_101":33,"_151":-5,"_106":270,"_153":179,"_161":-5,"_154":110,"_160":27,"_100":273},[177],{"_149":168,"_101":169,"_106":275,"_152":138,"_213":276},["D",1745468896612],[277],{"_104":166,"_152":138,"_149":168,"_97":167,"_158":172,"_156":171,"_101":33,"_151":-5,"_106":275,"_153":169,"_161":-5,"_154":110,"_160":27,"_100":278},[167],{"_149":117,"_101":120,"_106":280,"_152":138,"_213":281},["D",1714129929254],[282],{"_104":194,"_152":138,"_149":117,"_97":195,"_158":199,"_156":198,"_101":197,"_151":-5,"_106":280,"_153":120,"_161":200,"_154":110,"_160":27,"_100":283},[195],{"_149":117,"_101":197,"_106":285,"_152":138,"_213":286},["D",1714129879720],[287],{"_104":288,"_152":138,"_149":117,"_97":195,"_158":289,"_156":198,"_101":290,"_151":-5,"_106":285,"_153":197,"_161":200,"_154":27,"_160":27,"_100":291},"2a2d271e-20c4-11f0-bd7c-569c3dd06744","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nconst DEFAULT = `\n\n\n\n\n\n\nNO EMAILS IN LAST 15 MINUTES
Email me!\n\n\n`;\nexport default async function(req: Request): Promise {\n const now = new Date().getTime();\n const fifteenMins = 15 * 60 * 1000;\n const [latestEmail] = await Statement`select * from emails where timestamp > ${\n now - fifteenMins\n } order by timestamp desc limit 1`.execute();\n return new Response(latestEmail?.content || DEFAULT, { headers: { \"Content-Type\": \"text/html\" } });\n}",10,[195],{"_149":117,"_101":290,"_106":293,"_152":138,"_213":294},["D",1714129744358],[295],{"_104":296,"_152":138,"_149":117,"_97":195,"_158":297,"_156":198,"_101":298,"_151":-5,"_106":293,"_153":290,"_161":200,"_154":27,"_160":27,"_100":299},"2a2708f2-20c4-11f0-bd7c-569c3dd06744","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nconst DEFAULT = \"NO EMAILS IN LAST 15 MINUTES
Email me!\";\nexport default async function(req: Request): Promise {\n const now = new Date().getTime();\n const fifteenMins = 15 * 60 * 1000;\n const [latestEmail] = await Statement`select * from emails where timestamp > ${\n now - fifteenMins\n } order by timestamp desc limit 1`.execute();\n return new Response(latestEmail?.content || DEFAULT, { headers: { \"Content-Type\": \"text/html\" } });\n}",9,[195],{"_149":117,"_101":298,"_106":301,"_152":138,"_213":302},["D",1714128539535],[303],{"_104":304,"_152":138,"_149":117,"_97":195,"_158":305,"_156":198,"_101":306,"_151":-5,"_106":301,"_153":298,"_161":200,"_154":27,"_160":27,"_100":307},"2a2235d4-20c4-11f0-bd7c-569c3dd06744","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nconst DEFAULT = \"NO EMAILS IN LAST 15 MINUTES\";\nexport default async function(req: Request): Promise {\n const now = new Date().getTime();\n const fifteenMins = 15 * 60 * 1000;\n const [latestEmail] = await Statement`select * from emails where timestamp > ${\n now - fifteenMins\n } order by timestamp desc limit 1`.execute();\n return new Response(latestEmail?.content || DEFAULT, { headers: { \"Content-Type\": \"text/html\" } });\n}",8,[195],{"_149":117,"_101":306,"_106":309,"_152":138,"_213":310},["D",1714128487431],[311],{"_104":312,"_152":138,"_149":117,"_97":195,"_158":313,"_156":198,"_101":314,"_151":-5,"_106":309,"_153":306,"_161":200,"_154":27,"_160":27,"_100":315},"2a1bd2ca-20c4-11f0-bd7c-569c3dd06744","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nconst DEFAULT = \"NO EMAILS IN LAST 15 MINUTES\";\nexport default async function(req: Request): Promise {\n const now = new Date().getTime();\n const fifteenMins = 15 * 60 * 1000;\n const [latestEmail] = await Statement`select * from emails where timestamp > ${\n now - fifteenMins\n } order by rowid desc limit 1`.execute();\n return new Response(latestEmail?.content || DEFAULT, { headers: { \"Content-Type\": \"text/html\" } });\n}",7,[195],{"_149":117,"_101":314,"_106":317,"_152":138,"_213":318},["D",1714128483026],[319],{"_104":320,"_152":138,"_149":117,"_97":195,"_158":313,"_156":198,"_101":321,"_151":-5,"_106":317,"_153":314,"_161":200,"_154":27,"_160":27,"_100":322},"2a15c6f0-20c4-11f0-bd7c-569c3dd06744",6,[195],{"_149":117,"_101":321,"_106":324,"_152":138,"_213":325},["D",1714128447824],[326],{"_104":327,"_152":138,"_149":117,"_97":195,"_158":313,"_156":198,"_101":328,"_151":-5,"_106":324,"_153":321,"_161":200,"_154":27,"_160":27,"_100":329},"2a107dee-20c4-11f0-bd7c-569c3dd06744",5,[195],{"_149":117,"_101":328,"_106":331,"_152":138,"_213":332},["D",1714013802684],[333],{"_104":334,"_152":138,"_149":117,"_97":195,"_158":335,"_156":198,"_101":336,"_151":-5,"_106":331,"_153":328,"_161":200,"_154":27,"_160":27,"_100":337},"2a0a9ca8-20c4-11f0-bd7c-569c3dd06744","import { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nexport default async function(req: Request): Promise {\n const [latestEmail] = await Statement`select * from emails order by rowid desc limit 1`.execute();\n return new Response(latestEmail?.content, { headers: { \"Content-Type\": \"text/html\" } });\n}",4,[195],{"_149":117,"_101":336,"_106":339,"_152":138,"_213":340},["D",1714013707499],[341],{"_104":342,"_152":138,"_149":117,"_97":195,"_158":343,"_156":198,"_101":344,"_151":-5,"_106":339,"_153":336,"_161":200,"_154":27,"_160":27,"_100":345},"2a053b32-20c4-11f0-bd7c-569c3dd06744","import { htmlResponse } from \"https://esm.town/v/neverstew/htmlResponse\";\nimport { Statement } from \"https://esm.town/v/postpostscript/sqliteBuilder?v=36\";\n\nexport default async function(req: Request): Promise {\n const [latestEmail] = await Statement`select * from emails order by rowid desc limit 1`.execute();\n return htmlResponse(latestEmail?.content);\n}",3,[195],{"_149":117,"_101":344,"_106":347,"_152":138,"_213":348},["D",1714013703023],[349],{"_104":350,"_152":138,"_149":117,"_97":195,"_158":343,"_156":198,"_101":351,"_151":-5,"_106":347,"_153":344,"_161":200,"_154":27,"_160":27,"_100":352},"29ff2ac6-20c4-11f0-bd7c-569c3dd06744",2,[195],{"_149":117,"_101":351,"_106":354,"_152":138,"_213":355},["D",1714013672315],[356],{"_104":357,"_152":138,"_149":117,"_97":195,"_158":343,"_156":198,"_101":122,"_151":-5,"_106":354,"_153":351,"_161":200,"_154":27,"_160":27,"_100":358},"29f83c02-20c4-11f0-bd7c-569c3dd06744",[195],{"_149":117,"_101":122,"_106":360,"_152":138,"_213":361},["D",1714013588029],[362,366],{"_104":363,"_152":138,"_149":117,"_97":195,"_158":364,"_156":198,"_101":33,"_151":-5,"_106":360,"_153":122,"_161":200,"_154":27,"_160":27,"_100":365},"29f19f32-20c4-11f0-bd7c-569c3dd06744","export default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}",[195],{"_104":147,"_152":138,"_149":150,"_97":148,"_158":159,"_156":157,"_101":33,"_151":-5,"_106":367,"_153":122,"_161":-5,"_154":110,"_160":27,"_100":368},["D",1714013588029],[148],"page","hasNext","routes/_app","actionData","errors"]

History