hi

\",\"name\":\"release\",\"kind\":\"html\"}'\n\n# List all artifacts (metadata only)\ncurl \"$BASE/api/artifacts\" -H \"Authorization: Bearer $KEY\"\n```\n\n`POST /api/artifacts` returns `201` with `{ \"id\", \"url\" }` (an absolute URL);\n`GET /api/artifacts` returns the artifact list. The browser UI's `/upload`\nroute is unchanged and stays open.\n\n## How it works\n\n```\nmain.tsx Hono routes (the HTTP entry)\nbackend/\n db.ts SQLite metadata + val-scoped blob contents\n render.ts Markdown → HTML; HTML passes through as-is\nfrontend/\n Layout.tsx HTML shell\n Landing.tsx overview and dashboard link\n Dashboard.tsx list, upload, rename, and delete artifacts\n Viewer.tsx sandboxed iframe for one artifact\n upload.client.ts drag-and-drop browser script\nexamples/ seed artifacts\n```\n\n## Storage\n\nSQLite stores each artifact's id, name, kind, blob key, uploader, and creation\ntime. The uploaded source lives under the `artifacts/` prefix in this val's\nproject-scoped blob storage. New remixes therefore start with isolated data.\n\n## Security model\n\nArtifacts are untrusted content, including Markdown that contains raw HTML:\n\n- They render in an iframe without `allow-same-origin`. JavaScript can run, but\n it cannot read the app's cookies or call app routes as the viewer.\n- `/a/:id/raw` also sends `Content-Security-Policy: sandbox`, so opening it\n directly keeps the same opaque-origin boundary.\n- Markdown goes through the same sandbox as uploaded HTML.\n\nIf the app is restricted, anyone allowed through the Val Town access gate can\nupload, rename, and delete artifacts.","deleted","label",[19],{"_36":173,"_13":174,"_60":175,"_62":-5,"_63":64,"_65":70,"_67":68,"_38":176,"_17":34,"_71":99,"_72":-5,"_74":51,"_75":-5,"_89":177,"_18":178},{"_36":143,"_13":144,"_60":145,"_62":-5,"_63":64,"_65":70,"_67":68,"_38":146,"_17":34,"_71":99,"_72":-5,"_74":51,"_75":-5,"_89":147,"_18":148},{"_36":95,"_13":96,"_60":97,"_62":-5,"_63":64,"_65":70,"_67":68,"_38":98,"_17":34,"_71":99,"_72":-5,"_74":51,"_75":-5,"_89":100,"_18":101},{"_36":59,"_13":19,"_60":61,"_62":-5,"_63":64,"_65":66,"_67":68,"_38":92,"_17":70,"_71":24,"_72":73,"_74":51,"_75":-5,"_89":93,"_18":94},{"_36":82,"_13":83,"_60":84,"_62":-5,"_63":64,"_65":32,"_67":68,"_38":85,"_17":86,"_71":87,"_72":88,"_74":51,"_75":-5,"_89":90,"_18":91},"19525a57-678e-4bf8-9e95-f78cfce3d3e6","main.tsx","01a01be0-4032-74fe-b778-9ea05628c043",["D",1787341576565],2,"http","/** @jsxImportSource npm:hono@4/jsx */\nimport { Hono, type Context } from \"npm:hono@4\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nimport {\n createArtifact,\n deleteArtifact,\n getArtifact,\n initDb,\n listArtifacts,\n renameArtifact,\n} from \"./backend/db.ts\";\nimport { renderArtifact } from \"./backend/render.ts\";\nimport { Dashboard } from \"./frontend/Dashboard.tsx\";\nimport { Landing } from \"./frontend/Landing.tsx\";\nimport { Layout } from \"./frontend/Layout.tsx\";\nimport { Viewer } from \"./frontend/Viewer.tsx\";\n\nconst ORG = parseVal().username;\nconst IS_TEMPLATE_DEMO = ORG === \"templates\";\nconst IDENTITY_HEADER = \"X-Val-Town-User\";\n\nawait initDb();\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err)); // surface real stack traces\n\n// Render a JSX page as a full HTML document.\nconst page = (node: any, status = 200) =>\n new Response(\"\" + node.toString(), {\n status,\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n\n// Resolve the signed identity added by Val Town Access for human viewers.\n// Public and automation-bypass requests have no viewer identity.\nasync function getViewer(req: Request): Promise<{ username: string | null } | null> {\n const signed = req.headers.get(IDENTITY_HEADER);\n const token = Deno.env.get(\"valtown\");\n if (!signed || !token) return null;\n\n const response = await fetch(\"https://api.val.town/v3/val/viewer\", {\n headers: {\n Authorization: `Bearer ${token}`,\n [IDENTITY_HEADER]: signed,\n },\n });\n if (!response.ok) return null;\n return await response.json();\n}\n\n// Val Town Access can restrict this entire app to designated team members.\n// It runs before this handler, so the app itself needs no OAuth routes or keys.\napp.get(\"/\", (c) =>\n page());\n\napp.get(\"/dashboard\", async (c) => {\n const artifacts = await listArtifacts();\n return page(\n \n \n ,\n );\n});\n\n// --- Programmatic API -----------------------------------------------------\n// The /api/* routes are gated behind ARTIFACTS_API_KEY so only the owner can\n// upload or list artifacts through the API, while the browser UI (/upload)\n// stays open. Set the key in the val's environment variables.\n\nfunction requireKey(c: Context): boolean {\n const supplied =\n c.req.header(\"authorization\")?.replace(/^Bearer\\s+/i, \"\") ??\n c.req.header(\"x-api-key\") ??\n \"\";\n const expected = Deno.env.get(\"ARTIFACTS_API_KEY\");\n return !!expected && supplied.length > 0 && supplied === expected;\n}\n\n// Parse a multipart upload into the fields createArtifact needs, or null when\n// the payload carries no content. Shared by the UI route and the API route so\n// their behavior stays identical.\nasync function artifactFromForm(form: FormData) {\n const file = form.get(\"file\");\n const source = file instanceof File\n ? await file.text()\n : (form.get(\"html\")?.toString() ?? \"\");\n if (!source.trim()) return null;\n const rawName = form.get(\"name\")?.toString()\n || (file instanceof File ? file.name : \"\")\n || \"untitled\";\n // Markdown when the filename says so (or the form explicitly asks); else HTML.\n const kind = /\\.(md|markdown)$/i.test(rawName) ||\n form.get(\"kind\")?.toString() === \"md\"\n ? \"md\"\n : \"html\";\n const name = rawName.replace(/\\.(html?|md|markdown)$/i, \"\").trim().slice(0, 80) ||\n \"untitled\";\n return { name, kind, source };\n}\n\n// List all artifacts as JSON (metadata only, no bodies).\napp.get(\"/api/artifacts\", async (c) => {\n if (!requireKey(c)) return c.json({ error: \"Unauthorized\" }, 401);\n return c.json(await listArtifacts());\n});\n\n// Create an artifact via the API. Accepts multipart (a `file` field, like the\n// UI) or JSON ({ html, name?, kind? }). Returns an absolute URL.\napp.post(\"/api/artifacts\", async (c) => {\n if (!requireKey(c)) return c.json({ error: \"Unauthorized\" }, 401);\n if (IS_TEMPLATE_DEMO) return c.json({ error: \"Uploads are disabled in the template demo.\" }, 403);\n const contentType = c.req.header(\"content-type\") ?? \"\";\n let parsed;\n if (contentType.includes(\"application/json\")) {\n const body = await c.req.json();\n if (typeof body?.html !== \"string\" || !body.html.trim()) {\n return c.json({ error: \"html is required\" }, 400);\n }\n parsed = {\n name: typeof body.name === \"string\"\n ? body.name.trim().slice(0, 80) || \"untitled\"\n : \"untitled\",\n kind: body.kind === \"md\" ? \"md\" : \"html\",\n source: body.html,\n };\n } else {\n parsed = await artifactFromForm(await c.req.formData());\n if (!parsed) return c.json({ error: \"That file is empty.\" }, 400);\n }\n const id = await createArtifact({\n name: parsed.name,\n html: parsed.source,\n kind: parsed.kind,\n createdBy: \"api\",\n });\n return c.json(\n { id, url: `${new URL(c.req.url).origin}/a/${id}` },\n 201,\n );\n});\n\n// Create an artifact from a dropped/selected HTML or Markdown file (browser UI).\napp.post(\"/upload\", async (c) => {\n if (IS_TEMPLATE_DEMO) return c.text(\"Uploads are disabled in the template demo.\", 403);\n const parsed = await artifactFromForm(await c.req.formData());\n if (!parsed) return c.text(\"That file is empty.\", 400);\n const viewer = await getViewer(c.req.raw);\n const id = await createArtifact({\n name: parsed.name,\n html: parsed.source,\n kind: parsed.kind,\n createdBy: viewer?.username ?? \"anonymous\",\n });\n return c.json({ id, url: `/a/${id}` });\n});\n\n// View an artifact, rendered inside a sandboxed iframe (see Viewer).\napp.get(\"/a/:id\", async (c) => {\n const artifact = await getArtifact(c.req.param(\"id\"));\n if (!artifact) {\n return page(, 404);\n }\n return page(\n ,\n );\n});\n\n// Raw artifact HTML — the source for the sandboxed iframe. The CSP `sandbox`\n// directive forces an opaque origin even on a top-level visit, so uploaded\n// scripts can never act as the viewer (mirrors Viewer).\napp.get(\"/a/:id/raw\", async (c) => {\n const artifact = await getArtifact(c.req.param(\"id\"));\n if (!artifact) return c.text(\"Not found\", 404);\n return new Response(renderArtifact(artifact), {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"content-security-policy\":\n \"sandbox allow-scripts allow-forms allow-popups allow-modals\",\n \"x-content-type-options\": \"nosniff\",\n },\n });\n});\n\napp.post(\"/a/:id/rename\", async (c) => {\n if (IS_TEMPLATE_DEMO) return c.text(\"Renaming is disabled in the template demo.\", 403);\n const form = await c.req.formData();\n const name = (form.get(\"name\")?.toString() ?? \"\").trim().slice(0, 80);\n if (!name) return c.text(\"Name is required.\", 400);\n if (!await renameArtifact(c.req.param(\"id\"), name)) {\n return c.text(\"Not found\", 404);\n }\n return c.redirect(\"/dashboard\");\n});\n\napp.post(\"/a/:id/delete\", async (c) => {\n if (IS_TEMPLATE_DEMO) return c.text(\"Deleting is disabled in the template demo.\", 403);\n await deleteArtifact(c.req.param(\"id\"));\n return c.redirect(\"/dashboard\");\n});\n\n// Drag-and-drop client script (kept out of the markup per house style).\napp.get(\n \"/upload.client.js\",\n (c) => serveFile(\"./frontend/upload.client.ts\", import.meta.url),\n);\n\n// Every Val Town app links to its own source.\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default app.fetch;\n","children",[],[83],["D",1787342240415],[],[19],"fc899a6a-9bd2-4344-8789-467a49713f55","frontend","01a01be0-4032-74fe-b778-9660538c09f1",["D",1787174076294],"directory",[102,103,104,105,106],[96],{"_36":136,"_13":137,"_60":138,"_62":97,"_63":64,"_65":70,"_67":68,"_38":139,"_17":34,"_71":111,"_72":140,"_74":51,"_75":-5,"_89":141,"_18":142},{"_36":129,"_13":130,"_60":131,"_62":97,"_63":64,"_65":70,"_67":68,"_38":132,"_17":34,"_71":111,"_72":133,"_74":51,"_75":-5,"_89":134,"_18":135},{"_36":122,"_13":123,"_60":124,"_62":97,"_63":64,"_65":70,"_67":68,"_38":125,"_17":34,"_71":111,"_72":126,"_74":51,"_75":-5,"_89":127,"_18":128},{"_36":115,"_13":116,"_60":117,"_62":97,"_63":64,"_65":70,"_67":68,"_38":118,"_17":34,"_71":111,"_72":119,"_74":51,"_75":-5,"_89":120,"_18":121},{"_36":107,"_13":108,"_60":109,"_62":97,"_63":64,"_65":70,"_67":68,"_38":110,"_17":34,"_71":111,"_72":112,"_74":51,"_75":-5,"_89":113,"_18":114},"084d3e5b-7141-4487-98a9-1d5a73eff7ee","upload.client.ts","01a01be0-4032-74fe-b778-9054966e8bd4",["D",1787174076294],"script","// Drag-and-drop / file-picker uploader for the dashboard, plus a small\n// confirm() for delete forms. Kept out of the markup per house style.\n\nconst zone = document.getElementById(\"dropzone\");\nconst input = document.getElementById(\"fileInput\") as HTMLInputElement | null;\nconst statusEl = document.getElementById(\"dropStatus\");\n\nfunction setStatus(msg: string) {\n if (statusEl) statusEl.textContent = msg;\n}\n\nif (zone && input) {\n const highlight = (on: boolean) =>\n zone.classList.toggle(\"border-blue-400\", on);\n\n zone.addEventListener(\"dragover\", (e) => {\n e.preventDefault();\n highlight(true);\n });\n zone.addEventListener(\"dragleave\", (e) => {\n // dragleave also fires when the pointer moves onto a child element; only\n // clear the highlight when it actually leaves the zone.\n if (!zone.contains((e as DragEvent).relatedTarget as Node | null)) {\n highlight(false);\n }\n });\n zone.addEventListener(\"drop\", (e) => {\n e.preventDefault();\n highlight(false);\n const files = (e as DragEvent).dataTransfer?.files;\n if (files && files.length) uploadAll(files);\n });\n input.addEventListener(\"change\", () => {\n if (input.files && input.files.length) uploadAll(input.files);\n });\n}\n\nasync function uploadAll(files: FileList) {\n const list = [...files].filter(\n (f) =>\n /\\.(html?|md|markdown)$/i.test(f.name) ||\n f.type === \"text/html\" ||\n f.type === \"text/markdown\",\n );\n if (!list.length) {\n setStatus(\"Please drop .html or .md files.\");\n return;\n }\n setStatus(`Uploading ${list.length} file${list.length > 1 ? \"s\" : \"\"}…`);\n let lastUrl = \"\";\n try {\n for (const file of list) {\n const body = new FormData();\n body.set(\"file\", file);\n body.set(\"name\", file.name);\n const res = await fetch(\"/upload\", { method: \"POST\", body });\n if (!res.ok) throw new Error(await res.text());\n lastUrl = (await res.json()).url;\n }\n } catch (err) {\n setStatus(\n \"Upload failed: \" + (err instanceof Error ? err.message : String(err)),\n );\n return;\n }\n location.href = list.length === 1 ? lastUrl : \"/dashboard\";\n}\n\n// Confirm before submitting any form marked with data-confirm.\nfor (\n const form of document.querySelectorAll(\"form[data-confirm]\")\n) {\n form.addEventListener(\"submit\", (e) => {\n if (!confirm(form.getAttribute(\"data-confirm\") || \"Are you sure?\")) {\n e.preventDefault();\n }\n });\n}\n",[],[96,108],"0efb2b8c-5422-4261-a003-117975194855","Viewer.tsx","01a01be0-4032-74fe-b778-8fc6f65f6622",["D",1787174076294],"/** @jsxImportSource npm:hono@4/jsx */\nimport type { Artifact } from \"../backend/db.ts\";\n\nexport function Viewer(props: { artifact?: Artifact; notFound?: boolean }) {\n if (props.notFound || !props.artifact) {\n return (\n

