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",[142,135],"643e416908fb792558e3fee8fee20463211a82b3ebe1ad2ce830bef35200e180","components","components/Layout.tsx",{"_32":145,"_13":146,"_78":147,"_80":137,"_81":33,"_82":41,"_83":26,"_34":148,"_40":22,"_86":128,"_88":149,"_65":48,"_90":-5,"_91":-7,"_71":150,"_93":151},"40e83c0d-3089-4920-8dc8-7de707bfa83b","Layout.tsx","019eb3e7-9e0e-75d5-89dd-bc3144787be0",["D",1781134761362],"/** @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",[142,146],"ca2a221c6e5ad35aa4c2856f9b352abd01253269ec2290659c81d61062ebca0f","components/FormPage.tsx",{"_32":154,"_13":155,"_78":156,"_80":137,"_81":33,"_82":41,"_83":26,"_34":157,"_40":22,"_86":128,"_88":158,"_65":48,"_90":-5,"_91":-7,"_71":159,"_93":160},"08b65428-ac5c-40c7-ab6e-e17652aa1862","FormPage.tsx","019eb3e7-9e0e-75d5-89dd-b84986c1d8ca",["D",1781134761362],"/** @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",[142,155],"ab9a2d842536393d2700e91840403100070684e4a9facec495a83c1e5b1c4acc",{"_32":162,"_13":142,"_78":137,"_80":-5,"_81":33,"_82":41,"_83":26,"_34":163,"_40":22,"_86":164,"_88":-5,"_65":48,"_90":-5,"_91":-7,"_71":165,"_93":-5},"5b60cf5d-97a3-4870-922f-40d7e46100ce",["D",1781134761362],"directory",[142],{"_71":187,"_73":-7,"_75":188},{"_71":178,"_73":-7,"_75":179},{"_71":169,"_73":-7,"_75":170},"storage.ts",{"_32":171,"_13":169,"_78":172,"_80":-5,"_81":58,"_82":173,"_83":26,"_34":174,"_40":22,"_86":128,"_88":175,"_65":48,"_90":-5,"_91":-7,"_71":176,"_93":177},"85298da7-4357-4319-b1ec-7b1bfc3a22a8","0f7aa4d8-a1b4-11f1-ab7e-1607ee4eb77e",6,["D",1787793015101],"import { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { MESSAGE_PREFIX, StoredMessage, messageKey } from \"./shared.ts\";\n\nconst RATE_LIMIT_KEY = \"secure-message-rate-limit\";\n\nexport async function storeMessage(message: StoredMessage): Promise {\n await blob.setJSON(messageKey(message.id), message);\n}\n\nexport async function getMessage(id: string): Promise {\n return await blob.getJSON(messageKey(id)) as StoredMessage | undefined;\n}\n\nexport async function listMessages(includeRead = false): Promise {\n const entries = await blob.list(MESSAGE_PREFIX);\n const messages = await Promise.all(entries.map(({ key }) => blob.getJSON(key) as Promise));\n\n return messages\n .filter((message): message is StoredMessage => Boolean(message))\n .filter((message) => includeRead || !message.readAt)\n .sort((a, b) => b.receivedAt.localeCompare(a.receivedAt));\n}\n\nexport async function markMessageRead(message: StoredMessage): Promise {\n const updated = { ...message, readAt: message.readAt ?? new Date().toISOString() };\n await storeMessage(updated);\n return updated;\n}\n\nexport async function deleteMessage(id: string): Promise {\n await blob.delete(messageKey(id));\n}\n\nexport async function deleteExpiredMessages(retentionDays: number): Promise {\n const cutoff = Date.now() - retentionDays * 24 * 60 * 60 * 1000;\n const entries = await blob.list(MESSAGE_PREFIX);\n let deleted = 0;\n\n for (const { key } of entries) {\n const message = await blob.getJSON(key) as StoredMessage | undefined;\n const receivedAt = message ? Date.parse(message.receivedAt) : Number.NaN;\n\n if (!message || !Number.isFinite(receivedAt) || receivedAt < cutoff) {\n await blob.delete(key);\n deleted += 1;\n }\n }\n\n return deleted;\n}\n\nexport async function reserveSubmissionSlot(limit: number, windowMilliseconds: number): Promise {\n const now = Date.now();\n const cutoff = now - windowMilliseconds;\n const stored = await blob.getJSON(RATE_LIMIT_KEY) as { timestamps?: unknown } | undefined;\n const timestamps = Array.isArray(stored?.timestamps)\n ? stored.timestamps.filter((value): value is number => typeof value === \"number\" && value >= cutoff && value <= now)\n : [];\n\n if (timestamps.length >= limit) return false;\n timestamps.push(now);\n await blob.setJSON(RATE_LIMIT_KEY, { timestamps });\n return true;\n}\n",[169],"9a6897f94bf36c6b092c2027a2dfd99ea63b7a6128f1191fc45b242df9457e59","shared.ts",{"_32":180,"_13":178,"_78":181,"_80":-5,"_81":58,"_82":182,"_83":26,"_34":183,"_40":22,"_86":128,"_88":184,"_65":48,"_90":-5,"_91":-7,"_71":185,"_93":186},"6a0fd014-fe2e-4c53-b068-c281d7d79033","09590892-a1b4-11f1-b03b-1607ee4eb77e",3,["D",1787793004813],"export const MESSAGE_PREFIX = \"secure-message:\";\nexport const MAX_REQUEST_BYTES = 24_000;\nexport const MAX_CIPHERTEXT_LENGTH = 20_000;\nexport const MAX_NAME_LENGTH = 80;\n\nexport interface StoredMessage {\n version: 1;\n id: string;\n name: string;\n ciphertext: string;\n receivedAt: string;\n readAt: string | null;\n origin: string;\n recipientKeyId: string;\n}\n\nexport function normalizeName(value: unknown): string {\n if (typeof value !== \"string\") return \"\";\n\n return value\n .replace(/[\\u0000-\\u001F\\u007F]/g, \" \")\n .replace(/\\s+/g, \" \")\n .trim()\n .slice(0, MAX_NAME_LENGTH);\n}\n\nexport function parsePositiveInteger(value: string | undefined, fallback: number): number {\n const parsed = Number.parseInt(value ?? \"\", 10);\n return Number.isInteger(parsed) && parsed > 0 ? parsed : fallback;\n}\n\nexport function messageKey(id: string): string {\n return `${MESSAGE_PREFIX}${id}`;\n}\n\nexport function isMessageId(value: string): boolean {\n return /^[0-9a-f]{8}-[0-9a-f]{4}-4[0-9a-f]{3}-[89ab][0-9a-f]{3}-[0-9a-f]{12}$/i.test(value);\n}\n",[178],"93689b3cb83681935ddb9e9faa2e71d4305205bdc4a31a291a644784deaaa37e","cleanup.ts",{"_32":189,"_13":187,"_78":190,"_80":-5,"_81":58,"_82":85,"_83":26,"_34":191,"_40":22,"_86":192,"_88":193,"_65":48,"_90":-5,"_91":-7,"_71":194,"_93":195},"8ac2e069-65a8-451f-9e6e-d4bb81309fe8","0b6dcb72-a1b4-11f1-b022-1607ee4eb77e",["D",1787793008306],"interval","import { deleteExpiredMessages } from \"./storage.ts\";\nimport { parsePositiveInteger } from \"./shared.ts\";\n\ninterface IntervalEvent {\n lastRunAt?: Date;\n}\n\nexport default async function (_interval: IntervalEvent) {\n const retentionDays = parsePositiveInteger(Deno.env.get(\"RETENTION_DAYS\"), 30);\n const deleted = await deleteExpiredMessages(retentionDays);\n console.log(`Secure-message cleanup removed ${deleted} expired record(s).`);\n}\n",[187],"091a40b324bcd63f3bf659d2ac7b2cb0951a3cc8f9de94bc423e94b511bec88a",["D",1787792915355],"legacyEnvVars","httpPrivacy","description","Ciphertext relay and private local-reader inbox","imageUrl","userId","4cdce967-3214-4f01-a3ad-621feefd7c79","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","dc5a7ebe-7841-4930-908a-6990859a8fe8","tursoName","364210a3ad88442ea2ab4cc980bfeca2","tursoHostname","364210a3ad88442ea2ab4cc980bfeca2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789446061244],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_237":233},"org",{"_11":12,"_231":-5,"_232":233,"_202":203,"_234":235,"_236":48},"branch","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybWltR3dZU01TR1VmellwVExiaHNINUtnZlIifQ","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_32":59,"_13":14,"_34":307,"_46":-5,"_197":48,"_49":50,"_198":50,"_199":200,"_201":-5,"_202":203,"_204":79,"_205":26,"_206":-5,"_207":-5,"_208":22,"_53":209,"_210":211,"_212":213,"_214":308,"_216":-5,"_217":218,"_219":218,"_220":221,"_222":221,"_223":221,"_224":218,"_225":218,"_226":309,"_228":310,"_230":311,"_47":48},"tree",[292,293,294,295,296],"files",[292,293,294,295,296],"counts",{"_281":22,"_282":41,"_283":22,"_284":285,"_286":287},"contents",[266,267,268,269,270],"upstreamProject",{"_32":39,"_13":56,"_199":263,"_201":-5,"_49":50,"_226":264},"upstreamBranch",{"_32":33,"_34":261,"_36":262,"_13":16,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781134761362],["D",1781134761362],"Put a form online and save submissions to SQLite",{"_11":52,"_237":265},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789538399&sig=ed57122c136965e1015088c1b79a18d1d4e6250d1eb81abacde1e740f48894e7",{"_32":104,"_13":101,"_78":105,"_80":-5,"_81":58,"_82":57,"_83":26,"_34":279,"_40":107,"_86":108,"_88":109,"_65":48,"_90":-5,"_71":280},{"_32":189,"_13":187,"_78":190,"_80":-5,"_81":58,"_82":85,"_83":26,"_34":277,"_40":22,"_86":192,"_88":193,"_65":48,"_90":-5,"_71":278},{"_32":77,"_13":72,"_78":79,"_80":-5,"_81":58,"_82":20,"_83":26,"_34":275,"_40":85,"_86":87,"_88":89,"_65":48,"_90":-5,"_71":276},{"_32":180,"_13":178,"_78":181,"_80":-5,"_81":58,"_82":182,"_83":26,"_34":273,"_40":22,"_86":128,"_88":184,"_65":48,"_90":-5,"_71":274},{"_32":171,"_13":169,"_78":172,"_80":-5,"_81":58,"_82":173,"_83":26,"_34":271,"_40":22,"_86":128,"_88":175,"_65":48,"_90":-5,"_71":272},["D",1787793015101],[169],["D",1787793004813],[178],["D",1788036333996],[72],["D",1787793008306],[187],["D",1788036384158],[101],"pulls","branches","forks","envVars",{"_288":290,"_291":22},"connections",{"_288":22,"_289":22},"count","unfilledCount",7,"emptyCount",{"_32":104,"_13":101,"_78":105,"_80":-5,"_81":58,"_82":57,"_83":26,"_34":106,"_40":107,"_86":108,"_88":109,"_65":48,"_90":-5,"_91":305,"_71":306},{"_32":189,"_13":187,"_78":190,"_80":-5,"_81":58,"_82":85,"_83":26,"_34":191,"_40":22,"_86":192,"_88":193,"_65":48,"_90":-5,"_91":303,"_71":304},{"_32":77,"_13":72,"_78":79,"_80":-5,"_81":58,"_82":20,"_83":26,"_34":84,"_40":85,"_86":87,"_88":89,"_65":48,"_90":-5,"_91":301,"_71":302},{"_32":180,"_13":178,"_78":181,"_80":-5,"_81":58,"_82":182,"_83":26,"_34":183,"_40":22,"_86":128,"_88":184,"_65":48,"_90":-5,"_91":299,"_71":300},{"_32":171,"_13":169,"_78":172,"_80":-5,"_81":58,"_82":173,"_83":26,"_34":174,"_40":22,"_86":128,"_88":175,"_65":48,"_90":-5,"_91":297,"_71":298},[],[169],[],[178],[],[72],[],[187],[],[101],["D",1787792915355],["D",1789446061244],{"_11":12,"_237":233},{"_11":12,"_231":-5,"_232":233,"_202":203,"_234":235,"_236":48},{"_40":57,"_13":16,"_32":58,"_38":59,"_42":33,"_43":41,"_60":50,"_61":39,"_62":54,"_55":14,"_51":12},"ctx",{"_226":-5,"_258":345,"_346":347,"_348":349,"_350":48,"_351":48,"_352":48,"_353":26,"_354":-5,"_355":-7,"_356":-7,"_357":22,"_358":48,"_359":48,"_360":-5,"_361":48,"_362":48,"_363":48,"_364":-5},"ENV",{"_316":317,"_318":319,"_320":16,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344},"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"]

Compare

MergePete5x5/mainintotemplates/main

README.md+24-16

Hmain.tsx+214-21

Ccleanup.ts+12-0

shared.ts+38-0

storage.ts+64-0

components

components/FormPage.tsx+0-34

components/Layout.tsx+0-18

components/SubmissionsPage.tsx+0-31

db.ts+0-31