` 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","deleted","label",[132],"3b259436-0f87-11f1-bedc-42dde27851f2","shared","019c82cb-5b48-76ad-b4d1-a699e13e3a83",["D",1771720891213],"directory",[149],"3b25823e-0f87-11f1-bedc-42dde27851f2","routes","019c82cb-5b48-76ad-b4d1-9ad8b51f1d69",["D",1771720891213],[155],"3b25359a-0f87-11f1-bedc-42dde27851f2","frontend","019c82cb-5b48-76ad-b4d1-6f1d4136d5e0",["D",1771720891213],[160],"3b24d97e-0f87-11f1-bedc-42dde27851f2","backend","019c82cb-5b48-76ad-b4d1-45904063f3c5",["D",1771720891213],[165],"pulls","branches","forks","envVars",{"_176":42,"_178":42},"connections",{"_176":42,"_177":42},"count","unfilledCount","emptyCount",{"_18":164,"_20":165,"_133":166,"_135":-5,"_136":71,"_137":141,"_139":38,"_22":285,"_68":42,"_142":152,"_143":-5,"_145":26,"_146":-5,"_195":286,"_90":287},{"_18":279,"_20":280,"_133":281,"_135":166,"_136":71,"_137":69,"_139":38,"_22":282,"_68":42,"_142":152,"_143":-5,"_145":26,"_146":-5,"_195":283,"_90":284},{"_18":271,"_20":272,"_133":273,"_135":166,"_136":71,"_137":274,"_139":38,"_22":275,"_68":42,"_142":203,"_143":276,"_145":26,"_146":-5,"_195":277,"_90":278},{"_18":262,"_20":263,"_133":264,"_135":166,"_136":71,"_137":265,"_139":38,"_22":266,"_68":141,"_142":267,"_143":268,"_145":26,"_146":-5,"_195":269,"_90":270},{"_18":159,"_20":160,"_133":161,"_135":-5,"_136":71,"_137":141,"_139":38,"_22":259,"_68":42,"_142":152,"_143":-5,"_145":26,"_146":-5,"_195":260,"_90":261},{"_18":253,"_20":254,"_133":255,"_135":161,"_136":71,"_137":69,"_139":38,"_22":256,"_68":42,"_142":152,"_143":-5,"_145":26,"_146":-5,"_195":257,"_90":258},{"_18":245,"_20":246,"_133":247,"_135":161,"_136":71,"_137":248,"_139":38,"_22":249,"_68":141,"_142":101,"_143":250,"_145":26,"_146":-5,"_195":251,"_90":252},{"_18":237,"_20":238,"_133":239,"_135":161,"_136":71,"_137":240,"_139":38,"_22":241,"_68":141,"_142":203,"_143":242,"_145":26,"_146":-5,"_195":243,"_90":244},{"_18":154,"_20":155,"_133":156,"_135":-5,"_136":71,"_137":141,"_139":38,"_22":234,"_68":42,"_142":152,"_143":-5,"_145":26,"_146":-5,"_195":235,"_90":236},{"_18":226,"_20":227,"_133":228,"_135":156,"_136":71,"_137":229,"_139":38,"_22":230,"_68":42,"_142":203,"_143":231,"_145":26,"_146":-5,"_195":232,"_90":233},{"_18":218,"_20":219,"_133":220,"_135":156,"_136":71,"_137":221,"_139":38,"_22":222,"_68":141,"_142":203,"_143":223,"_145":26,"_146":-5,"_195":224,"_90":225},{"_18":210,"_20":211,"_133":212,"_135":156,"_136":71,"_137":213,"_139":38,"_22":214,"_68":141,"_142":203,"_143":215,"_145":26,"_146":-5,"_195":216,"_90":217},{"_18":148,"_20":149,"_133":150,"_135":-5,"_136":71,"_137":141,"_139":38,"_22":207,"_68":42,"_142":152,"_143":-5,"_145":26,"_146":-5,"_195":208,"_90":209},{"_18":198,"_20":199,"_133":200,"_135":150,"_136":71,"_137":201,"_139":38,"_22":202,"_68":141,"_142":203,"_143":204,"_145":26,"_146":-5,"_195":205,"_90":206},{"_18":131,"_20":132,"_133":134,"_135":-5,"_136":71,"_137":138,"_139":38,"_22":194,"_68":141,"_142":101,"_143":144,"_145":26,"_146":-5,"_195":196,"_90":197},["D",1771720998652],"children",[],[132],"51cae6fa-0f87-11f1-bc98-42dde27851f2","routes.ts","019c82cb-5b48-76ad-b4d1-9c36ca4f91ea",22,["D",1771720929235],"script","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",[],[149,199],["D",1771720891213],[192],[149],"58167182-0f87-11f1-bc98-42dde27851f2","Home.tsx","019c82cb-5b48-76ad-b4d1-78f8aedb7c40",23,["D",1771720939795],"/** @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",[],[155,211],"58b5ab94-0f87-11f1-bc98-42dde27851f2","Home.loader.ts","019c82cb-5b48-76ad-b4d1-752e1aa03394",24,["D",1771720940840],"import { getAllTodos } from \"../backend/database.ts\";\n\nexport async function loader() {\n return { todos: await getAllTodos() };\n}\n",[],[155,219],"4c35f036-0f87-11f1-8f72-42dde27851f2","Home.action.ts","4c35f0fe-0f87-11f1-8f72-42dde27851f2",21,["D",1771720919871],"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",[],[155,227],["D",1771720891213],[188,189,190],[155],"69be20f6-0f87-11f1-8899-42dde27851f2","index.tsx","019c82cb-5b48-76ad-b4d1-6be7a9a368ce",27,["D",1771720969416],"/** @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",[],[160,238],"631ade1a-0f87-11f1-8b77-42dde27851f2","index.html","019c82cb-5b48-76ad-b4d1-6598c90aff42",26,["D",1771720958278],"\n\n \n \n \n Todo List\n \n \n \n \n \n

\n \n \n\n",[],[160,246],"bbd9c8ae-0f87-11f1-8f72-42dde27851f2","components","019c82ce-a6e0-774f-9873-6da360d5b3ee",["D",1771721107172],[],[160,254],["D",1771720891213],[184,185,186],[160],"61306e6c-0f87-11f1-bedc-42dde27851f2","index.ts","019c82cb-5b48-76ad-b4d1-411b4ee95cfc",25,["D",1771720954967],"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",[],[165,263],"4a20e652-0f87-11f1-8f72-42dde27851f2","database.ts","4a20e742-0f87-11f1-8f72-42dde27851f2",20,["D",1771720916380],"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",[],[165,272],"bbd9bfb2-0f87-11f1-8f72-42dde27851f2","database","019c82ce-a6e0-774f-9873-6966bc8c8a5b",["D",1771721107172],[],[165,280],["D",1771720891213],[180,181,182],[165],["D",1771720710965],["D",1789531852468],{"_16":17,"_88":84},{"_16":17,"_82":-5,"_83":84,"_33":34,"_85":86,"_87":26},{"_68":69,"_20":70,"_18":71,"_72":19,"_73":74,"_75":76,"_77":28,"_78":19,"_79":44,"_80":21,"_81":17},"ctx",{"_61":-5,"_111":326,"_327":328,"_329":330,"_331":26,"_332":26,"_333":26,"_334":38,"_335":-5,"_336":-7,"_337":-7,"_338":42,"_339":26,"_340":26,"_341":-5,"_342":26,"_343":26,"_344":26,"_345":-5},"ENV",{"_297":298,"_299":300,"_301":117,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325},"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"]