[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_292":293,"_294":295},"routes/_app.x.$handle.$name",{"_104":103,"_32":46,"_112":91,"_27":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_20":-5,"_124":125,"_126":127,"_128":25,"_129":130,"_131":60,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_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",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","shared/routes.ts","latestPath","fileId","019c82c8-9b9f-71cf-9c7c-2fe5fa5c6c26","name","routes.ts","fileType","script","content","import {\n type ActionFunctionArgs,\n type LoaderFunctionArgs,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { Home } from \"../routes/Home.tsx\";\n\nlet isServer = typeof document === \"undefined\";\n\n// On the server, dynamically import the real loader/action function.\n// On the client, return a no-op stub. The stub's presence tells React Router\n// this route needs data, but the client's dataStrategy handles the actual\n// fetching via a single HTTP request to the server.\nfunction serverLoader(importURL: string) {\n if (isServer) {\n return async (args: LoaderFunctionArgs) => {\n let module = await import(importURL);\n return (module.loader || module.default)(args);\n };\n }\n return () => null;\n}\n\nfunction serverAction(importURL: string) {\n if (isServer) {\n return async (args: ActionFunctionArgs) => {\n let module = await import(importURL);\n return (module.action || module.default)(args);\n };\n }\n return () => null;\n}\n\nexport const routes = [\n {\n path: \"/\",\n Component: Home,\n loader: serverLoader(\"../routes/Home.loader.ts\"),\n action: serverAction(\"../routes/Home.action.ts\"),\n },\n];\n","import {\n type ActionFunctionArgs,\n type LoaderFunctionArgs,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { Home } from \"../routes/Home.tsx\";\n\nconst isServer = typeof document === \"undefined\";\n\n// On the server, dynamically import the real loader/action function.\n// On the client, return a no-op stub. The stub's presence tells React Router\n// this route needs data, but the client's dataStrategy handles the actual\n// fetching via a single HTTP request to the server.\nfunction serverLoader(importURL: string) {\n if (isServer) {\n return async (args: LoaderFunctionArgs) => {\n let module = await import(importURL);\n return (module.loader || module.default)(args);\n };\n }\n return () => null;\n}\n\nfunction serverAction(importURL: string) {\n if (isServer) {\n return async (args: ActionFunctionArgs) => {\n let module = await import(importURL);\n return (module.action || module.default)(args);\n };\n }\n return () => null;\n}\n\nexport const routes = [\n {\n path: \"/\",\n Component: Home,\n loader: serverLoader(\"../routes/Home.loader.ts\"),\n action: serverAction(\"../routes/Home.action.ts\"),\n },\n];","createdAt",["D",1771761127478],"branchVersion","branchId","cfbc9000-0f86-11f1-9fc4-42dde27851f2","id","cfb5d724-0f86-11f1-9fc4-42dde27851f2","reactRouter7MinimalExample",["D",1771720710965],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Full-stack example ReactRouter7 project","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","019c82c8-9b9f-71cf-9c7b-d021b160f907","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","tursoName","cfb5d7240f8611f19fc442dde27851f2","tursoHostname","cfb5d7240f8611f19fc442dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789444861734],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_111":107},"org",{"_104":103,"_105":-5,"_106":107,"_18":56,"_108":109,"_110":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":94,"_95":96,"_97":51,"_98":99,"_100":66,"_101":46,"_102":103},"isOwned",9,"main","projectId","forkedBranchId","f1a26f20-14cb-11f0-b108-569c3dd06744","forkedBranchVersion",177,"forkedProjectPrivacy","forkedProjectId","f1a22d8a-14cb-11f0-b108-569c3dd06744","forkedProjectOrgId","projectName","userHandle","stevekrouse","handle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":287,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":288,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":289,"_85":290,"_87":291,"_89":25},"tree",[191,195,199,203,205],"files",[191,192,193,194,195,196,197,198,199,200,201,202,203,204,205],"counts",{"_181":64,"_182":153,"_183":64,"_184":185,"_186":187},"contents",[144,145,146,147,148],"upstreamProject",{"_44":99,"_32":142,"_53":54,"_55":-5,"_50":51,"_83":143},"upstreamBranch",{"_44":94,"_39":136,"_137":138,"_32":91,"_92":99,"_13":139,"_93":-5,"_95":-5,"_140":141,"_48":-5,"_89":25,"_50":51,"_102":103,"_65":66,"_101":142},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1744152661331],"updatedAt",["D",1771761464050],178,"lockfileKey","1771761466206-esm.town_v_stevekrouse_reactRouter7Example@178-main","reactRouter7Example",{"_104":103,"_111":107},{"_44":176,"_32":177,"_30":178,"_152":-5,"_42":43,"_41":156,"_154":60,"_39":179,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_27":180},{"_44":171,"_32":172,"_30":173,"_152":-5,"_42":43,"_41":156,"_154":60,"_39":174,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_27":175},{"_44":166,"_32":167,"_30":168,"_152":-5,"_42":43,"_41":156,"_154":60,"_39":169,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_27":170},{"_44":160,"_32":161,"_30":162,"_152":-5,"_42":43,"_41":156,"_154":60,"_39":163,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_27":165},{"_44":149,"_32":150,"_30":151,"_152":-5,"_42":43,"_41":153,"_154":25,"_39":155,"_13":156,"_34":20,"_36":157,"_24":25,"_158":-5,"_27":159},"caa24b0e-0f87-11f1-9965-42dde27851f2","README.md","019c82c8-9b9f-71cf-9c7c-38fa193b361b","parentId",2,"latest",["D",1771721131961],1,"# React Router 7 on Val Town — Minimal Example\n\nThe simplest possible full-stack SSR + SPA app on [Val Town](https://val.town), built with **React Router 7**, **Hono**, and **SQLite**. A todo list in ~150 lines of app code that demonstrates every core pattern you need.\n\n> **Want the full version?** See the [message board example](https://www.val.town/x/stevekrouse/reactRouter7Example) with nested routes, search, multiple tables, and more.\n\n## What This Teaches\n\n1. **SSR + Hydration** — Server renders full HTML, client hydrates with `hydrateRoot`\n2. **Shared route tree** — Same `routes.ts` on server and client; `serverLoader`/`serverAction` keeps DB code off the client\n3. **Single-fetch `dataStrategy`** — One request per navigation via `X-Data-Request` header\n4. **Loaders** — Server-side data loading before render\n5. **Actions** — Form submissions via `

