[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_267":268,"_269":270},"routes/_app.x.$handle.$name",{"_104":103,"_32":46,"_112":90,"_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",9,"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","frontend/components/App.tsx","latestPath","fileId","019de3cc-3d7d-7038-84fe-47c850c8848d","name","App.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { TodoList } from \"./TodoList.tsx\";\n\nexport function App() {\n return (\n

📝 Todos

\n \n

\n View source\n

\n );\n}\n","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { TodoList } from \"./TodoList.tsx\";\n\nexport function App() {\n return (\n

📝 Todos!!!!

\n \n

\n View source\n

\n );\n}","createdAt",["D",1777657045566],"branchVersion","branchId","6d9e47d8-4564-11f1-bfed-42b51c65c3df","id","6d93883e-4564-11f1-bfed-42b51c65c3df","todos",["D",1777643306241],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","019de3cc-3d7d-7038-84fe-649bd8a15ea7","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","tursoName","6d93883e456411f1bfed42b51c65c3df","tursoHostname","6d93883e456411f1bfed42b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789498239291],"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":14,"_32":90,"_44":43,"_91":45,"_92":93,"_94":95,"_96":51,"_97":98,"_99":100,"_101":46,"_102":103},"isOwned","main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",88,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","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":262,"_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":263,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":264,"_85":265,"_87":266,"_89":25},"tree",[191,198,200,201],"files",[191,192,193,194,195,196,197,198,199,200,201],"counts",{"_181":64,"_182":157,"_183":64,"_184":185,"_186":187},"contents",[147,148,149,150],"upstreamProject",{"_44":98,"_32":143,"_53":54,"_55":144,"_50":51,"_83":145},"upstreamBranch",{"_44":93,"_39":136,"_137":138,"_32":90,"_91":98,"_13":139,"_92":-5,"_94":-5,"_140":141,"_48":-5,"_89":25,"_50":51,"_102":142,"_65":100,"_101":143},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789527599&sig=0d894086c0af42ecb01197039479c0fffb55aba894accf0a0e78adbfe9ad755c",{"_104":142,"_111":146},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789527599&sig=c0420a404df732002c03eca9bce405b755065f984097bbe146cb490e828e28ea",{"_44":176,"_32":177,"_30":178,"_153":-5,"_42":43,"_41":157,"_155":60,"_39":179,"_13":64,"_34":174,"_36":-5,"_24":25,"_160":-5,"_27":180},{"_44":169,"_32":170,"_30":171,"_153":-5,"_42":43,"_41":172,"_155":60,"_39":173,"_13":64,"_34":174,"_36":-5,"_24":25,"_160":-5,"_27":175},{"_44":162,"_32":163,"_30":164,"_153":-5,"_42":43,"_41":165,"_155":60,"_39":166,"_13":157,"_34":20,"_36":167,"_24":25,"_160":-5,"_27":168},{"_44":151,"_32":152,"_30":58,"_153":-5,"_42":43,"_41":154,"_155":60,"_39":156,"_13":157,"_34":158,"_36":159,"_24":25,"_160":-5,"_27":161},"7c0d4fa8-4564-11f1-94d6-42b51c65c3df","index.ts","parentId",2,"latest",["D",1777643330507],1,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst app = new Hono();\n\n// --- Database setup ---\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS todos (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n text TEXT NOT NULL,\n done INTEGER NOT NULL DEFAULT 0,\n created_at INTEGER NOT NULL DEFAULT (unixepoch())\n )\n`);\n\ntype TodoRow = { id: number; text: string; done: number; created_at: number };\nconst serializeTodo = (t: TodoRow) => ({\n id: t.id,\n text: t.text,\n done: !!t.done,\n createdAt: t.created_at,\n});\n\n// --- Frontend ---\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// --- API ---\napp.get(\"/api/todos\", async (c) => {\n const result = await sqlite.execute(\"SELECT * FROM todos ORDER BY created_at DESC\");\n return c.json((result.rows as TodoRow[]).map(serializeTodo));\n});\n\napp.post(\"/api/todos\", async (c) => {\n const { text } = await c.req.json<{ text: string }>();\n if (!text?.trim()) return c.json({ error: \"text is required\" }, 400);\n const result = await sqlite.execute({\n sql: \"INSERT INTO todos (text) VALUES (?) RETURNING *\",\n args: [text.trim()],\n });\n return c.json(serializeTodo(result.rows[0] as TodoRow), 201);\n});\n\napp.patch(\"/api/todos/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json<{ done?: boolean; text?: string }>();\n const updates: string[] = [];\n const args: (string | number)[] = [];\n if (typeof body.done === \"boolean\") {\n updates.push(\"done = ?\");\n args.push(body.done ? 1 : 0);\n }\n if (typeof body.text === \"string\" && body.text.trim()) {\n updates.push(\"text = ?\");\n args.push(body.text.trim());\n }\n if (updates.length === 0) return c.json({ error: \"nothing to update\" }, 400);\n args.push(id);\n const result = await sqlite.execute({\n sql: `UPDATE todos SET ${updates.join(\", \")} WHERE id = ? RETURNING *`,\n args,\n });\n if (result.rows.length === 0) return c.json({ error: \"not found\" }, 404);\n return c.json(serializeTodo(result.rows[0] as TodoRow));\n});\n\napp.delete(\"/api/todos/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute({ sql: \"DELETE FROM todos WHERE id = ?\", args: [id] });\n return c.json({ ok: true });\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[152],"99aed9c8-4564-11f1-8981-42b51c65c3df","README.md","019de3cc-3d7d-7038-84fe-604a198e6edc",8,["D",1777643380242],"# Todos\n\nA simple todo list app with a SQLite backend, Hono API, and React frontend.\n\n## Features\n\n- ✅ Add, toggle, and delete todos\n- 💾 Persisted in SQLite (per-val database)\n- ⚡ Optimistic UI updates\n- 🎨 Styled with Twind (Tailwind utility classes)\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"frontend/index.html\"]\n HTML -->|loads| Entry[\"frontend/index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| TodoList[\"TodoList.tsx\"]\n TodoList <-->|\"fetch /api/todos\"| Hono\n Hono <-->|SQL| DB[(\"SQLite
todos table\")]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (frontend + API + SQLite)\nshared/types.ts ← Shared Todo type\nfrontend/\n index.html ← HTML shell (Twind + React)\n index.tsx ← React entrypoint\n components/\n App.tsx ← Root layout\n TodoList.tsx ← Todo list UI + API calls\n```\n\n## API\n\n| Method | Path | Body | Description |\n| ------ | ----------------- | ----------------------------- | --------------------- |\n| GET | `/api/todos` | | List all todos |\n| POST | `/api/todos` | `{ text }` | Create a todo |\n| PATCH | `/api/todos/:id` | `{ done?, text? }` | Update a todo |\n| DELETE | `/api/todos/:id` | | Delete a todo |\n",[163],"81781c02-4564-11f1-94d6-42b51c65c3df","shared","359d9061-b7ff-476e-9a59-9f122be48e8a",3,["D",1777643339620],"directory",[170],"6da8b2cc-4564-11f1-bfed-42b51c65c3df","frontend","019de3cc-3d7d-7038-84fe-5c3481c5a8d7",["D",1777643306241],[177],"pulls","branches","forks","envVars",{"_188":64,"_190":64},"connections",{"_188":64,"_189":64},"count","unfilledCount","emptyCount",{"_44":176,"_32":177,"_30":178,"_153":-5,"_42":43,"_41":157,"_155":60,"_39":259,"_13":64,"_34":174,"_36":-5,"_24":25,"_160":-5,"_203":260,"_27":261},{"_44":255,"_32":250,"_30":244,"_153":178,"_42":43,"_41":157,"_155":60,"_39":256,"_13":64,"_34":174,"_36":-5,"_24":25,"_160":-5,"_203":257,"_27":258},{"_44":251,"_32":33,"_30":31,"_153":244,"_42":43,"_41":14,"_155":60,"_39":252,"_13":154,"_34":35,"_36":38,"_24":25,"_160":-5,"_203":253,"_27":254},{"_44":241,"_32":242,"_30":243,"_153":244,"_42":43,"_41":245,"_155":60,"_39":246,"_13":64,"_34":35,"_36":247,"_24":25,"_160":-5,"_203":248,"_27":249},{"_44":234,"_32":235,"_30":236,"_153":178,"_42":43,"_41":157,"_155":60,"_39":237,"_13":64,"_34":20,"_36":238,"_24":25,"_160":-5,"_203":239,"_27":240},{"_44":226,"_32":227,"_30":228,"_153":178,"_42":43,"_41":229,"_155":60,"_39":230,"_13":157,"_34":20,"_36":231,"_24":25,"_160":-5,"_203":232,"_27":233},{"_44":219,"_32":220,"_30":221,"_153":178,"_42":43,"_41":157,"_155":60,"_39":222,"_13":64,"_34":35,"_36":223,"_24":25,"_160":-5,"_203":224,"_27":225},{"_44":169,"_32":170,"_30":171,"_153":-5,"_42":43,"_41":172,"_155":60,"_39":216,"_13":64,"_34":174,"_36":-5,"_24":25,"_160":-5,"_203":217,"_27":218},{"_44":209,"_32":210,"_30":211,"_153":171,"_42":43,"_41":172,"_155":60,"_39":212,"_13":64,"_34":35,"_36":213,"_24":25,"_160":-5,"_203":214,"_27":215},{"_44":162,"_32":163,"_30":164,"_153":-5,"_42":43,"_41":165,"_155":60,"_39":206,"_13":157,"_34":20,"_36":167,"_24":25,"_160":-5,"_203":207,"_27":208},{"_44":151,"_32":152,"_30":58,"_153":-5,"_42":43,"_41":154,"_155":60,"_39":202,"_13":157,"_34":158,"_36":159,"_24":25,"_160":-5,"_203":204,"_27":205},["D",1777643330507],"children",[],[152],["D",1777643380242],[],[163],"81781284-4564-11f1-94d6-42b51c65c3df","types.ts","81781338-4564-11f1-94d6-42b51c65c3df",["D",1777643339620],"export type Todo = {\n id: number;\n text: string;\n done: boolean;\n createdAt: number;\n};\n",[],[170,210],["D",1777643339620],[199],[170],"6da8ae62-4564-11f1-bfed-42b51c65c3df","index.tsx","019de3cc-3d7d-7038-84fe-5814472acae3",["D",1777643306241],"/** @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();",[],[177,220],"8ba62796-4564-11f1-8981-42b51c65c3df","index.html","019de3cc-3d7d-7038-84fe-553ead85ad18",6,["D",1777643356695],"\n\n \n \n \n Todos\n \n \n \n \n

