[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_282":283,"_284":285},"routes/_app.x.$handle.$name",{"_101":100,"_32":45,"_110":91,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",37,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/storage.ts","latestPath","fileId","aa15db36-48c5-11f1-8bd1-42b51c65c3df","name","storage.ts","fileType","script","content","// ─────────────────────────────────────────────────────────────────────────────\n// storage.ts — Blob storage helpers\n// ─────────────────────────────────────────────────────────────────────────────\n//\n// Val Town provides account-scoped blob storage for binary data — images,\n// JSON snapshots, config files, etc. Blobs are shared across all your vals\n// (just like SQLite), so use key prefixes to namespace.\n//\n// Key facts:\n// • Import from: https://esm.town/v/std/blob\n// • `.set(key, value)` — store a string or binary blob\n// • `.get(key)` — retrieve it (returns Response-like object)\n// • `.list(prefix?)` — list all keys (optionally filtered by prefix)\n// • `.delete(key)` — remove a blob\n// • No filesystem — blob storage is the alternative for file-like data.\n//\n// Docs: https://docs.val.town/reference/std/blob\n// ─────────────────────────────────────────────────────────────────────────────\n\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n/** Key prefix to avoid collisions with other vals. */\nconst PREFIX = \"template/\";\n\n// ── Read / Write ─────────────────────────────────────────────────────────────\n\n/** Store a JSON-serialisable value under a namespaced key. */\nexport async function saveJSON(key: string, value: unknown): Promise {\n await blob.setJSON(`${PREFIX}${key}`, value);\n}\n\n/** Retrieve a previously stored JSON value, or null if missing. */\nexport async function loadJSON(key: string): Promise {\n try {\n const data = await blob.getJSON(`${PREFIX}${key}`);\n return data !== undefined ? (data as T) : null;\n } catch {\n return null;\n }\n}\n\n// ── List / Delete ────────────────────────────────────────────────────────────\n\n/** List all blob keys under our namespace. */\nexport async function listKeys(): Promise {\n const keys = await blob.list(PREFIX);\n // Strip the prefix so callers see clean names\n return keys.map((k: { key: string } | string) =>\n (typeof k === \"string\" ? k : k.key).replace(PREFIX, \"\")\n );\n}\n\n/** Delete a namespaced blob. */\nexport async function remove(key: string): Promise {\n await blob.delete(`${PREFIX}${key}`);\n}\n","createdAt",["D",1778074992189],"branchVersion","branchId","5a0a7ac8-4895-11f1-80ec-42b51c65c3df","id","5a09ae54-4895-11f1-80ec-42b51c65c3df","Quickstart-Full-Stack",["D",1777994172310],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","An elegant template for an elegant single-person full stack app.","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3ed9401e-3850-4a69-dec2-1bdd924c0900/square512?exp=1789549199&sig=4f04f60d95727a9894033a79d182f33a07c735c785db802252e7ee188e97a607","173e7424-8658-428f-a3bc-ae4faeaabd1c","pinnedFileId","e1c705aa-4b18-11f1-b4ae-ee650bb23af1","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","019df771-9af8-7238-99a4-541e39355038","tursoName","5a09ae54489511f180ec42b51c65c3df","tursoHostname","5a09ae54489511f180ec42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789511441255],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},"branch",{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"isOwned",384,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pikachu","handle","displayName","Minion","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/22c8ba37-42c8-4af4-8daf-8cdd2f5f1800/square512?exp=1789549199&sig=9503fba6bcb20febc2a8328fccf68da2ad84e9012958b4d71ae2e174a03baa7f","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":277,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":278,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":279,"_85":280,"_87":281,"_89":25},"tree",[211,213,215,218,219,220,221,222],"files",[211,212,213,214,215,216,217,218,219,220,221,222],"counts",{"_201":147,"_202":64,"_203":64,"_204":205,"_206":207},"contents",[132,133,134,135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":195,"_32":196,"_30":197,"_143":-5,"_41":42,"_40":198,"_145":60,"_38":199,"_13":147,"_34":187,"_36":-5,"_24":25,"_149":-5,"_27":200},{"_43":189,"_32":190,"_30":191,"_143":-5,"_41":42,"_40":192,"_145":60,"_38":193,"_13":147,"_34":187,"_36":-5,"_24":25,"_149":-5,"_27":194},{"_43":182,"_32":183,"_30":184,"_143":-5,"_41":42,"_40":185,"_145":25,"_38":186,"_13":147,"_34":187,"_36":-5,"_24":25,"_149":-5,"_27":188},{"_43":175,"_32":176,"_30":177,"_143":-5,"_41":42,"_40":178,"_145":25,"_38":179,"_13":64,"_34":20,"_36":180,"_24":25,"_149":-5,"_27":181},{"_43":167,"_32":168,"_30":169,"_143":-5,"_41":42,"_40":170,"_145":25,"_38":171,"_13":64,"_34":172,"_36":173,"_24":25,"_149":-5,"_27":174},{"_43":159,"_32":160,"_30":161,"_143":-5,"_41":42,"_40":162,"_145":25,"_38":163,"_13":156,"_34":164,"_36":165,"_24":25,"_149":-5,"_27":166},{"_43":151,"_32":152,"_30":153,"_143":-5,"_41":42,"_40":154,"_145":25,"_38":155,"_13":156,"_34":35,"_36":157,"_24":25,"_149":-5,"_27":158},{"_43":140,"_32":141,"_30":142,"_143":-5,"_41":42,"_40":144,"_145":25,"_38":146,"_13":147,"_34":20,"_36":148,"_24":25,"_149":-5,"_27":150},"aa729362-48c5-11f1-87ca-42b51c65c3df","val.yml","aa729402-48c5-11f1-87ca-42b51c65c3df","parentId",5,"latest",["D",1778014923050],0,"name: \"_template\"\npublic: true\norg: \"uapps\"\n","label",[141],"dcf15016-494d-11f1-9a0b-42b51c65c3df","index.ts","5ae332be-4895-11f1-a469-42b51c65c3df",30,["D",1778073419313],3,"// ─────────────────────────────────────────────────────────────────────────────\n// Val Town — _template\n// ─────────────────────────────────────────────────────────────────────────────\n//\n// The canonical uApps starter val. A living, breathing reference for the\n// Val Town platform — copy it with `vt new ` and trim what you don't\n// need.\n//\n// Architecture (one concern per file):\n//\n// index.ts ← HTTP handler (this file — the default export)\n// cron.ts ← Cron / scheduled-task handler\n// email.ts ← Inbound email handler\n// db.ts ← SQLite helpers (schema + queries)\n// storage.ts ← Blob storage helpers\n// shared.ts ← Constants, types, and tiny utilities\n// README.md ← You are here — full platform walkthrough\n//\n// Docs: https://docs.val.town/\n// ─────────────────────────────────────────────────────────────────────────────\n\nimport { getVisitCount, recordVisit } from \"./lib/db.ts\";\nimport { APP_NAME, html } from \"./lib/shared.ts\";\n\n// ═══════════════════════════════════════════════════════════════════════════════\n// HTTP Trigger — Default Export\n// ═══════════════════════════════════════════════════════════════════════════════\n//\n// Every val can expose an HTTP endpoint. The default export receives a\n// standard `Request` and must return a standard `Response`.\n//\n// Your public URL looks like:\n// https://--.web.val.run\n//\n// You can also set a custom subdomain or even a custom domain (Pro).\n//\n// Compatible with frameworks like Hono, itty-router, etc. — but plain\n// `Request → Response` works perfectly for simple APIs.\n//\n// Docs: https://docs.val.town/vals/http/\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const { pathname } = url;\n\n // ── GET / — Landing page ────────────────────────────────────────────────\n // Returns a minimal HTML page with a visit counter (powered by SQLite).\n // DB calls are wrapped in try/catch so the page still renders when\n // running locally (off Val Town) where SQLite isn't available.\n if (pathname === \"/\" || pathname === \"\") {\n let count = 0;\n try {\n await recordVisit(\"/\");\n count = await getVisitCount();\n } catch {\n // SQLite not available (running locally)\n }\n return new Response(\n html(`\n

🏔️ ${APP_NAME}

\n This val has been visited ${count} time${\n count === 1 ? \"\" : \"s\"\n }.\n

Try the API

GET /api/health — JSON health check
GET /api/visits — Recent visits (SQLite)
POST /api/echo — Echo back your JSON body

Learn More

\n Read the Val Town docs or view\n this val's source to explore every platform feature.\n

\n `),\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n }\n\n // ── GET /api/health — JSON health check ─────────────────────────────────\n if (pathname === \"/api/health\") {\n return Response.json({\n ok: true,\n name: APP_NAME,\n timestamp: new Date().toISOString(),\n runtime: `Deno ${Deno.version.deno}`,\n });\n }\n\n // ── GET /api/visits — Recent visits from SQLite ─────────────────────────\n if (pathname === \"/api/visits\") {\n try {\n const { getRecentVisits } = await import(\"./lib/db.ts\");\n const visits = await getRecentVisits(20);\n return Response.json({ visits });\n } catch {\n return Response.json({ error: \"SQLite not available (running off-platform?)\" }, { status: 503 });\n }\n }\n\n // ── POST /api/echo — Echo request body ──────────────────────────────────\n // Demonstrates reading JSON from a POST request.\n if (pathname === \"/api/echo\" && req.method === \"POST\") {\n try {\n const body = await req.json();\n return Response.json({\n echo: body,\n receivedAt: new Date().toISOString(),\n });\n } catch {\n return Response.json({ error: \"Invalid JSON body\" }, { status: 400 });\n }\n }\n\n // ── 404 — Fallback ──────────────────────────────────────────────────────\n return Response.json(\n { error: \"Not found\", path: pathname },\n { status: 404 },\n );\n}\n",[152],"dd153d32-494d-11f1-8f36-42b51c65c3df","email.ts","aa7742d6-48c5-11f1-831b-42b51c65c3df",33,["D",1778073418908],"email","// ─────────────────────────────────────────────────────────────────────────────\n// email.ts — Email: receiving and sending\n// ─────────────────────────────────────────────────────────────────────────────\n//\n// Val Town has two email capabilities:\n//\n// 1. RECEIVE — Your val gets a unique email address. Incoming emails invoke\n// the handler you export (see `emailHandler` below).\n//\n// 2. SEND — Use the `@std/email` standard library to send outbound emails.\n// Free accounts can only send to themselves. Pro can send to anyone.\n//\n// Setup (inbound):\n// 1. Open this val in the Val Town editor\n// 2. Click the + button (top-right) → select EMAIL\n// 3. Point it at this file's `emailHandler` export\n// 4. Val Town assigns an address like: .@valtown.email\n// (you can also set a custom @valtown.email address)\n//\n// Key facts:\n// • Inbound email size limit: 30 MB (including attachments)\n// • Attachments are standard `File` objects (.text(), .arrayBuffer(), etc.)\n// • Outbound rate limit: 100 emails/min\n// • Free plan: can only send to yourself\n// • Pro plan: send to any address, add cc/bcc, attachments\n//\n// Docs:\n// Receive: https://docs.val.town/vals/email\n// Send: https://docs.val.town/reference/std/email\n// ─────────────────────────────────────────────────────────────────────────────\n\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\nimport type { InboundEmail } from \"./lib/shared.ts\";\nimport { APP_NAME } from \"./lib/shared.ts\";\n\n// ═══════════════════════════════════════════════════════════════════════════════\n// Inbound — Email Trigger Handler\n// ═══════════════════════════════════════════════════════════════════════════════\n\n/**\n * Handles incoming emails sent to this val's email address.\n *\n * Common use cases:\n * - Auto-forward emails to Slack / Discord\n * - Parse attachments and store them in Blob storage\n * - Log support emails to a SQLite table\n * - Reply with an auto-response\n */\n// deno-lint-ignore require-await\nexport default async function emailHandler(\n inbound: InboundEmail,\n): Promise {\n console.log(`📧 [${APP_NAME}] Email received`);\n console.log(` From: ${inbound.from}`);\n console.log(` To: ${inbound.to.join(\", \")}`);\n console.log(` Subject: ${inbound.subject ?? \"(no subject)\"}`);\n console.log(` Body: ${inbound.text?.slice(0, 200) ?? \"(empty)\"}...`);\n\n // ── Process attachments ─────────────────────────────────────────────────\n if (inbound.attachments.length > 0) {\n console.log(` 📎 ${inbound.attachments.length} attachment(s):`);\n for (const file of inbound.attachments) {\n console.log(` • ${file.name} (${file.type}, ${file.size} bytes)`);\n // Example: save to blob storage\n // import { blob } from \"@std/blob\";\n // await blob.set(`emails/${file.name}`, await file.arrayBuffer());\n }\n }\n\n // ── Example: auto-reply using sendNotification() below ──────────────────\n // await sendNotification(\n // `Re: ${inbound.subject ?? \"your email\"}`,\n // `Thanks for your message! We received it at ${new Date().toISOString()}.`,\n // );\n}\n\n// ═══════════════════════════════════════════════════════════════════════════════\n// Outbound — Sending Emails\n// ═══════════════════════════════════════════════════════════════════════════════\n//\n// The `@std/email` module exposes a single function:\n//\n// await email({\n// to: \"user@example.com\", // optional (defaults to you)\n// subject: \"Hello\", // required\n// text: \"Plain text body\", // text or html required\n// html: \"

Rich body

\", // text or html required\n// from: { name: \"My Val\" }, // optional display name\n// cc: \"cc@example.com\", // optional (Pro only)\n// bcc: [\"a@x.com\", \"b@x.com\"], // optional (Pro only)\n// replyTo: \"reply@example.com\", // optional\n// attachments: [{ // optional\n// content: btoa(\"file contents\"), // base64-encoded\n// filename: \"report.txt\",\n// type: \"text/plain\",\n// disposition: \"attachment\",\n// }],\n// });\n//\n// On the free plan, the `to` field is ignored — emails always go to you.\n// On Pro, you can send to anyone.\n\n/**\n * Send a simple notification email (to yourself on free, anyone on Pro).\n *\n * This is a thin wrapper around `@std/email` — use it as a starting point\n * and customise the options as needed.\n */\nexport async function sendNotification(\n subject: string,\n body: string,\n options?: {\n to?: string;\n html?: string;\n },\n): Promise {\n await sendEmail({\n subject,\n text: body,\n ...(options?.to && { to: options.to }),\n ...(options?.html && { html: options.html }),\n });\n console.log(`📤 [${APP_NAME}] Email sent: \"${subject}\"`);\n}\n\n/**\n * Send an email with attachments.\n *\n * Attachments must be base64-encoded. Use `btoa()` for text content\n * or convert binary data with `btoa(String.fromCharCode(...bytes))`.\n */\nexport async function sendWithAttachment(\n subject: string,\n body: string,\n attachment: {\n content: string; // base64-encoded\n filename: string;\n type?: string; // MIME type, e.g. \"application/pdf\"\n },\n): Promise {\n await sendEmail({\n subject,\n text: body,\n attachments: [\n {\n content: attachment.content,\n filename: attachment.filename,\n type: attachment.type ?? \"application/octet-stream\",\n disposition: \"attachment\",\n },\n ],\n });\n console.log(\n `📤 [${APP_NAME}] Email sent with attachment: \"${attachment.filename}\"`,\n );\n}\n",[160],"dcafe662-494d-11f1-b9e7-42b51c65c3df","cron.ts","aa651980-48c5-11f1-bfb8-42b51c65c3df",26,["D",1778073418887],"interval","// ─────────────────────────────────────────────────────────────────────────────\n// cron.ts — Scheduled / Cron task handler\n// ─────────────────────────────────────────────────────────────────────────────\n//\n// Cron triggers let you run code on a schedule — every few minutes, hourly,\n// daily, or via a full cron expression.\n//\n// Setup:\n// 1. Open this val in the Val Town editor\n// 2. Click the + button (top-right) → select CRON\n// 3. Point it at this file's exported function\n// 4. Set your schedule (e.g. \"every 1 hour\" or \"0 */2 1 * *\")\n//\n// Key facts:\n// • Minimum interval: 15 min (free) / 1 min (Pro)\n// • Cron expressions are always evaluated in UTC\n// • The handler receives an `Interval` with `lastRunAt`\n// • Return values are ignored — use console.log or side effects\n//\n// Docs: https://docs.val.town/vals/cron\n// ─────────────────────────────────────────────────────────────────────────────\n\nimport type { CronInterval } from \"./lib/shared.ts\";\nimport { APP_NAME } from \"./lib/shared.ts\";\n\n/**\n * Example cron handler.\n *\n * Common use cases:\n * - Poll an API or RSS feed for new items\n * - Send a daily digest email\n * - Clean up stale data in SQLite\n * - Ping a health-check endpoint\n */\nexport default function cronHandler(interval: CronInterval): void {\n const lastRun = interval.lastRunAt?.toISOString() ?? \"never\";\n console.log(`⏰ [${APP_NAME}] Cron fired! Last run: ${lastRun}`);\n\n // ── Example: fetch an API ───────────────────────────────────────────────\n // const res = await fetch(\"https://api.example.com/data\");\n // const data = await res.json();\n // console.log(\"Fetched data:\", data);\n\n // ── Example: clean up old SQLite rows ───────────────────────────────────\n // import { sqlite } from \"@std/sqlite\";\n // await sqlite.execute(\n // `DELETE FROM template_visits WHERE ts < datetime('now', '-30 days')`\n // );\n}\n",[168],"5a3ac104-491e-11f1-9e87-42b51c65c3df","README.md","aabf7b64-48c5-11f1-9920-42b51c65c3df",11,["D",1778053013652],"# 🏔️ Val Town Template\n\nStarter val demonstrating every major Val Town feature. Fork it, trim what you don't need.\n\n```bash\nvt new my-app # clones this template → vals/my-app\ncd vals/my-app\nvt watch # live-push changes on save\n```\n\n---\n\n## Files\n\n| File | Trigger | Purpose |\n|---|---|---|\n| `index.ts` | HTTP | Web server — routes, JSON API, HTML pages |\n| `cron.ts` | Cron | Scheduled tasks (poll APIs, clean data, digests) |\n| `email.ts` | Email | Receive inbound email + send outbound |\n| `db.ts` | — | SQLite schema & query helpers |\n| `storage.ts` | — | Blob storage read/write/list/delete |\n| `shared.ts` | — | Constants, types, `html()` helper, `env()` wrapper |\n\n**Rule:** One concern per file. Every file except `shared.ts` is independently deletable.\n\n---\n\n## HTTP Routes (`index.ts`)\n\n| Route | Method | Description |\n|---|---|---|\n| `/` | GET | HTML landing page with visit counter |\n| `/api/health` | GET | JSON health check |\n| `/api/visits` | GET | Recent visits from SQLite |\n| `/api/echo` | POST | Echo back your JSON body |\n| `/*` | ANY | 404 JSON response |\n\nYour val is live at `https://--.web.val.run`. Supports any framework (Hono, itty-router) or plain `Request → Response`.\n\n

Route implementation pattern

\n\n```ts\nexport default async function handler(req: Request): Promise {\n const { pathname } = new URL(req.url);\n\n if (pathname === \"/api/hello\") {\n return Response.json({ message: \"Hello!\" });\n }\n\n return Response.json({ error: \"Not found\" }, { status: 404 });\n}\n```\n

\n\n---\n\n## Cron (`cron.ts`)\n\nRun code on a schedule. **Setup:** Editor → **+** → **CRON** → point at `cronHandler`.\n\n| Format | Example | Notes |\n|---|---|---|\n| Interval | `every 1 hour` | Human-readable |\n| Cron | `0 9 * * 1-5` | 9am UTC, Mon–Fri |\n\n- Min interval: **15 min** (free) / **1 min** (Pro)\n- Handler receives `{ lastRunAt }` — useful for incremental fetches\n- Always UTC. Return values ignored — use `console.log()` for debugging\n\n

Docs link

\n\nhttps://docs.val.town/vals/cron\n

\n\n---\n\n## Email (`email.ts`)\n\n### Receiving\n\nYour val gets an address: `.@valtown.email`\n\n**Setup:** Editor → **+** → **EMAIL** → point at `emailHandler`\n\nHandler receives an `InboundEmail` with `from`, `to`, `subject`, `text`, `html`, `attachments` (standard `File[]`), and `headers`.\n\n### Sending\n\n```ts\nimport { sendNotification, sendWithAttachment } from \"./email.ts\";\n\n// Simple text email (sends to yourself on free, anyone on Pro)\nawait sendNotification(\"Subject\", \"Body text\");\n\n// With attachment\nawait sendWithAttachment(\"Report\", \"See attached\", {\n content: btoa(\"CSV,data\"),\n filename: \"report.csv\",\n type: \"text/csv\",\n});\n```\n\n| Feature | Free | Pro |\n|---|---|---|\n| Send to self | ✅ | ✅ |\n| Send to others | ❌ | ✅ |\n| CC / BCC | ❌ | ✅ |\n| Rate limit | 100/min | 100/min |\n\n

Full email options (Pro)

\n\n```ts\nimport { email } from \"@std/email\";\n\nawait email({\n to: \"user@example.com\",\n subject: \"Hello\",\n text: \"Plain text body\",\n html: \"

Rich HTML body

\",\n cc: \"cc@example.com\",\n attachments: [{\n content: btoa(\"file contents\"),\n filename: \"doc.txt\",\n type: \"text/plain\",\n }],\n});\n```\n

\n\n---\n\n## SQLite (`db.ts`)\n\nEvery account gets a private SQLite database (Turso). Shared across all vals — **namespace your tables**.\n\n```ts\nimport { sqlite } from \"@std/sqlite\";\n\n// Simple query\nconst { rows } = await sqlite.execute(\"SELECT 1\");\n\n// Parameterized\nawait sqlite.execute({ sql: \"SELECT * FROM users WHERE age > ?\", args: [18] });\n\n// Batch (transaction)\nawait sqlite.batch([\n \"CREATE TABLE IF NOT EXISTS t (id INTEGER PRIMARY KEY)\",\n { sql: \"INSERT INTO t VALUES (?)\", args: [1] },\n]);\n```\n\n- Returns `{ rows: any[][], columns: string[] }` — rows are arrays, not objects\n- Use `CREATE TABLE IF NOT EXISTS` for migrations (safe to re-run)\n- Storage: **10 MB** (free) / **1 GB** (Pro)\n\n

Docs link

\n\nhttps://docs.val.town/reference/std/sqlite/\n

\n\n---\n\n## Blob Storage (`storage.ts`)\n\nFor binary data, JSON snapshots, config — anything that doesn't fit in SQLite.\n\n```ts\nimport { saveJSON, loadJSON, listKeys, remove } from \"./storage.ts\";\n\nawait saveJSON(\"config\", { theme: \"dark\" });\nconst cfg = await loadJSON<{ theme: string }>(\"config\");\n```\n\nRaw API: `blob.set(key, value)`, `blob.get(key)`, `blob.list(prefix?)`, `blob.delete(key)`.\n\nKeys are prefixed with `template/` — change the `PREFIX` constant when you rename your val.\n\n

Docs link

\n\nhttps://docs.val.town/reference/std/blob\n

\n\n---\n\n## Imports (`deno.json`)\n\nDependencies are mapped in `deno.json` for clean imports:\n\n```jsonc\n{\n \"imports\": {\n \"@std/sqlite\": \"https://esm.town/v/std/sqlite\",\n \"@std/blob\": \"https://esm.town/v/std/blob\",\n \"@std/email\": \"https://esm.town/v/std/email\"\n }\n}\n```\n\nAll Deno import styles work: `./relative.ts`, `npm:lodash`, `jsr:@std/zod`, `https://esm.sh/hono`, `https://esm.town/v/user/val`.\n\n---\n\n## Environment Variables\n\nSet in Val Town UI sidebar → **Environment Variables**. Private even on public vals.\n\n```ts\nconst key = Deno.env.get(\"MY_API_KEY\"); // Deno-native\nconst key = env(\"MY_API_KEY\", \"fallback\"); // from shared.ts\n```\n\n`Deno.env.set()` is a **no-op** on Val Town.\n\n---\n\n## `val.yml` Configuration\n\n```yaml\nname: \"_template\" # Val name on Val Town\npublic: true # true = public, false = private/unlisted\norg: \"uapps\" # Deploy under this org (optional)\n```\n\n---\n\n## Runtime & Limits\n\n| | Detail |\n|---|---|\n| Runtime | Deno (latest stable), TypeScript built-in |\n| Timeout | ~30s per request |\n| Filesystem | ❌ — use SQLite + Blob |\n| WebSockets | ❌ |\n| Web APIs | ✅ Request, Response, fetch, URL, Headers |\n\n| Resource | Free | Pro |\n|---|---|---|\n| Private vals | 5 | Unlimited |\n| SQLite | 10 MB | 1 GB |\n| Cron min interval | 15 min | 1 min |\n| Email | Self only | Anyone |\n\n---\n\n## CLI Workflow\n\n```bash\nvt status # Check sync state\nvt push # Deploy local → Val Town\nvt pull # Pull remote → local\nvt watch # Auto-push on file save\nvt checkout -b feat # Work on a branch\nvt log # View version history\n```\n",[176],"dc75c87e-494d-11f1-b9e7-42b51c65c3df","lib","dc75c91e-494d-11f1-b9e7-42b51c65c3df",25,["D",1778073418511],"directory",[183],"85f9d626-4951-11f1-a16a-42b51c65c3df","frontend","85f9d6f8-4951-11f1-a16a-42b51c65c3df",34,["D",1778074991402],[190],"86303568-4951-11f1-a193-42b51c65c3df","backend","8630361c-4951-11f1-a193-42b51c65c3df",35,["D",1778074991756],[196],"pulls","branches","forks","envVars",{"_208":64,"_210":147},"connections",{"_208":147,"_209":147},"count","unfilledCount","emptyCount",{"_43":195,"_32":196,"_30":197,"_143":-5,"_41":42,"_40":198,"_145":60,"_38":274,"_13":147,"_34":187,"_36":-5,"_24":25,"_149":-5,"_224":275,"_27":276},{"_43":269,"_32":33,"_30":31,"_143":197,"_41":42,"_40":14,"_145":25,"_38":270,"_13":271,"_34":35,"_36":37,"_24":25,"_149":-5,"_224":272,"_27":273},{"_43":189,"_32":190,"_30":191,"_143":-5,"_41":42,"_40":192,"_145":60,"_38":266,"_13":147,"_34":187,"_36":-5,"_24":25,"_149":-5,"_224":267,"_27":268},{"_43":258,"_32":259,"_30":260,"_143":191,"_41":42,"_40":261,"_145":25,"_38":262,"_13":147,"_34":35,"_36":263,"_24":25,"_149":-5,"_224":264,"_27":265},{"_43":182,"_32":183,"_30":184,"_143":-5,"_41":42,"_40":185,"_145":25,"_38":255,"_13":147,"_34":187,"_36":-5,"_24":25,"_149":-5,"_224":256,"_27":257},{"_43":247,"_32":248,"_30":249,"_143":184,"_41":42,"_40":250,"_145":25,"_38":251,"_13":144,"_34":35,"_36":252,"_24":25,"_149":-5,"_224":253,"_27":254},{"_43":239,"_32":240,"_30":241,"_143":184,"_41":42,"_40":242,"_145":25,"_38":243,"_13":64,"_34":35,"_36":244,"_24":25,"_149":-5,"_224":245,"_27":246},{"_43":175,"_32":176,"_30":177,"_143":-5,"_41":42,"_40":178,"_145":25,"_38":236,"_13":64,"_34":20,"_36":180,"_24":25,"_149":-5,"_224":237,"_27":238},{"_43":167,"_32":168,"_30":169,"_143":-5,"_41":42,"_40":170,"_145":25,"_38":233,"_13":64,"_34":172,"_36":173,"_24":25,"_149":-5,"_224":234,"_27":235},{"_43":159,"_32":160,"_30":161,"_143":-5,"_41":42,"_40":162,"_145":25,"_38":230,"_13":156,"_34":164,"_36":165,"_24":25,"_149":-5,"_224":231,"_27":232},{"_43":151,"_32":152,"_30":153,"_143":-5,"_41":42,"_40":154,"_145":25,"_38":227,"_13":156,"_34":35,"_36":157,"_24":25,"_149":-5,"_224":228,"_27":229},{"_43":140,"_32":141,"_30":142,"_143":-5,"_41":42,"_40":144,"_145":25,"_38":223,"_13":147,"_34":20,"_36":148,"_24":25,"_149":-5,"_224":225,"_27":226},["D",1778014923050],"children",[],[141],["D",1778073419313],[],[152],["D",1778073418908],[],[160],["D",1778073418887],[],[168],["D",1778053013652],[],[176],"dcc7160c-494d-11f1-9cb0-42b51c65c3df","shared.ts","aada9642-48c5-11f1-b1d7-42b51c65c3df",28,["D",1778073418941],"// ─────────────────────────────────────────────────────────────────────────────\n// shared.ts — Constants, types, and tiny utilities\n// ─────────────────────────────────────────────────────────────────────────────\n//\n// Keep this file dependency-free. It's imported by every other module.\n// ─────────────────────────────────────────────────────────────────────────────\n\n// ── Constants ────────────────────────────────────────────────────────────────\n\n/** Display name used in HTML titles, logs, and API responses. */\nexport const APP_NAME = \"Val Town Template\";\n\n// ── Environment Variables ────────────────────────────────────────────────────\n//\n// Secrets and API keys live in the Val Town UI sidebar (Environment Variables).\n// They are private — even on public vals, values are never exposed to viewers.\n//\n// const key = Deno.env.get(\"MY_API_KEY\"); // Deno-native\n// const key = process.env.MY_API_KEY; // Node-compat shim\n//\n// ⚠️ Deno.env.set() is a no-op on Val Town. You can only set env vars via\n// the UI or via Environment Groups (org accounts).\n//\n// Docs: https://docs.val.town/reference/environment-variables\n\n/** Read an env var with an optional fallback. */\nexport function env(key: string, fallback = \"\"): string {\n return Deno.env.get(key) ?? fallback;\n}\n\n// ── Importing Modules ────────────────────────────────────────────────────────\n//\n// Val Town runs on Deno. You can import from:\n//\n// Relative files: import { helper } from \"./utils.ts\";\n// npm: import lodash from \"npm:lodash\";\n// jsr: import { z } from \"jsr:@std/zod\";\n// https: import { Hono } from \"https://esm.sh/hono\";\n// Other vals: import { foo } from \"https://esm.town/v/username/valName\";\n//\n// Docs: https://docs.val.town/reference/import/\n\n// ── HTML Helper ──────────────────────────────────────────────────────────────\n\n/** Wrap body HTML in a minimal, styled document shell. */\nexport function html(body: string): string {\n return `\n\n\n \n \n ${APP_NAME}\n \n\n\n ${body}\n\n`;\n}\n\n// ── Types ────────────────────────────────────────────────────────────────────\n\n/** Val Town's inbound Email type. */\nexport interface InboundEmail {\n from: string;\n to: string[];\n cc: string | string[] | undefined;\n bcc: string | string[] | undefined;\n subject: string | undefined;\n text: string | undefined;\n html: string | undefined;\n attachments: File[];\n headers: Record;\n}\n\n/** Val Town's Cron Interval type. */\nexport interface CronInterval {\n lastRunAt: Date | undefined;\n}\n",[],[183,240],"dce33756-494d-11f1-9738-42b51c65c3df","db.ts","aad2cfa2-48c5-11f1-bfb8-42b51c65c3df",29,["D",1778073418897],"// ─────────────────────────────────────────────────────────────────────────────\n// db.ts — SQLite helpers\n// ─────────────────────────────────────────────────────────────────────────────\n//\n// Val Town gives every account a private SQLite database (powered by Turso).\n// It's shared across all your vals — so namespace your tables if needed.\n//\n// Key facts:\n// • Import val-scoped DB: import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\"\n// • Import legacy global: import { sqlite } from \"https://esm.town/v/std/sqlite/global.ts\"\n// • `.execute()` runs a single statement (returns { rows, columns })\n// • `.batch()` runs multiple statements in a transaction\n// • Storage: 10 MB free / 1 GB Pro — contact Val Town for more\n// • No filesystem access — SQLite and Blob are your persistence layers.\n//\n// Docs: https://docs.val.town/reference/std/sqlite/\n// ─────────────────────────────────────────────────────────────────────────────\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ── Schema Migration ─────────────────────────────────────────────────────────\n// Lazily run on first DB call, not at import time. This prevents crashes\n// when running locally (off Val Town) where the SQLite API isn't available.\n\nlet migrated = false;\n\nasync function migrate(): Promise {\n if (migrated) return;\n migrated = true;\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS template_visits (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n path TEXT NOT NULL,\n ts TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n}\n\n// ── Queries ──────────────────────────────────────────────────────────────────\n\n/** Record a page visit. */\nexport async function recordVisit(path: string): Promise {\n await migrate();\n await sqlite.execute({\n sql: `INSERT INTO template_visits (path) VALUES (?)`,\n args: [path],\n });\n}\n\n/** Get total visit count. */\nexport async function getVisitCount(): Promise {\n await migrate();\n const { rows } = await sqlite.execute(\n `SELECT COUNT(*) as count FROM template_visits`,\n );\n return Number(rows[0][0]);\n}\n\n/** Get the N most recent visits. */\nexport async function getRecentVisits(\n limit = 10,\n): Promise> {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: `SELECT id, path, ts FROM template_visits ORDER BY ts DESC LIMIT ?`,\n args: [limit],\n });\n return (rows as unknown as unknown[][]).map((r) => ({\n id: Number(r[0]),\n path: String(r[1]),\n ts: String(r[2]),\n }));\n}\n",[],[183,248],["D",1778073418511],[216,217],[183],"866c9120-4951-11f1-9e49-42b51c65c3df","main.js","866c91f2-4951-11f1-9e49-42b51c65c3df",36,["D",1778074992154],"// Fetch the visit count from our API on load\nasync function fetchVisits() {\n try {\n // Calling the API endpoint that was migrated to /api/visits\n // We will update the backend to return total count as well.\n const res = await fetch(\"/api/visits\");\n const data = await res.json();\n\n if (data.total !== undefined) {\n document.getElementById(\"visit-count\").textContent = data.total;\n }\n } catch (err) {\n console.error(\"Failed to fetch visits:\", err);\n document.getElementById(\"visit-count\").textContent = \"Error loading\";\n }\n}\n\nfetchVisits();\n",[],[190,259],["D",1778074991402],[214],[190],"86739092-4951-11f1-b6e3-42b51c65c3df",["D",1778074992189],4,[],[196,33],["D",1778074991756],[212],[196],["D",1777994172310],["D",1789511441255],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},{"_13":90,"_32":91,"_43":42,"_92":44,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":45,"_99":100},"ctx",{"_83":-5,"_129":315,"_316":317,"_318":319,"_320":25,"_321":25,"_322":25,"_323":60,"_324":-5,"_325":-7,"_326":-7,"_327":147,"_328":25,"_329":25,"_330":-5,"_331":25,"_332":25,"_333":25,"_334":-5},"ENV",{"_286":287,"_288":289,"_290":91,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314},"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 · v37