` with `intent` pattern\n6. **SQLite persistence** — Val Town's project-scoped database\n7. **Loading states** — `useNavigation()` for optimistic UI\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Hono HTTP entry — SSR + data API + static files\n│ └── database.ts # Schema + all queries (one file, one table)\n├── frontend/\n│ ├── index.html # HTML shell template\n│ └── index.tsx # Client hydration + dataStrategy\n├── routes/\n│ ├── Home.tsx # The entire UI — todo list + add form\n│ ├── Home.loader.ts # Loads all todos from SQLite\n│ └── Home.action.ts # Handles \"add\" and \"toggle\" form submissions\n├── shared/\n│ └── routes.ts # Route tree (shared between server + client)\n└── README.md\n```\n\n## How It Works\n\n### Request Lifecycle\n\n```\nFirst visit (SSR):\n Browser → GET / → Hono → createStaticHandler → runs Home.loader\n → renderToString → full HTML response → Browser hydrates\n\nAfter hydration (SPA):\n User submits form → dataStrategy → POST / (X-Data-Request: true)\n → Hono → runs Home.action + Home.loader → JSON response\n → React Router updates UI\n```\n\n### Key Pattern: `serverLoader` / `serverAction`\n\nThe route tree in `shared/routes.ts` is imported by both server and client. The helpers make this work:\n\n- **On the server**: dynamically import the real loader/action and call it\n- **On the client**: return a no-op stub (the `dataStrategy` handles fetching)\n\nThis means loader/action code and database dependencies **never ship to the browser**.\n\n### Key Pattern: `dataStrategy` (Single-Fetch)\n\nInstead of React Router calling each loader individually on the client, a custom `dataStrategy` in `frontend/index.tsx` makes **one HTTP request** with an `X-Data-Request: true` header. The server runs all matched loaders/actions and returns their data as keyed JSON.\n\n## Extending This\n\n| Want to add... | What to do |\n|---|---|\n| **More pages** | Add routes to `shared/routes.ts` with new `Component`, `loader`, `action` |\n| **Nested layouts** | Use `children` array in routes + `` in parent component |\n| **More tables** | Add queries to `backend/database.ts` (or split into separate files) |\n| **Search** | Add a route with a loader that reads `new URL(request.url).searchParams` |\n| **Redirects from actions** | Return `redirect(\"/path\")` — the `dataStrategy` handles it automatically |\n\n## Getting Started\n\n1. **Fork this val** on Val Town\n2. The database auto-initializes on first request\n3. Visit the HTTP endpoint to see the app\n4. Start extending!\n\n## Tech Stack\n\n| Layer | Technology |\n|-------|-----------|\n| Server | [Hono](https://hono.dev/) |\n| Routing | [React Router 7](https://reactrouter.com/) |\n| UI | [React 18](https://react.dev/) |\n| Styling | [Twind](https://twind.dev/) (Tailwind via CDN) |\n| Database | Val Town SQLite (`std/sqlite@14-main`) |\n| Runtime | Val Town (Deno) |\n","label",[150],"cfdb6138-0f86-11f1-9fc4-42dde27851f2","shared","019c82c8-9b9f-71cf-9c7c-34e7e0ef4ba1",["D",1771720710965],"directory",[161],"cfdb4946-0f86-11f1-9fc4-42dde27851f2","routes","019c82c8-9b9f-71cf-9c7c-2a606343932c",["D",1771720710965],[167],"cfdafc70-0f86-11f1-9fc4-42dde27851f2","frontend","019c82c8-9b9f-71cf-9c7b-fd9235b8b6a5",["D",1771720710965],[172],"cfc30502-0f86-11f1-9fc4-42dde27851f2","backend","019c82c8-9b9f-71cf-9c7b-d55bf5e7243f",["D",1771720710965],[177],"pulls","branches","forks","envVars",{"_188":64,"_190":64},"connections",{"_188":64,"_189":64},"count","unfilledCount","emptyCount",{"_44":176,"_32":177,"_30":178,"_152":-5,"_42":43,"_41":156,"_154":60,"_39":284,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_207":285,"_27":286},{"_44":278,"_32":279,"_30":280,"_152":178,"_42":43,"_41":156,"_154":60,"_39":281,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_207":282,"_27":283},{"_44":271,"_32":272,"_30":273,"_152":178,"_42":43,"_41":153,"_154":25,"_39":274,"_13":64,"_34":35,"_36":275,"_24":25,"_158":-5,"_207":276,"_27":277},{"_44":264,"_32":265,"_30":58,"_152":178,"_42":43,"_41":153,"_154":25,"_39":266,"_13":156,"_34":267,"_36":268,"_24":25,"_158":-5,"_207":269,"_27":270},{"_44":171,"_32":172,"_30":173,"_152":-5,"_42":43,"_41":156,"_154":60,"_39":261,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_207":262,"_27":263},{"_44":255,"_32":256,"_30":257,"_152":173,"_42":43,"_41":156,"_154":60,"_39":258,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_207":259,"_27":260},{"_44":248,"_32":249,"_30":250,"_152":173,"_42":43,"_41":153,"_154":60,"_39":251,"_13":156,"_34":20,"_36":252,"_24":25,"_158":-5,"_207":253,"_27":254},{"_44":241,"_32":242,"_30":243,"_152":173,"_42":43,"_41":153,"_154":60,"_39":244,"_13":156,"_34":35,"_36":245,"_24":25,"_158":-5,"_207":246,"_27":247},{"_44":166,"_32":167,"_30":168,"_152":-5,"_42":43,"_41":156,"_154":60,"_39":238,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_207":239,"_27":240},{"_44":231,"_32":232,"_30":233,"_152":168,"_42":43,"_41":153,"_154":60,"_39":234,"_13":64,"_34":35,"_36":235,"_24":25,"_158":-5,"_207":236,"_27":237},{"_44":224,"_32":225,"_30":226,"_152":168,"_42":43,"_41":153,"_154":60,"_39":227,"_13":156,"_34":35,"_36":228,"_24":25,"_158":-5,"_207":229,"_27":230},{"_44":217,"_32":218,"_30":219,"_152":168,"_42":43,"_41":153,"_154":60,"_39":220,"_13":156,"_34":35,"_36":221,"_24":25,"_158":-5,"_207":222,"_27":223},{"_44":160,"_32":161,"_30":162,"_152":-5,"_42":43,"_41":156,"_154":60,"_39":214,"_13":64,"_34":164,"_36":-5,"_24":25,"_158":-5,"_207":215,"_27":216},{"_44":210,"_32":33,"_30":31,"_152":162,"_42":43,"_41":14,"_154":60,"_39":211,"_13":153,"_34":35,"_36":38,"_24":25,"_158":-5,"_207":212,"_27":213},{"_44":149,"_32":150,"_30":151,"_152":-5,"_42":43,"_41":153,"_154":25,"_39":206,"_13":156,"_34":20,"_36":157,"_24":25,"_158":-5,"_207":208,"_27":209},["D",1771721131961],"children",[],[150],"e9d0d9c0-0fe4-11f1-96d1-42dde27851f2",["D",1771761127478],[],[161,33],["D",1771720710965],[204],[161],"caa29154-0f87-11f1-9965-42dde27851f2","Home.tsx","019c82c8-9b9f-71cf-9c7c-0b560a296e73",["D",1771721131961],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Form,\n useLoaderData,\n useNavigation,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Todo } from \"../backend/database.ts\";\n\nexport function Home() {\n const { todos } = useLoaderData<{ todos: Todo[] }>();\n const navigation = useNavigation();\n const isAdding = navigation.state === \"submitting\"\n && navigation.formData?.get(\"intent\") === \"add\";\n const $form = React.useRef(null);\n\n // Reset the form after a successful submission\n React.useEffect(() => {\n if (navigation.state === \"idle\") $form.current?.reset();\n }, [navigation.state]);\n\n return (\n