\n \n \n \n\n",[],[177,227],"6da89ea4-4564-11f1-bfed-42b51c65c3df","favicon.svg","019de3cc-3d7d-7038-84fe-500a0ecf9bc7",["D",1777643306241],"\n",[],[177,235],"87f59488-4564-11f1-9529-42b51c65c3df","TodoList.tsx","87f59532-4564-11f1-9529-42b51c65c3df","019de3cc-3d7d-7038-84fe-4fb284662031",4,["D",1777643350513],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Todo } from \"../../shared/types.ts\";\n\nexport function TodoList() {\n const [todos, setTodos] = useState([]);\n const [text, setText] = useState(\"\");\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n fetch(\"/api/todos\")\n .then((r) => r.json())\n .then((data) => {\n setTodos(data);\n setLoading(false);\n });\n }, []);\n\n async function addTodo(e: React.FormEvent) {\n e.preventDefault();\n if (!text.trim()) return;\n const res = await fetch(\"/api/todos\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ text }),\n });\n const newTodo: Todo = await res.json();\n setTodos((prev) => [newTodo, ...prev]);\n setText(\"\");\n }\n\n async function toggleTodo(todo: Todo) {\n // optimistic update\n setTodos((prev) => prev.map((t) => (t.id === todo.id ? { ...t, done: !t.done } : t)));\n await fetch(`/api/todos/${todo.id}`, {\n method: \"PATCH\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ done: !todo.done }),\n });\n }\n\n async function deleteTodo(id: number) {\n setTodos((prev) => prev.filter((t) => t.id !== id));\n await fetch(`/api/todos/${id}`, { method: \"DELETE\" });\n }\n\n const remaining = todos.filter((t) => !t.done).length;\n\n return (\n

