\n \n \n \n\n",[18,89],"6da89ea4-4564-11f1-bfed-42b51c65c3df",["D",1777643306241],"\n",[18,95],"6da89b66-4564-11f1-bfed-42b51c65c3df",["D",1777643306241],[18,100],"pulls","branches","forks","envVars",{"_96":26,"_234":26},"connections",{"_96":26,"_233":26},"unfilledCount","emptyCount",{"_34":200,"_13":18,"_75":111,"_44":-5,"_36":37,"_201":41,"_202":24,"_38":303,"_40":26,"_78":101,"_204":-5,"_80":30,"_205":-5,"_252":304,"_17":305},{"_34":223,"_13":100,"_75":99,"_44":111,"_36":37,"_201":41,"_202":24,"_38":300,"_40":26,"_78":101,"_204":-5,"_80":30,"_205":-5,"_252":301,"_17":302},{"_34":293,"_13":294,"_75":295,"_44":99,"_36":37,"_201":150,"_202":24,"_38":296,"_40":248,"_78":79,"_204":297,"_80":30,"_205":-5,"_252":298,"_17":299},{"_34":286,"_13":287,"_75":288,"_44":99,"_36":37,"_201":97,"_202":24,"_38":289,"_40":26,"_78":79,"_204":290,"_80":30,"_205":-5,"_252":291,"_17":292},{"_34":219,"_13":95,"_75":94,"_44":111,"_36":37,"_201":41,"_202":24,"_38":283,"_40":26,"_78":21,"_204":221,"_80":30,"_205":-5,"_252":284,"_17":285},{"_34":215,"_13":89,"_75":88,"_44":111,"_36":37,"_201":104,"_202":24,"_38":280,"_40":41,"_78":21,"_204":217,"_80":30,"_205":-5,"_252":281,"_17":282},{"_34":211,"_13":77,"_75":76,"_44":111,"_36":37,"_201":41,"_202":24,"_38":277,"_40":26,"_78":79,"_204":213,"_80":30,"_205":-5,"_252":278,"_17":279},{"_34":273,"_13":272,"_75":266,"_44":-5,"_36":37,"_201":267,"_202":24,"_38":274,"_40":26,"_78":101,"_204":-5,"_80":30,"_205":-5,"_252":275,"_17":276},{"_34":263,"_13":264,"_75":265,"_44":266,"_36":37,"_201":267,"_202":24,"_38":268,"_40":26,"_78":79,"_204":269,"_80":30,"_205":-5,"_252":270,"_17":271},{"_34":255,"_13":256,"_75":257,"_44":-5,"_36":37,"_201":258,"_202":24,"_38":259,"_40":41,"_78":21,"_204":260,"_80":30,"_205":-5,"_252":261,"_17":262},{"_34":246,"_13":247,"_75":123,"_44":-5,"_36":37,"_201":248,"_202":24,"_38":249,"_40":41,"_78":250,"_204":251,"_80":30,"_205":-5,"_252":253,"_17":254},"7c0d4fa8-4564-11f1-94d6-42b51c65c3df","index.ts",2,["D",1777643330507],"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","children",[],[247],"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",[],[256],"81781284-4564-11f1-94d6-42b51c65c3df","types.ts","81781338-4564-11f1-94d6-42b51c65c3df","359d9061-b7ff-476e-9a59-9f122be48e8a",3,["D",1777643339620],"export type Todo = {\n id: number;\n text: string;\n done: boolean;\n createdAt: number;\n};\n",[],[272,264],"shared","81781c02-4564-11f1-94d6-42b51c65c3df",["D",1777643339620],[243],[272],["D",1777643306241],[],[18,77],["D",1777643356695],[],[18,89],["D",1777643306241],[],[18,95],"87f59488-4564-11f1-9529-42b51c65c3df","TodoList.tsx","87f59532-4564-11f1-9529-42b51c65c3df",["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",[],[18,100,287],"6adab8d6-4584-11f1-b2cc-42b51c65c3df","App.tsx","019de3cc-3d7d-7038-84fe-47c850c8848d",["D",1777657045566],"/** @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}",[],[18,100,294],["D",1777643306241],[237,238],[18,100],["D",1777643306241],[236,239,240,241],[18],["D",1777643306241],["D",1789498239291],{"_11":12,"_166":83},{"_11":12,"_162":-5,"_82":83,"_31":81,"_163":164,"_165":30},{"_40":150,"_13":16,"_34":37,"_151":113,"_152":72,"_153":154,"_155":117,"_156":157,"_158":159,"_160":14,"_161":12},"ctx",{"_53":-5,"_187":344,"_345":346,"_347":348,"_349":30,"_350":30,"_351":30,"_352":24,"_353":-5,"_354":-7,"_355":-7,"_356":26,"_357":30,"_358":30,"_359":-5,"_360":30,"_361":30,"_362":30,"_363":-5},"ENV",{"_315":316,"_317":318,"_319":16,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343},"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"]

History · frontend