Todo List

\n\n {/* Add todo form */}\n \n \n \n \n {isAdding ? \"Adding...\" : \"Add\"}\n \n \n\n {/* Todo list */}\n

\n
\n \n \n \n
\n \n {todo.text}\n \n

\n\n {todos.length === 0 && (\n

No todos yet. Add one above!

\n )}\n\n \n

\n );\n}\n",[],[167,218],"caa28e70-0f87-11f1-9965-42dde27851f2","Home.loader.ts","019c82c8-9b9f-71cf-9c7c-04590b996403",["D",1771721131961],"import { getAllTodos } from \"../backend/database.ts\";\n\nexport async function loader() {\n return { todos: await getAllTodos() };\n}\n",[],[167,225],"caa20af4-0f87-11f1-9965-42dde27851f2","Home.action.ts","caa20b80-0f87-11f1-9965-42dde27851f2",["D",1771721131961],"import { ActionFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { addTodo, toggleTodo } from \"../backend/database.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n const formData = await request.formData();\n const intent = formData.get(\"intent\");\n\n if (intent === \"add\") {\n const text = formData.get(\"text\") as string;\n if (!text?.trim()) throw new Response(\"Text is required\", { status: 400 });\n await addTodo(text.trim());\n } else if (intent === \"toggle\") {\n const id = Number(formData.get(\"id\"));\n await toggleTodo(id);\n }\n\n return { ok: true };\n}\n",[],[167,232],["D",1771720710965],[200,201,202],[167],"caa27c50-0f87-11f1-9965-42dde27851f2","index.tsx","019c82c8-9b9f-71cf-9c7b-fa99b68ed4b6",["D",1771721131961],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport {\n createBrowserRouter,\n redirect,\n RouterProvider,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { routes } from \"../shared/routes.ts\";\n\n// Create a browser router with a custom dataStrategy for single-fetch.\n// Instead of React Router calling each loader individually, this makes ONE\n// HTTP request per navigation with an \"X-Data-Request: true\" header.\n// The server runs all matched loaders/actions and returns their data as JSON.\nconst router = createBrowserRouter(\n routes,\n {\n // @ts-ignore - hydrationData is injected by the server\n hydrationData: window.__staticRouterHydrationData,\n\n async dataStrategy({ request, matches }) {\n const matchesToLoad = matches.filter(m => m.shouldLoad);\n if (matchesToLoad.length === 0) return {};\n\n const fetchInit: RequestInit = {\n method: request.method,\n headers: { \"X-Data-Request\": \"true\" },\n signal: request.signal,\n };\n\n // For form submissions (actions), forward the body\n if (request.method !== \"GET\") {\n fetchInit.body = await request.formData();\n }\n\n const res = await fetch(request.url, fetchInit);\n const json = await res.json();\n\n // Handle redirects from actions\n if (json.redirect) {\n const results: Record = {};\n for (const match of matchesToLoad) {\n results[match.route.id] = { type: \"data\", result: redirect(json.redirect) };\n }\n return results;\n }\n\n // Map loader/action data back to route IDs\n const results: Record = {};\n for (const match of matchesToLoad) {\n const routeId = match.route.id;\n if (json.actionData?.[routeId] != null) {\n results[routeId] = { type: \"data\", result: json.actionData[routeId] };\n } else if (json.loaderData?.[routeId] !== undefined) {\n results[routeId] = { type: \"data\", result: json.loaderData[routeId] };\n }\n }\n\n return results;\n },\n },\n);\n\n// Hydrate the server-rendered HTML\nhydrateRoot(\n document.getElementById(\"root\")!,\n \n \n ,\n);\n",[],[172,242],"caa2770a-0f87-11f1-9965-42dde27851f2","index.html","019c82c8-9b9f-71cf-9c7b-f521acec0290",["D",1771721131961],"\n\n \n \n \n Todo List\n \n \n \n \n \n

\n \n \n\n",[],[172,249],"cfc33e96-0f86-11f1-9fc4-42dde27851f2","components","019c82c8-9b9f-71cf-9c7b-f1f1eaa5d913",["D",1771720710965],[],[172,256],["D",1771720710965],[196,197,198],[172],"caa265e4-0f87-11f1-9965-42dde27851f2","index.ts",["D",1771721131961],"http","import { Hono } from \"https://esm.sh/hono@4.1.0\";\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport {\n createStaticHandler,\n createStaticRouter,\n StaticRouterProvider,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { routes } from \"../shared/routes.ts\";\nimport { initializeDatabase } from \"./database.ts\";\n\n// Initialize the database\nawait initializeDatabase();\n\n// Create the Hono app\nconst app = new Hono();\n\n// Serve static files (frontend, shared, routes — needed for client-side imports)\napp.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/routes/*\", (c) => serveFile(c.req.path, import.meta.url));\napp.get(\"/backend/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Create a static handler for server-side rendering\nconst { query, dataRoutes } = createStaticHandler(routes);\n\n// Handle all routes with React Router\napp.all(\"*\", async (c) => {\n const isDataRequest = c.req.header(\"X-Data-Request\") === \"true\";\n\n // Run loaders/actions on the server\n const context = await query(c.req.raw);\n\n // If the context is a Response (e.g., redirect from an action)\n if (context instanceof Response) {\n if (isDataRequest && context.status >= 300 && context.status < 400) {\n return Response.json({ redirect: context.headers.get(\"Location\") });\n }\n return context;\n }\n\n // Data-only request: return loader/action data as JSON\n if (isDataRequest) {\n return Response.json({\n loaderData: context.loaderData,\n actionData: context.actionData,\n });\n }\n\n // Full SSR render\n const router = createStaticRouter(dataRoutes, context);\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n const appHtml = renderToString(\n React.createElement(StaticRouterProvider, { router, context }),\n );\n\n html = html.replace(\n '

',\n `

${appHtml}

`,\n );\n\n return c.html(html);\n});\n\napp.onError((err, c) => {\n throw err;\n});\n\nexport default app.fetch;\n",[],[177,265],"caa1e8b2-0f87-11f1-9965-42dde27851f2","database.ts","caa1e966-0f87-11f1-9965-42dde27851f2",["D",1771721131961],"import { sqlite } from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\nconst TABLE = \"todos_v1\";\n\nexport interface Todo {\n id: number;\n text: string;\n done: number; // 0 or 1 (SQLite has no booleans)\n}\n\nexport async function initializeDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n done INTEGER NOT NULL DEFAULT 0\n )\n `);\n}\n\nexport async function getAllTodos(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE} ORDER BY id DESC`);\n return result.rows as Todo[];\n}\n\nexport async function addTodo(text: string): Promise {\n await sqlite.execute({ sql: `INSERT INTO ${TABLE} (text) VALUES (?)`, args: [text] });\n}\n\nexport async function toggleTodo(id: number): Promise {\n await sqlite.execute({ sql: `UPDATE ${TABLE} SET done = 1 - done WHERE id = ?`, args: [id] });\n}\n",[],[177,272],"cfc2f0bc-0f86-11f1-9fc4-42dde27851f2","database","019c82c8-9b9f-71cf-9c7b-cea6edb6ef75",["D",1771720710965],[],[177,279],["D",1771720710965],[192,193,194],[177],["D",1771720710965],["D",1789444861734],{"_104":103,"_111":107},{"_104":103,"_105":-5,"_106":107,"_18":56,"_108":109,"_110":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":94,"_95":96,"_97":51,"_98":99,"_100":66,"_101":46,"_102":103},"ctx",{"_83":-5,"_133":325,"_326":327,"_328":329,"_330":25,"_331":25,"_332":25,"_333":60,"_334":-5,"_335":-7,"_336":-7,"_337":64,"_338":25,"_339":25,"_340":-5,"_341":25,"_342":25,"_343":25,"_344":-5},"ENV",{"_296":297,"_298":299,"_300":91,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324},"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 · v3