\n setText((e.target as HTMLInputElement).value)}\n placeholder=\"What needs to be done?\"\n class=\"flex-1 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n \n Add\n \n \n\n {loading ? (\n

Loading…

\n ) : todos.length === 0 ? (\n

No todos yet — add one above!

\n ) : (\n

\n toggleTodo(todo)}\n class=\"w-5 h-5 cursor-pointer\"\n />\n \n {todo.text}\n \n deleteTodo(todo.id)}\n class=\"text-gray-400 hover:text-red-600 opacity-0 group-hover:opacity-100 transition-opacity\"\n aria-label=\"Delete\"\n >\n ✕\n \n \n ))}\n

\n )}\n\n {todos.length > 0 && (\n

\n {remaining} of {todos.length} remaining\n

\n )}\n

\n );\n}\n",[],[177,250,242],"components","6adab8d6-4584-11f1-b2cc-42b51c65c3df",["D",1777657045566],[],[177,250,33],"6da89b66-4564-11f1-bfed-42b51c65c3df",["D",1777643306241],[193,194],[177,250],["D",1777643306241],[192,195,196,197],[177],["D",1777643306241],["D",1789498239291],{"_104":103,"_111":107},{"_104":103,"_105":-5,"_106":107,"_18":56,"_108":109,"_110":25},{"_13":14,"_32":90,"_44":43,"_91":45,"_92":93,"_94":95,"_96":51,"_97":98,"_99":100,"_101":46,"_102":103},"ctx",{"_83":-5,"_133":300,"_301":302,"_303":304,"_305":25,"_306":25,"_307":25,"_308":60,"_309":-5,"_310":-7,"_311":-7,"_312":64,"_313":25,"_314":25,"_315":-5,"_316":25,"_317":25,"_318":25,"_319":-5},"ENV",{"_271":272,"_273":274,"_275":90,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297,"_298":299},"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 · v9