` 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",[148],"3b259436-0f87-11f1-bedc-42dde27851f2","shared","019c82cb-5b48-76ad-b4d1-a699e13e3a83",["D",1771720891213],"directory",[164],"3b25823e-0f87-11f1-bedc-42dde27851f2","routes","019c82cb-5b48-76ad-b4d1-9ad8b51f1d69",["D",1771720891213],[170],"3b25359a-0f87-11f1-bedc-42dde27851f2","frontend","019c82cb-5b48-76ad-b4d1-6f1d4136d5e0",["D",1771720891213],[175],"3b24d97e-0f87-11f1-bedc-42dde27851f2","backend","019c82cb-5b48-76ad-b4d1-45904063f3c5",["D",1771720891213],[180],"pulls","branches","forks","envVars",{"_191":20,"_193":20},"connections",{"_191":20,"_192":20},"count","unfilledCount","emptyCount",{"_32":179,"_13":180,"_149":181,"_151":-5,"_152":58,"_153":157,"_155":80,"_34":300,"_41":20,"_158":167,"_159":-5,"_65":26,"_161":-5,"_210":301,"_112":302},{"_32":294,"_13":295,"_149":296,"_151":181,"_152":58,"_153":57,"_155":80,"_34":297,"_41":20,"_158":167,"_159":-5,"_65":26,"_161":-5,"_210":298,"_112":299},{"_32":286,"_13":287,"_149":288,"_151":181,"_152":58,"_153":289,"_155":80,"_34":290,"_41":20,"_158":218,"_159":291,"_65":26,"_161":-5,"_210":292,"_112":293},{"_32":277,"_13":278,"_149":279,"_151":181,"_152":58,"_153":280,"_155":80,"_34":281,"_41":157,"_158":282,"_159":283,"_65":26,"_161":-5,"_210":284,"_112":285},{"_32":174,"_13":175,"_149":176,"_151":-5,"_152":58,"_153":157,"_155":80,"_34":274,"_41":20,"_158":167,"_159":-5,"_65":26,"_161":-5,"_210":275,"_112":276},{"_32":268,"_13":269,"_149":270,"_151":176,"_152":58,"_153":57,"_155":80,"_34":271,"_41":20,"_158":167,"_159":-5,"_65":26,"_161":-5,"_210":272,"_112":273},{"_32":260,"_13":261,"_149":262,"_151":176,"_152":58,"_153":263,"_155":80,"_34":264,"_41":157,"_158":124,"_159":265,"_65":26,"_161":-5,"_210":266,"_112":267},{"_32":252,"_13":253,"_149":254,"_151":176,"_152":58,"_153":255,"_155":80,"_34":256,"_41":157,"_158":218,"_159":257,"_65":26,"_161":-5,"_210":258,"_112":259},{"_32":169,"_13":170,"_149":171,"_151":-5,"_152":58,"_153":157,"_155":80,"_34":249,"_41":20,"_158":167,"_159":-5,"_65":26,"_161":-5,"_210":250,"_112":251},{"_32":241,"_13":242,"_149":243,"_151":171,"_152":58,"_153":244,"_155":80,"_34":245,"_41":20,"_158":218,"_159":246,"_65":26,"_161":-5,"_210":247,"_112":248},{"_32":233,"_13":234,"_149":235,"_151":171,"_152":58,"_153":236,"_155":80,"_34":237,"_41":157,"_158":218,"_159":238,"_65":26,"_161":-5,"_210":239,"_112":240},{"_32":225,"_13":226,"_149":227,"_151":171,"_152":58,"_153":228,"_155":80,"_34":229,"_41":157,"_158":218,"_159":230,"_65":26,"_161":-5,"_210":231,"_112":232},{"_32":163,"_13":164,"_149":165,"_151":-5,"_152":58,"_153":157,"_155":80,"_34":222,"_41":20,"_158":167,"_159":-5,"_65":26,"_161":-5,"_210":223,"_112":224},{"_32":213,"_13":214,"_149":215,"_151":165,"_152":58,"_153":216,"_155":80,"_34":217,"_41":157,"_158":218,"_159":219,"_65":26,"_161":-5,"_210":220,"_112":221},{"_32":147,"_13":148,"_149":150,"_151":-5,"_152":58,"_153":154,"_155":80,"_34":209,"_41":157,"_158":124,"_159":160,"_65":26,"_161":-5,"_210":211,"_112":212},["D",1771720998652],"children",[],[148],"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",[],[164,214],["D",1771720891213],[207],[164],"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",[],[170,226],"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",[],[170,234],"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",[],[170,242],["D",1771720891213],[203,204,205],[170],"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",[],[175,253],"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",[],[175,261],"bbd9c8ae-0f87-11f1-8f72-42dde27851f2","components","019c82ce-a6e0-774f-9873-6da360d5b3ee",["D",1771721107172],[],[175,269],["D",1771720891213],[199,200,201],[175],"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",[],[180,278],"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",[],[180,287],"bbd9bfb2-0f87-11f1-8f72-42dde27851f2","database","019c82ce-a6e0-774f-9873-6966bc8c8a5b",["D",1771721107172],[],[180,295],["D",1771720891213],[195,196,197],[180],["D",1771720710965],["D",1789531852468],{"_11":12,"_111":107},{"_11":12,"_105":-5,"_106":107,"_75":76,"_108":109,"_110":26},{"_41":57,"_13":16,"_32":58,"_39":40,"_43":33,"_45":59,"_60":52,"_61":40,"_62":55,"_56":14,"_53":12},"ctx",{"_100":-5,"_134":341,"_342":343,"_344":345,"_346":26,"_347":26,"_348":26,"_349":80,"_350":-5,"_351":-7,"_352":-7,"_353":20,"_354":26,"_355":26,"_356":-5,"_357":26,"_358":26,"_359":26,"_360":-5},"ENV",{"_312":313,"_314":315,"_316":38,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340},"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"]

Compare

Mergeminimalintomain