📬 Check your email

\n We sent a sign-in link to {email}.\n

\n );\n }\n\n return (\n

\n \n Email\n setEmail((e.target as HTMLInputElement).value)}\n placeholder=\"you@example.com\"\n class=\"mt-1 block w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500 outline-none\"\n disabled={status === \"sending\"}\n />\n \n \n {status === \"sending\" ? \"Sending…\" : \"Send magic link\"}\n \n {status === \"error\" && (\n

{errorMsg}

\n )}\n \n );\n}\n","label",[158,159,68],"frontend","components","pulls","branches","forks","envVars",{"_167":26,"_169":26},"connections",{"_167":26,"_168":26},"count","unfilledCount","emptyCount",{"_32":291,"_13":275,"_66":270,"_42":-5,"_34":35,"_151":39,"_152":88,"_36":292,"_38":26,"_69":245,"_154":-5,"_71":24,"_156":-5,"_193":293,"_17":294},{"_32":284,"_13":285,"_66":286,"_42":270,"_34":35,"_151":39,"_152":88,"_36":287,"_38":26,"_69":70,"_154":288,"_71":24,"_156":-5,"_193":289,"_17":290},{"_32":276,"_13":277,"_66":278,"_42":270,"_34":35,"_151":279,"_152":88,"_36":280,"_38":26,"_69":70,"_154":281,"_71":24,"_156":-5,"_193":282,"_17":283},{"_32":267,"_13":268,"_66":269,"_42":270,"_34":35,"_151":190,"_152":88,"_36":271,"_38":39,"_69":70,"_154":272,"_71":24,"_156":-5,"_193":273,"_17":274},{"_32":263,"_13":158,"_66":206,"_42":-5,"_34":35,"_151":39,"_152":88,"_36":264,"_38":26,"_69":245,"_154":-5,"_71":24,"_156":-5,"_193":265,"_17":266},{"_32":259,"_13":159,"_66":150,"_42":206,"_34":35,"_151":39,"_152":88,"_36":260,"_38":26,"_69":245,"_154":-5,"_71":24,"_156":-5,"_193":261,"_17":262},{"_32":251,"_13":252,"_66":253,"_42":150,"_34":35,"_151":254,"_152":88,"_36":255,"_38":39,"_69":70,"_154":256,"_71":24,"_156":-5,"_193":257,"_17":258},{"_32":149,"_13":68,"_66":67,"_42":150,"_34":35,"_151":39,"_152":88,"_36":248,"_38":26,"_69":70,"_154":155,"_71":24,"_156":-5,"_193":249,"_17":250},{"_32":243,"_13":235,"_66":229,"_42":206,"_34":35,"_151":39,"_152":88,"_36":244,"_38":26,"_69":245,"_154":-5,"_71":24,"_156":-5,"_193":246,"_17":247},{"_32":236,"_13":237,"_66":238,"_42":229,"_34":35,"_151":39,"_152":88,"_36":239,"_38":26,"_69":70,"_154":240,"_71":24,"_156":-5,"_193":241,"_17":242},{"_32":226,"_13":227,"_66":228,"_42":229,"_34":35,"_151":230,"_152":88,"_36":231,"_38":26,"_69":70,"_154":232,"_71":24,"_156":-5,"_193":233,"_17":234},{"_32":219,"_13":220,"_66":221,"_42":206,"_34":35,"_151":39,"_152":88,"_36":222,"_38":26,"_69":21,"_154":223,"_71":24,"_156":-5,"_193":224,"_17":225},{"_32":211,"_13":212,"_66":213,"_42":206,"_34":35,"_151":214,"_152":88,"_36":215,"_38":39,"_69":21,"_154":216,"_71":24,"_156":-5,"_193":217,"_17":218},{"_32":203,"_13":204,"_66":205,"_42":206,"_34":35,"_151":39,"_152":88,"_36":207,"_38":26,"_69":70,"_154":208,"_71":24,"_156":-5,"_193":209,"_17":210},{"_32":196,"_13":197,"_66":198,"_42":-5,"_34":35,"_151":39,"_152":88,"_36":199,"_38":26,"_69":21,"_154":200,"_71":24,"_156":-5,"_193":201,"_17":202},{"_32":186,"_13":187,"_66":86,"_42":-5,"_34":35,"_151":188,"_152":88,"_36":189,"_38":190,"_69":191,"_154":192,"_71":24,"_156":14,"_193":194,"_17":195},"695151b4-ffc6-4b38-88c7-d053dc69ed71","index.ts",5,["D",1788584206446],2,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { auth } from \"./backend/auth.ts\";\nimport { ensureSchema } from \"./backend/schema.ts\";\nimport {\n createPost,\n deletePost,\n getPostBySlug,\n listPosts,\n updatePost,\n} from \"./backend/posts.ts\";\n\n// Create Better Auth's tables on first run. Idempotent (CREATE TABLE IF NOT EXISTS).\nawait ensureSchema();\n\nconst app = new Hono<{\n Variables: {\n user: typeof auth.$Infer.Session.user | null;\n session: typeof auth.$Infer.Session.session | null;\n };\n}>();\n\n// Mount Better Auth — handles /api/auth/sign-in/magic-link, /api/auth/get-session, etc.\napp.on([\"GET\", \"POST\"], \"/api/auth/*\", (c) => auth.handler(c.req.raw));\n\n// Make the session available to downstream routes via c.get(\"user\") / c.get(\"session\").\napp.use(\"*\", async (c, next) => {\n const session = await auth.api.getSession({ headers: c.req.raw.headers });\n c.set(\"user\", session?.user ?? null);\n c.set(\"session\", session?.session ?? null);\n await next();\n});\n\n// Example protected route — fetch from the frontend to get the current user.\napp.get(\"/api/me\", (c) => {\n const user = c.get(\"user\");\n if (!user) return c.json({ error: \"Not authenticated\" }, 401);\n return c.json({ user });\n});\n\n// --- Blog API -------------------------------------------------------------\n\n// Public: list all posts.\napp.get(\"/api/posts\", async (c) => {\n const posts = await listPosts();\n return c.json({ posts });\n});\n\n// Public: fetch a single post by slug.\napp.get(\"/api/posts/:slug\", async (c) => {\n const post = await getPostBySlug(c.req.param(\"slug\"));\n if (!post) return c.json({ error: \"Not found\" }, 404);\n return c.json({ post });\n});\n\nfunction requireUser(c: {\n get: (v: \"user\") => unknown;\n json: (body: object, status?: number) => Response;\n}) {\n const user = c.get(\"user\") as {\n id: string;\n email: string;\n name: string;\n } | null;\n if (!user) return null;\n return { id: user.id, name: user.name || user.email };\n}\n\n// Protected: create a post.\napp.post(\"/api/posts\", async (c) => {\n const me = requireUser(c);\n if (!me) return c.json({ error: \"Authentication required\" }, 401);\n\n const body = await c.req.json().catch(() => null);\n const title = (body?.title ?? \"\").toString().trim();\n const content = (body?.content ?? \"\").toString().trim();\n if (!title || !content) {\n return c.json({ error: \"title and content are required\" }, 400);\n }\n\n const post = await createPost({\n title,\n content,\n authorId: me.id,\n authorName: me.name,\n });\n return c.json({ post }, 201);\n});\n\n// Protected: update a post.\napp.put(\"/api/posts/:slug\", async (c) => {\n const me = requireUser(c);\n if (!me) return c.json({ error: \"Authentication required\" }, 401);\n\n const body = await c.req.json().catch(() => null);\n const title = (body?.title ?? \"\").toString().trim();\n const content = (body?.content ?? \"\").toString().trim();\n if (!title || !content) {\n return c.json({ error: \"title and content are required\" }, 400);\n }\n\n const post = await updatePost(c.req.param(\"slug\"), { title, content });\n if (!post) return c.json({ error: \"Not found\" }, 404);\n return c.json({ post });\n});\n\n// Protected: delete a post.\napp.delete(\"/api/posts/:slug\", async (c) => {\n const me = requireUser(c);\n if (!me) return c.json({ error: \"Authentication required\" }, 401);\n\n const ok = await deletePost(c.req.param(\"slug\"));\n if (!ok) return c.json({ error: \"Not found\" }, 404);\n return c.json({ ok: true });\n});\n\n// Serve the frontend\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Unwrap and rethrow Hono errors as the original error so we get real stack traces.\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[187],"b52977e4-55af-4b36-8200-09227b5d3bcf","README.md","01a06fec-b7fb-75ad-bf57-3366e614e1ec",["D",1788584179632],"# Better Auth Starter\n\nMagic-link authentication for Val Town, powered by\n[Better Auth](https://better-auth.com). Click **Remix** and you have a working\nauth-protected app — no setup required.\n\nIt uses [Val Town SQLite](https://docs.val.town/std/sqlite/) for the\nuser/session database and [Val Town Email](https://docs.val.town/std/email/) to\nsend the magic links. **Sending magic links to anyone other than yourself\nrequires [Val Town Pro](https://www.val.town/pricing).**\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Browser -->|\"/api/auth/*\"| BA[\"Better Auth
handler\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|useSession| Client[\"auth-client.ts\"]\n Client -->|fetch| BA\n BA -->|reads/writes| SQLite[(\"std/sqlite\")]\n BA -->|sends magic link| Email[\"std/email\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono entrypoint; mounts Better Auth at /api/auth/*\nbackend/\n auth.ts ← Better Auth instance (server)\n schema.ts ← Creates the user/session/account/verification tables\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n lib/\n auth-client.ts ← Better Auth React client (useSession, signIn, signOut)\n components/\n App.tsx ← Root: shows or based on session\n SignIn.tsx ← Email form that calls signIn.magicLink\n Dashboard.tsx ← Signed-in view with sign-out button\n```\n\n## How auth works\n\n1. User enters their email and submits the form. The client calls\n `authClient.signIn.magicLink({ email })`, which `POST`s to\n `/api/auth/sign-in/magic-link`.\n2. Better Auth generates a token, stores it in the `verification` table, and\n calls our `sendMagicLink` callback in `backend/auth.ts`. The callback uses\n `std/email` to send the link.\n3. User clicks the link, which opens `/api/auth/magic-link/verify?token=…`.\n Better Auth validates the token, creates a row in `session`, sets a secure\n cookie, and redirects to `/`.\n4. Back in React, `useSession()` re-fetches `/api/auth/get-session`, the user\n object becomes available, and `` renders ``.\n\n## Adding more auth methods\n\nBetter Auth has a rich [plugin ecosystem](https://better-auth.com/docs/plugins).\nCommon next steps:\n\n- **Email + password** — flip `emailAndPassword.enabled` to `true` in\n `backend/auth.ts`. No plugin needed.\n- **Social login (Google, GitHub, …)** — add `socialProviders` to your auth\n config and store the client IDs/secrets as env vars. See the\n [social providers docs](https://better-auth.com/docs/concepts/social-providers).\n- **Passkeys, 2FA, organizations** — add the relevant plugin on the server and\n the matching client plugin in `frontend/lib/auth-client.ts`.\n\nAfter enabling new methods, you may need new database columns. See the\n[database concepts](https://better-auth.com/docs/concepts/database) page — for\nSQLite you'll add the columns directly to `backend/schema.ts`.\n\n## Production checklist\n\n- [ ] Set the **`BETTER_AUTH_SECRET`** env var to a random string from\n [`generate-random-signing-key.val.run`](https://generate-random-signing-key.val.run/).\n- [ ] Narrow `baseURL.allowedHosts` in `backend/auth.ts` to the exact hosts you\n serve from (e.g. `[\"myapp.com\", \"*.web.val.run\"]`).\n- [ ] Make sure your Val Town account is on [Pro](https://www.val.town/pricing)\n so emails can be sent to addresses other than your own.\n\n## Notes\n\n- The session cookie defaults to 7 days and refreshes itself.\n- Magic-link tokens expire after 5 minutes and are single-use by default.\n- Better Auth uses Kysely under the hood — Val Town's `std/sqlite` is already an\n `@libsql/client` Client, so we hand it straight to `LibsqlDialect`. Zero\n database setup.",[],[197],"8554961e-cf91-44e4-b4b5-9db0dfb7b56c","index.tsx","01a06fec-b7fb-75ad-bf57-28e84ed814d4","01a06fec-b7fb-75ad-bf57-2c4cad9dcb25",["D",1788584179632],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[158,204],"aafed451-e48c-49da-b5df-f3ab2a144eab","index.html","01a06fec-b7fb-75ad-bf57-2615e62e9ddf",8,["D",1788584331032],"\n\n \n \n \n My Blog\n \n \n \n \n

\n \n \n \n",[],[158,212],"311d1901-f05a-4ccc-a11a-4d2452a8a8b4","favicon.svg","01a06fec-b7fb-75ad-bf57-23d59d33d8d1",["D",1788584179632],"\n",[],[158,220],"6b8f3ac7-a948-4f9f-91bb-437bd263600e","posts-api.ts","6e6c1f60-a8e6-11f1-96f4-1607ee4eb77e","01a06fec-b7fb-75ad-bf57-1e352179a53d",6,["D",1788584307345],"export type Post = {\n id: string;\n title: string;\n slug: string;\n content: string;\n authorId: string;\n authorName: string;\n createdAt: number;\n updatedAt: number;\n};\n\nasync function handle(res: Response): Promise {\n if (!res.ok) {\n let msg = `Request failed (${res.status})`;\n try {\n const data = await res.json();\n msg = data?.error ?? msg;\n } catch {\n /* keep default */\n }\n throw new Error(msg);\n }\n return res.json() as Promise;\n}\n\nexport function fetchPosts(): Promise<{ posts: Post[] }> {\n return fetch(\"/api/posts\").then((r) => handle(r));\n}\n\nexport function fetchPost(slug: string): Promise<{ post: Post }> {\n return fetch(`/api/posts/${encodeURIComponent(slug)}`).then((r) => handle(r));\n}\n\nexport function createPostAPI(title: string, content: string): Promise<{ post: Post }> {\n return fetch(\"/api/posts\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ title, content }),\n }).then((r) => handle(r));\n}\n\nexport function updatePostAPI(\n slug: string,\n title: string,\n content: string,\n): Promise<{ post: Post }> {\n return fetch(`/api/posts/${encodeURIComponent(slug)}`, {\n method: \"PUT\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ title, content }),\n }).then((r) => handle(r));\n}\n\nexport function deletePostAPI(slug: string): Promise<{ ok: boolean }> {\n return fetch(`/api/posts/${encodeURIComponent(slug)}`, {\n method: \"DELETE\",\n }).then((r) => handle(r));\n}\n",[],[158,235,227],"lib","2a4190b7-a85d-48ee-b62f-a5a28d7ee901","auth-client.ts","01a06fec-b7fb-75ad-bf57-184f5fe0d830",["D",1788584179632],"import { createAuthClient } from \"https://esm.sh/better-auth@1.6.9/react?deps=react@18.2.0,react-dom@18.2.0\";\nimport { magicLinkClient } from \"https://esm.sh/better-auth@1.6.9/client/plugins?deps=react@18.2.0,react-dom@18.2.0\";\n\n// Base URL is the same origin as the page, so we don't need to set it.\n// Plugins must mirror the server-side plugins enabled in backend/auth.ts.\nexport const authClient = createAuthClient({\n plugins: [magicLinkClient()],\n});\n\nexport const { useSession, signIn, signOut } = authClient;\n",[],[158,235,237],"8d84be30-b8aa-432f-b881-ba5f3376f20b",["D",1788584179632],"directory",[179,180],[158,235],["D",1788584179632],[],[158,159,68],"8d2e41a9-c4b6-4f74-86a5-fb2c23a03652","App.tsx","01a06fec-b7fb-75ad-bf57-08e711dc7f93",7,["D",1788584327128],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { marked } from \"https://esm.sh/marked@18.0\";\nimport { useSession, signOut } from \"../lib/auth-client.ts\";\nimport { SignIn } from \"./SignIn.tsx\";\nimport {\n createPostAPI,\n deletePostAPI,\n fetchPost,\n fetchPosts,\n updatePostAPI,\n type Post,\n} from \"../lib/posts-api.ts\";\n\ntype View = { name: \"list\" } | { name: \"post\"; slug: string } | { name: \"edit\"; post?: Post };\n\nfunction fmtDate(ms: number): string {\n return new Date(ms).toLocaleString();\n}\n\nfunction renderMarkdown(content: string): string {\n return marked.parse(content, { async: false }) as string;\n}\n\nexport function App() {\n const { data: session, isPending } = useSession();\n const user = session?.user ?? null;\n\n const [posts, setPosts] = useState([]);\n const [view, setView] = useState({ name: \"list\" });\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n async function refresh() {\n setLoading(true);\n setError(null);\n try {\n const { posts } = await fetchPosts();\n setPosts(posts);\n } catch (e) {\n setError((e as Error).message);\n } finally {\n setLoading(false);\n }\n }\n\n useEffect(() => {\n refresh();\n }, []);\n\n async function openPost(slug: string) {\n setError(null);\n try {\n await fetchPost(slug);\n setView({ name: \"post\", slug });\n } catch (e) {\n setError((e as Error).message);\n }\n }\n\n async function handleDelete(slug: string) {\n if (!confirm(\"Delete this post?\")) return;\n try {\n await deletePostAPI(slug);\n await refresh();\n setView({ name: \"list\" });\n } catch (e) {\n setError((e as Error).message);\n }\n }\n\n async function handleSave(title: string, content: string, existing?: Post) {\n if (existing) {\n const { post } = await updatePostAPI(existing.slug, title, content);\n await refresh();\n setView({ name: \"post\", slug: post.slug });\n } else {\n const { post } = await createPostAPI(title, content);\n await refresh();\n setView({ name: \"post\", slug: post.slug });\n }\n }\n\n return (\n

\n \n\n

\n {isPending ? null : user ? (\n <>\n {user.email}\n signOut().then(() => location.reload())}\n class=\"text-sm bg-gray-100 hover:bg-gray-200 text-gray-800 px-3 py-1.5 rounded-lg cursor-pointer\"\n >\n Sign out\n \n \n ) : (\n setView({ name: \"list\" })}\n class=\"text-sm bg-blue-500 hover:bg-blue-600 text-white px-3 py-1.5 rounded-lg cursor-pointer\"\n >\n Sign in to write\n \n )}\n

\n\n {/* Sign-in panel shown when logged out */}\n {!isPending && !user && (\n

\n 🔐 Sign in to publish, edit, or delete posts\n

\n \n

\n )}\n\n {error && (\n

\n {error}\n

\n )}\n\n {view.name === \"edit\" && user ? (\n setView({ name: \"list\" })} onSave={handleSave} />\n ) : (\n <>\n {user && view.name === \"list\" && (\n setView({ name: \"edit\" })}\n class=\"mb-6 bg-emerald-500 hover:bg-emerald-600 text-white font-medium px-4 py-2 rounded-lg cursor-pointer\"\n >\n ＋ New post\n \n )}\n\n {/* Post detail */}\n {view.name === \"post\" ? (\n setView({ name: \"edit\", post })}\n onDelete={handleDelete}\n onBack={() => setView({ name: \"list\" })}\n onNotFound={() => setView({ name: \"list\" })}\n />\n ) : (\n \n )}\n \n )}\n\n \n

\n );\n}\n\nfunction PostList({\n posts,\n loading,\n onOpen,\n}: {\n posts: Post[];\n loading: boolean;\n onOpen: (slug: string) => void;\n}) {\n if (loading) return

Loading…

;\n if (posts.length === 0) {\n return (\n

\n No posts yet. Sign in and write the first one! 🚀\n

\n );\n }\n return (\n

\n onOpen(p.slug)}\n class=\"w-full text-left bg-white border border-gray-200 hover:border-blue-300 rounded-lg p-4 transition-colors cursor-pointer\"\n >\n
{p.title}
\n
\n {p.authorName} · {fmtDate(p.createdAt)}\n
\n \n

\n );\n}\n\nfunction PostView({\n slug,\n user,\n onEdit,\n onDelete,\n onBack,\n onNotFound,\n}: {\n slug: string;\n user: { id: string } | null;\n onEdit: (post: Post) => void;\n onDelete: (slug: string) => void;\n onBack: () => void;\n onNotFound: () => void;\n}) {\n const [post, setPost] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n let alive = true;\n setLoading(true);\n setError(null);\n fetchPost(slug)\n .then(({ post }) => alive && setPost(post))\n .catch((e) => {\n if (!alive) return;\n setError((e as Error).message);\n if ((e as Error).message.includes(\"404\")) onNotFound();\n })\n .finally(() => alive && setLoading(false));\n return () => {\n alive = false;\n };\n }, [slug]);\n\n const isAuthor = post && user && post.authorId === user.id;\n\n return (\n

\n \n {loading ? (\n

Loading…

\n ) : error && !post ? (\n

{error}

\n ) : post ? (\n

{post.title}

\n {post.authorName} · {fmtDate(post.createdAt)}\n

\n {isAuthor && (\n

\n onEdit(post)}\n class=\"text-sm bg-gray-100 hover:bg-gray-200 text-gray-800 px-3 py-1.5 rounded-lg cursor-pointer\"\n >\n Edit\n \n onDelete(post.slug)}\n class=\"text-sm bg-red-50 hover:bg-red-100 text-red-700 px-3 py-1.5 rounded-lg cursor-pointer\"\n >\n Delete\n \n

\n )}\n \n

\n ) : null}\n

\n );\n}\n\nfunction Editor({\n initial,\n onCancel,\n onSave,\n}: {\n initial?: Post;\n onCancel: () => void;\n onSave: (title: string, content: string, existing?: Post) => Promise;\n}) {\n const [title, setTitle] = useState(initial?.title ?? \"\");\n const [content, setContent] = useState(initial?.content ?? \"\");\n const [saving, setSaving] = useState(false);\n const [error, setError] = useState(null);\n\n async function submit(e: React.FormEvent) {\n e.preventDefault();\n setSaving(true);\n setError(null);\n try {\n await onSave(title.trim(), content.trim(), initial);\n } catch (err) {\n setError((err as Error).message);\n setSaving(false);\n }\n }\n\n return (\n

\n setTitle((e.target as HTMLInputElement).value)}\n placeholder=\"Post title\"\n required\n class=\"w-full px-3 py-2 border border-gray-300 rounded-lg text-lg font-medium focus:ring-2 focus:ring-blue-500 outline-none\"\n />\n setContent((e.target as HTMLTextAreaElement).value)}\n placeholder={\"Write in Markdown…\\n\\n## Subheading\\nSome text with **bold** and *italic*.\"}\n required\n rows={14}\n class=\"w-full px-3 py-2 border border-gray-300 rounded-lg font-mono text-sm focus:ring-2 focus:ring-blue-500 outline-none\"\n />\n {error &&

{error}

}\n

\n \n {saving ? \"Saving…\" : initial ? \"Save changes\" : \"Publish\"}\n \n \n Cancel\n \n

\n \n );\n}\n",[],[158,159,252],"19194379-a8d7-42b0-bbfa-f5401e8aa3b3",["D",1788584179632],[176,177],[158,159],"c0038934-ea0e-4300-ad3e-804c4082a78e",["D",1788584179632],[175,178,181,182,183],[158],"afee3e24-a29b-42f2-af14-dcdcb2f634ae","schema.ts","01a06fec-b7fb-75ad-bf57-0115a7ffa84a","01a06fec-b7fb-75ad-bf57-07a9767a08a3",["D",1788584196600],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Better Auth's standard SQLite schema for core auth + magic link.\n// Magic link uses the `verification` table — no extra plugin tables needed.\n//\n// We run this on startup so the template works with zero setup.\n// Better Auth manages all reads/writes via Kysely; we just ensure the tables exist.\nexport async function ensureSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS user (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n emailVerified INTEGER NOT NULL DEFAULT 0,\n image TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS session (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n token TEXT NOT NULL UNIQUE,\n expiresAt INTEGER NOT NULL,\n ipAddress TEXT,\n userAgent TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS account (\n id TEXT PRIMARY KEY,\n userId TEXT NOT NULL REFERENCES user(id) ON DELETE CASCADE,\n accountId TEXT NOT NULL,\n providerId TEXT NOT NULL,\n accessToken TEXT,\n refreshToken TEXT,\n accessTokenExpiresAt INTEGER,\n refreshTokenExpiresAt INTEGER,\n scope TEXT,\n idToken TEXT,\n password TEXT,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS verification (\n id TEXT PRIMARY KEY,\n identifier TEXT NOT NULL,\n value TEXT NOT NULL,\n expiresAt INTEGER NOT NULL,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n `CREATE TABLE IF NOT EXISTS post (\n id TEXT PRIMARY KEY,\n title TEXT NOT NULL,\n slug TEXT NOT NULL UNIQUE,\n content TEXT NOT NULL,\n authorId TEXT NOT NULL,\n authorName TEXT NOT NULL,\n createdAt INTEGER NOT NULL,\n updatedAt INTEGER NOT NULL\n )`,\n ]);\n}\n",[],[275,268],"backend","341c8106-a86a-4bbd-8fd5-d5592ab3b73a","posts.ts","2c6ef7c2-a8e6-11f1-b70e-1607ee4eb77e",3,["D",1788584196649],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type Post = {\n id: string;\n title: string;\n slug: string;\n content: string;\n authorId: string;\n authorName: string;\n createdAt: number;\n updatedAt: number;\n};\n\ntype Row = {\n id: string;\n title: string;\n slug: string;\n content: string;\n authorId: string;\n authorName: string;\n createdAt: number;\n updatedAt: number;\n};\n\nfunction toPost(r: Row): Post {\n return {\n id: r.id,\n title: r.title,\n slug: r.slug,\n content: r.content,\n authorId: r.authorId,\n authorName: r.authorName,\n createdAt: Number(r.createdAt),\n updatedAt: Number(r.updatedAt),\n };\n}\n\n// Turn a title into a URL slug: lowercase, hyphens, strip non-alphanumerics.\nexport function slugify(title: string): string {\n const base = title\n .toLowerCase()\n .trim()\n .replace(/[^a-z0-9\\u3040-\\u30ff\\u4e00-\\u9faf]+/g, \"-\")\n .replace(/^-+|-+$/g, \"\")\n .slice(0, 80);\n return base || \"post\";\n}\n\n// Ensure a slug is unique by appending -2, -3, … when needed.\nasync function uniqueSlug(slug: string, excludeId?: string): Promise {\n const existing = await sqlite.execute({\n sql: \"SELECT slug FROM post WHERE slug = ? AND id != ?\",\n args: [slug, excludeId ?? \"\"],\n });\n if (existing.rows.length === 0) return slug;\n let n = 2;\n while (true) {\n const candidate = `${slug}-${n}`;\n const clash = await sqlite.execute({\n sql: \"SELECT slug FROM post WHERE slug = ? AND id != ?\",\n args: [candidate, excludeId ?? \"\"],\n });\n if (clash.rows.length === 0) return candidate;\n n++;\n }\n}\n\nexport async function listPosts(): Promise {\n const res = await sqlite.execute(\n \"SELECT * FROM post ORDER BY createdAt DESC\",\n );\n return (res.rows as unknown as Row[]).map(toPost);\n}\n\nexport async function getPostBySlug(slug: string): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT * FROM post WHERE slug = ?\",\n args: [slug],\n });\n const rows = res.rows as unknown as Row[];\n return rows.length ? toPost(rows[0]) : null;\n}\n\nexport async function createPost(args: {\n title: string;\n content: string;\n authorId: string;\n authorName: string;\n}): Promise {\n const now = Date.now();\n const id = crypto.randomUUID();\n const slug = await uniqueSlug(slugify(args.title));\n await sqlite.execute({\n sql:\n \"INSERT INTO post (id, title, slug, content, authorId, authorName, createdAt, updatedAt) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\",\n args: [\n id,\n args.title,\n slug,\n args.content,\n args.authorId,\n args.authorName,\n now,\n now,\n ],\n });\n return toPost({\n id,\n title: args.title,\n slug,\n content: args.content,\n authorId: args.authorId,\n authorName: args.authorName,\n createdAt: now,\n updatedAt: now,\n });\n}\n\nexport async function updatePost(\n slug: string,\n args: { title: string; content: string },\n): Promise {\n const existing = await getPostBySlug(slug);\n if (!existing) return null;\n const newSlug = await uniqueSlug(slugify(args.title), existing.id);\n const now = Date.now();\n await sqlite.execute({\n sql: \"UPDATE post SET title = ?, slug = ?, content = ?, updatedAt = ? WHERE id = ?\",\n args: [args.title, newSlug, args.content, now, existing.id],\n });\n return {\n ...existing,\n title: args.title,\n slug: newSlug,\n content: args.content,\n updatedAt: now,\n };\n}\n\nexport async function deletePost(slug: string): Promise {\n const res = await sqlite.execute({\n sql: \"DELETE FROM post WHERE slug = ?\",\n args: [slug],\n });\n return (res.rowsAffected ?? 0) > 0;\n}\n",[],[275,277],"560c8c93-63dd-40ff-bcc8-62faf2bb9d56","auth.ts","01a06fec-b7fa-775f-a0ab-6a7374506016",["D",1788584179632],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\nimport { httpEndpoint, parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { betterAuth } from \"npm:better-auth\";\nimport { magicLink } from \"npm:better-auth/plugins\";\nimport { LibsqlDialect } from \"npm:@libsql/kysely-libsql\";\n\n// Vals can be reached from multiple URLs (the *.web.val.run preview URL,\n// custom domains, branch deploys, etc). Better Auth's dynamic baseURL form\n// derives the URL from each incoming request and validates it against\n// allowedHosts. The fallback is used when running outside an HTTP context\n// (e.g. cron jobs, scripts).\nconst fallback = await httpEndpoint();\n\n// A secret is required to sign session tokens. We default to a per-val auto\n// secret so the template works with zero setup — but for production you should\n// set BETTER_AUTH_SECRET so sessions survive code edits across val versions.\nconst { username, name } = parseVal();\nconst secret =\n Deno.env.get(\"BETTER_AUTH_SECRET\") ?? `val-town-default-${username}-${name}`;\n\n// Val Town's `std/sqlite` is already an `@libsql/client` Client,\n// so we can hand it straight to Better Auth's Kysely libsql dialect.\n// Zero database setup required.\nexport const auth = betterAuth({\n baseURL: {\n // Accept any host so this works on the *.web.val.run preview URL,\n // custom domains, and any future deployment URL. For production you\n // should narrow this to the specific hosts you serve from, e.g.\n // [\"myapp.com\", \"*.web.val.run\"].\n allowedHosts: [\"*\"],\n protocol: \"auto\",\n fallback,\n },\n secret,\n database: {\n dialect: new LibsqlDialect({ client: sqlite }),\n type: \"sqlite\",\n },\n // Disable email+password — this template is magic link only.\n emailAndPassword: { enabled: false },\n plugins: [\n magicLink({\n sendMagicLink: async ({ email, url }) => {\n // Val Town's built-in email. Sending to addresses other than your own\n // requires a Pro account: https://www.val.town/pricing\n await sendEmail({\n to: email,\n subject: \"Your sign-in link\",\n text: `Click to sign in: ${url}\\n\\nThis link expires in 5 minutes.`,\n html:\n `

Click to sign in:

` +\n `

${url}

` +\n `

This link expires in 5 minutes.

`,\n });\n },\n }),\n ],\n});\n",[],[275,285],"ad6c2075-0404-4f7c-bf4e-35ad79951cf0",["D",1788584179632],[171,172,173],[275],["D",1788584179632],["D",1789539031988],{"_11":12,"_127":74},{"_11":12,"_123":74,"_73":74,"_30":72,"_124":125,"_126":24},{"_38":114,"_13":16,"_32":35,"_115":76,"_116":-5,"_117":-5,"_118":-5,"_119":-5,"_120":-5,"_121":14,"_122":12},"ctx",{"_52":-5,"_146":333,"_334":335,"_336":337,"_338":24,"_339":24,"_340":24,"_341":88,"_342":-5,"_343":-7,"_344":-7,"_345":26,"_346":24,"_347":24,"_348":-5,"_349":24,"_350":24,"_351":24,"_352":-5},"ENV",{"_304":305,"_306":307,"_308":16,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]

{p.title}

{post.title}

History · SignIn.tsx