\n That artifact doesn't exist.{\" \"}\n Back to artifacts\n

\n );\n }\n const a = props.artifact;\n return (\n

\n \n ← all\n \n \n {a.name}\n \n \n by {a.createdBy}\n \n

\n \n

\n );\n}\n",[],[96,116],"905e99a1-65b0-4877-85c7-cd0cdf080fe5","Layout.tsx","01a01be0-4032-74fe-b778-8858b4e1a17a",["D",1787174076294],"/** @jsxImportSource npm:hono@4/jsx */\n\nexport function Layout(\n props: { title: string; bare?: boolean; children: any },\n) {\n return (\n \n \n \n \n {props.title}\n \n \n \n \n {props.bare ? props.children : (\n

\n {props.children}\n

\n )}\n \n \n );\n}\n\nfunction Footer() {\n return (\n \n );\n}\n",[],[96,123],"c5eed6c1-68e4-45a3-bbb8-ad53f288c2fa","Landing.tsx","01a01be0-4031-7689-ba3a-0eb72c04f2ca",["D",1787174076294],"/** @jsxImportSource npm:hono@4/jsx */\n\nexport function Landing(props: { org: string }) {\n return (\n

\n \n Built for{\" \"}\n @{props.org}\n

\n Artifacts\n

\n A simple place to host and share HTML pages and Markdown docs. Drop in an{\" \"}\n \n .html\n {\" \"}\n or{\" \"}\n \n .md\n {\" \"}\n file and get a link you can share.\n

\n\n

\n \n Open artifacts\n \n

\n\n

\n \n \n \n

\n );\n}\n\nfunction Feature(props: { title: string; body: string }) {\n return (\n

{props.title}

{props.body}

\n );\n}\n",[],[96,130],"c08c3529-1254-4626-8e2b-18aaedae61fa","Dashboard.tsx","01a01be0-4031-7689-ba3a-08eb8304f1d2",["D",1787174076294],"/** @jsxImportSource npm:hono@4/jsx */\nimport type { Artifact } from \"../backend/db.ts\";\n\nexport function Dashboard(\n props: { org: string; artifacts: Artifact[]; readOnly?: boolean },\n) {\n const count = props.artifacts.length;\n return (\n

\n Artifacts\n

\n @{props.org} · {count} {count === 1 ? \"page\" : \"pages\"}\n

\n \n about\n \n

\n\n {props.readOnly && (\n

\n Note:{\" \"}\n for this demo, uploads are not enabled. When you remix this val, your\n team will be able to upload / rename / delete artifacts!\n

\n )}\n\n \n \n

\n Drop an HTML or Markdown file here\n

\n .html or .md · or click to choose · published instantly\n

\n \n\n {count === 0\n ? (\n

\n No artifacts yet. Drop an HTML or Markdown file above to create your\n first one.\n

\n )\n : (\n

\n ))}\n

\n )}\n\n {!props.readOnly && (\n \n )}\n

\n );\n}\n\nfunction Row(props: { a: Artifact; readOnly?: boolean }) {\n const a = props.a;\n return (\n

\n \n

\n {a.name}\n \n {a.kind === \"md\" ? \"MD\" : \"HTML\"}\n \n

\n by {a.createdBy} · /a/{a.id}\n

\n \n

\n \n open\n \n {props.readOnly\n ? (\n <>\n \n rename\n \n \n delete\n \n \n )\n : (\n <>\n

\n rename\n

\n \n \n \n save\n \n \n

\n \n \n delete\n \n \n \n )}\n

\n );\n}",[],[96,137],"cdb4cc12-92d2-416d-ab46-ad136c432475","examples","01a01be0-4031-7689-ba3a-05c7ed77db47",["D",1787174076294],[149,150,151],[144],{"_36":166,"_13":167,"_60":168,"_62":145,"_63":64,"_65":70,"_67":68,"_38":169,"_17":34,"_71":24,"_72":170,"_74":51,"_75":-5,"_89":171,"_18":172},{"_36":159,"_13":160,"_60":161,"_62":145,"_63":64,"_65":70,"_67":68,"_38":162,"_17":34,"_71":24,"_72":163,"_74":51,"_75":-5,"_89":164,"_18":165},{"_36":152,"_13":153,"_60":154,"_62":145,"_63":64,"_65":70,"_67":68,"_38":155,"_17":34,"_71":24,"_72":156,"_74":51,"_75":-5,"_89":157,"_18":158},"2e80b4a6-2a15-4999-9917-dc0e1bf8cf63","welcome.html","01a01be0-4031-7689-ba3a-03136df79e0c",["D",1787174076294],"\n\n\n \n \n Welcome\n \n\n\n

👋 This is an artifact

It's a single HTML file, hosted and shared from Val Town.

Make your own by dragging an .html file onto the dashboard.

\n\n\n",[],[144,153],"493b1e06-1bbf-462c-a929-2a5554195212","markdown-demo.md","01a01be0-4031-7689-ba39-fe49d862ceb7",["D",1787174076294],"# Welcome to Team Artifacts\n\nThis is a **Markdown** artifact. Drop a `.md` file on the dashboard and it\nrenders as a clean, readable page — no build step, no HTML required.\n\n## What renders\n\n- **Bold**, _italic_, and `inline code`\n- Lists, like this one\n- [Links](https://val.town) to anywhere\n- Tables, quotes, and fenced code blocks\n\n```ts\n// Code blocks get monospace styling.\nexport function hello(name: string) {\n return `Hi, ${name}!`;\n}\n```\n\n> Markdown artifacts render in the same sandboxed iframe as HTML ones, so the\n> security model is identical.\n\n| Format | Extension | Rendered as |\n| ------ | -------------- | ------------------------ |\n| HTML | `.html` | served as-is |\n| Markdown | `.md` / `.markdown` | converted to HTML |\n\nDelete this example whenever you like — it won't come back.\n",[],[144,160],"2aaf54cc-d9ec-4ea5-afa9-01fb435991f1","live-clock.html","01a01be0-4031-7689-ba39-f908feee3757",["D",1787174076294],"\n\n\n \n \n Live clock\n \n\n\n

--:--:--

This artifact runs JavaScript — inside a sandboxed frame.

\n \n

\n \n\n\n",[],[144,167],"6f5d4a68-bd2d-4b85-becc-c9e11633f3b5","backend","01a01be0-4031-7689-ba39-f6230036eaea",["D",1787174076294],[179,180],[174],{"_36":188,"_13":189,"_60":190,"_62":175,"_63":64,"_65":70,"_67":68,"_38":191,"_17":34,"_71":111,"_72":192,"_74":51,"_75":-5,"_89":193,"_18":194},{"_36":181,"_13":182,"_60":183,"_62":175,"_63":64,"_65":70,"_67":68,"_38":184,"_17":34,"_71":111,"_72":185,"_74":51,"_75":-5,"_89":186,"_18":187},"6ec90e16-dac5-4d15-935b-4df1c10f8f3f","render.ts","01a01be0-4031-7689-ba39-f072f50a38f6",["D",1787174076294],"import { marked } from \"npm:marked@12\";\nimport type { Artifact } from \"./db.ts\";\n\n// Minimal GitHub-ish styling so a bare Markdown doc reads nicely inside the\n// sandboxed iframe. The artifact still renders with an opaque origin (see the\n// CSP/sandbox in main.tsx), so this HTML is treated as untrusted either way.\nconst MD_STYLES = `\n :root { color-scheme: light dark; }\n body {\n font: 16px/1.6 -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Helvetica, Arial, sans-serif;\n max-width: 760px;\n margin: 0 auto;\n padding: 2.5rem 1.25rem 4rem;\n color: #1f2328;\n }\n h1, h2 { border-bottom: 1px solid #d1d9e0; padding-bottom: .3em; }\n h1, h2, h3, h4 { margin-top: 1.6em; line-height: 1.25; }\n a { color: #0969da; }\n code {\n background: rgba(129,139,152,.16);\n padding: .2em .4em;\n border-radius: 6px;\n font-size: 85%;\n }\n pre {\n background: #f6f8fa;\n padding: 1rem;\n border-radius: 8px;\n overflow: auto;\n }\n pre code { background: none; padding: 0; font-size: 100%; }\n blockquote {\n margin: 0;\n padding: 0 1em;\n color: #59636e;\n border-left: .25em solid #d1d9e0;\n }\n table { border-collapse: collapse; }\n th, td { border: 1px solid #d1d9e0; padding: 6px 13px; }\n img { max-width: 100%; }\n @media (prefers-color-scheme: dark) {\n body { color: #e6edf3; }\n h1, h2 { border-color: #3d444d; }\n a { color: #4493f8; }\n pre { background: #161b22; }\n blockquote { color: #9198a1; border-color: #3d444d; }\n th, td { border-color: #3d444d; }\n }\n`;\n\n/** The HTML to serve for an artifact, given its kind. */\nexport function renderArtifact(artifact: Artifact): string {\n if (artifact.kind !== \"md\") return artifact.html;\n const body = marked.parse(artifact.html, { gfm: true, breaks: false });\n const title = escapeHtml(artifact.name);\n return `\n\n\n\n\n${title}\n\n\n${body}\n`;\n}\n\nfunction escapeHtml(s: string): string {\n return s.replace(/[&<>\"]/g, (c) =>\n ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" }[c]!));\n}\n",[],[174,182],"7d65792d-6d4d-4975-9d92-433acf16fd47","db.ts","01a01be0-4031-7689-ba39-edac9463dca1",["D",1787174076294],"import { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { listFiles, readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n/** How the stored source should be rendered when viewed. */\nexport type ArtifactKind = \"html\" | \"md\";\n\nexport type Artifact = {\n id: string;\n name: string;\n /** Raw uploaded source, loaded from blob storage when fetching one artifact. */\n html: string;\n kind: ArtifactKind;\n createdBy: string;\n createdAt: number;\n};\n\nconst TABLE = \"artifacts_v2\";\nconst META = \"artifacts_meta_v1\";\nconst BLOB_PREFIX = \"artifacts/\";\n\nlet ready: Promise | null = null;\n\n/** Idempotent: creates storage and seeds examples once. */\nexport function initDb(): Promise {\n if (!ready) ready = setup();\n return ready;\n}\n\nasync function setup() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n blob_key TEXT NOT NULL UNIQUE,\n kind TEXT NOT NULL DEFAULT 'html',\n created_by TEXT NOT NULL,\n created_at INTEGER NOT NULL\n )`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${META} (key TEXT PRIMARY KEY, value TEXT NOT NULL)`,\n );\n await seedExamples();\n}\n\n// Seed example artifacts exactly once. Deterministic ids plus INSERT OR IGNORE\n// make concurrent cold starts safe.\nasync function seedExamples() {\n const seen = await sqlite.execute(`SELECT 1 FROM ${META} WHERE key = 'seeded'`);\n if (seen.rows.length) return;\n\n const files = await listFiles();\n const examples = files\n .filter((f: any) =>\n f.type === \"file\" && f.path.startsWith(\"examples/\") &&\n /\\.(html?|md|markdown)$/i.test(f.path)\n )\n .map((f: any) => f.path as string)\n .sort();\n\n for (const path of examples) {\n const source = await readFile(path);\n const kind: ArtifactKind = /\\.(md|markdown)$/i.test(path) ? \"md\" : \"html\";\n const name = path.replace(/^examples\\//, \"\").replace(/\\.(html?|md|markdown)$/i, \"\");\n const id = kind === \"md\" ? `ex_${name}_md` : `ex_${name}`;\n await storeArtifact({\n id,\n name,\n html: source,\n kind,\n createdBy: \"example\",\n createdAt: Date.now(),\n });\n }\n\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO ${META} (key, value) VALUES ('seeded', ?)`,\n args: [String(Date.now())],\n });\n}\n\nfunction newId() {\n return crypto.randomUUID().replace(/-/g, \"\").slice(0, 12);\n}\n\nfunction artifactKey(id: string, kind: ArtifactKind) {\n return `${BLOB_PREFIX}${id}.${kind === \"md\" ? \"md\" : \"html\"}`;\n}\n\nasync function storeArtifact(\n input: {\n id: string;\n name: string;\n html: string;\n kind: ArtifactKind;\n createdBy: string;\n createdAt: number;\n },\n) {\n const blobKey = artifactKey(input.id, input.kind);\n await blob.set(blobKey, input.html);\n try {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO ${TABLE} (id, name, blob_key, kind, created_by, created_at) VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n input.id,\n input.name,\n blobKey,\n input.kind,\n input.createdBy,\n input.createdAt,\n ],\n });\n } catch (error) {\n await blob.delete(blobKey);\n throw error;\n }\n}\n\nexport async function createArtifact(\n input: {\n name: string;\n html: string;\n kind: ArtifactKind;\n createdBy: string;\n },\n): Promise {\n const id = newId();\n await storeArtifact({ ...input, id, createdAt: Date.now() });\n return id;\n}\n\n/** List metadata only; artifact bodies stay in blob storage. */\nexport async function listArtifacts(): Promise {\n const { rows } = await sqlite.execute(\n `SELECT id, name, kind, created_by, created_at FROM ${TABLE} ORDER BY created_at DESC`,\n );\n return rows.map(toArtifact);\n}\n\nexport async function getArtifact(id: string): Promise {\n const { rows } = await sqlite.execute({\n sql:\n `SELECT id, name, blob_key, kind, created_by, created_at FROM ${TABLE} WHERE id = ?`,\n args: [id],\n });\n if (!rows.length) return null;\n const artifact = toArtifact(rows[0]);\n const source = await blob.get(rows[0].blob_key as string);\n return { ...artifact, html: await source.text() };\n}\n\nexport async function renameArtifact(id: string, name: string): Promise {\n const result = await sqlite.execute({\n sql: `UPDATE ${TABLE} SET name = ? WHERE id = ?`,\n args: [name, id],\n });\n return result.rowsAffected > 0;\n}\n\nexport async function deleteArtifact(id: string): Promise {\n const { rows } = await sqlite.execute({\n sql: `SELECT blob_key FROM ${TABLE} WHERE id = ?`,\n args: [id],\n });\n if (!rows.length) return;\n await blob.delete(rows[0].blob_key as string);\n await sqlite.execute({ sql: `DELETE FROM ${TABLE} WHERE id = ?`, args: [id] });\n}\n\nfunction toArtifact(r: any): Artifact {\n return {\n id: r.id as string,\n name: r.name as string,\n html: \"\",\n kind: (r.kind as ArtifactKind) ?? \"html\",\n createdBy: r.created_by as string,\n createdAt: Number(r.created_at),\n };\n}\n",[],[174,189],"07b94020-6885-4991-b086-21112c61d98c",["D",1787174076294],"legacyEnvVars","httpPrivacy","description","Host and share HTML and Markdown artifacts with your team","imageUrl","userId","5d1042a9-7b0b-499d-8a72-3a8ac7a4e185","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","5f80108f-7ca4-4327-b77b-089dbe4b5a82","tursoName","07b9402068854991b08621112c61d98c","tursoHostname","07b9402068854991b08621112c61d98c-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789521640046],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_241":237},"org",{"_11":12,"_235":-5,"_236":237,"_202":203,"_238":239,"_240":51},"branch",{"_17":66,"_13":16,"_36":64,"_42":195,"_45":37,"_46":44,"_232":53,"_233":43,"_234":57,"_58":14,"_54":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://secure.gravatar.com/avatar/0129a541b7b3574e92c4afd06c5e32da&d=identicon","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":195,"_13":14,"_38":322,"_49":-5,"_197":51,"_52":53,"_198":53,"_199":200,"_201":-5,"_202":203,"_204":84,"_205":68,"_206":-5,"_207":-5,"_208":34,"_56":209,"_210":211,"_212":213,"_214":323,"_216":-5,"_217":218,"_219":218,"_220":221,"_222":221,"_223":221,"_224":218,"_225":218,"_226":324,"_228":325,"_230":326,"_50":51},[277,280,284,290,291],"files",[277,278,279,280,281,282,283,284,285,286,287,288,289,290,291],"counts",{"_268":34,"_269":70,"_270":34,"_35":271,"_272":273},[],{"_36":59,"_13":19,"_60":61,"_62":-5,"_63":64,"_65":66,"_67":68,"_38":69,"_17":70,"_71":24,"_72":73,"_74":51,"_75":-5,"_18":267},"upstreamProject",{"_36":43,"_13":14,"_199":200,"_201":-5,"_52":53,"_226":265},"upstreamBranch",{"_36":37,"_38":263,"_40":264,"_13":16,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":55,"_56":57,"_58":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1781376559305],["D",1786052184563],{"_11":55,"_241":266},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789588383&sig=06604447a2cf9a076e2f692010042678a0587429b132b22286d6aea764ad194b",[19],"pulls","branches","forks",{"_274":70,"_276":34},"connections",{"_274":34,"_275":34},"count","unfilledCount","emptyCount",{"_36":173,"_13":174,"_60":175,"_62":-5,"_63":64,"_65":70,"_67":68,"_38":176,"_17":34,"_71":99,"_72":-5,"_74":51,"_75":-5,"_89":320,"_18":321},{"_36":188,"_13":189,"_60":190,"_62":175,"_63":64,"_65":70,"_67":68,"_38":191,"_17":34,"_71":111,"_72":192,"_74":51,"_75":-5,"_89":318,"_18":319},{"_36":181,"_13":182,"_60":183,"_62":175,"_63":64,"_65":70,"_67":68,"_38":184,"_17":34,"_71":111,"_72":185,"_74":51,"_75":-5,"_89":316,"_18":317},{"_36":143,"_13":144,"_60":145,"_62":-5,"_63":64,"_65":70,"_67":68,"_38":146,"_17":34,"_71":99,"_72":-5,"_74":51,"_75":-5,"_89":314,"_18":315},{"_36":166,"_13":167,"_60":168,"_62":145,"_63":64,"_65":70,"_67":68,"_38":169,"_17":34,"_71":24,"_72":170,"_74":51,"_75":-5,"_89":312,"_18":313},{"_36":159,"_13":160,"_60":161,"_62":145,"_63":64,"_65":70,"_67":68,"_38":162,"_17":34,"_71":24,"_72":163,"_74":51,"_75":-5,"_89":310,"_18":311},{"_36":152,"_13":153,"_60":154,"_62":145,"_63":64,"_65":70,"_67":68,"_38":155,"_17":34,"_71":24,"_72":156,"_74":51,"_75":-5,"_89":308,"_18":309},{"_36":95,"_13":96,"_60":97,"_62":-5,"_63":64,"_65":70,"_67":68,"_38":98,"_17":34,"_71":99,"_72":-5,"_74":51,"_75":-5,"_89":306,"_18":307},{"_36":136,"_13":137,"_60":138,"_62":97,"_63":64,"_65":70,"_67":68,"_38":139,"_17":34,"_71":111,"_72":140,"_74":51,"_75":-5,"_89":304,"_18":305},{"_36":129,"_13":130,"_60":131,"_62":97,"_63":64,"_65":70,"_67":68,"_38":132,"_17":34,"_71":111,"_72":133,"_74":51,"_75":-5,"_89":302,"_18":303},{"_36":122,"_13":123,"_60":124,"_62":97,"_63":64,"_65":70,"_67":68,"_38":125,"_17":34,"_71":111,"_72":126,"_74":51,"_75":-5,"_89":300,"_18":301},{"_36":115,"_13":116,"_60":117,"_62":97,"_63":64,"_65":70,"_67":68,"_38":118,"_17":34,"_71":111,"_72":119,"_74":51,"_75":-5,"_89":298,"_18":299},{"_36":107,"_13":108,"_60":109,"_62":97,"_63":64,"_65":70,"_67":68,"_38":110,"_17":34,"_71":111,"_72":112,"_74":51,"_75":-5,"_89":296,"_18":297},{"_36":59,"_13":19,"_60":61,"_62":-5,"_63":64,"_65":66,"_67":68,"_38":92,"_17":70,"_71":24,"_72":73,"_74":51,"_75":-5,"_89":294,"_18":295},{"_36":82,"_13":83,"_60":84,"_62":-5,"_63":64,"_65":32,"_67":68,"_38":85,"_17":86,"_71":87,"_72":88,"_74":51,"_75":-5,"_89":292,"_18":293},[],[83],[],[19],[],[96,108],[],[96,116],[],[96,123],[],[96,130],[],[96,137],[285,286,287,288,289],[96],[],[144,153],[],[144,160],[],[144,167],[281,282,283],[144],[],[174,182],[],[174,189],[278,279],[174],["D",1787174076294],["D",1789521640046],{"_11":12,"_241":237},{"_11":12,"_235":-5,"_236":237,"_202":203,"_238":239,"_240":51},{"_17":66,"_13":16,"_36":64,"_42":195,"_45":37,"_46":44,"_232":53,"_233":43,"_234":57,"_58":14,"_54":12},"ctx",{"_226":-5,"_260":360,"_361":362,"_363":364,"_365":51,"_366":51,"_367":51,"_368":68,"_369":-5,"_370":-7,"_371":-7,"_372":34,"_373":51,"_374":51,"_375":-5,"_376":51,"_377":51,"_378":51,"_379":-5},"ENV",{"_331":332,"_333":334,"_335":16,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359},"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"]