\n \n \n \n\n","019de3cc-3d7d-7038-84fe-5c3481c5a8d7",["D",1777643356695],"branchVersion","label",[180,68],"frontend","pulls","branches","forks","envVars",{"_188":26,"_190":26},"connections",{"_188":26,"_189":26},"count","unfilledCount","emptyCount",{"_33":274,"_13":180,"_66":175,"_43":-5,"_35":36,"_177":40,"_205":96,"_37":275,"_39":26,"_69":233,"_173":-5,"_70":24,"_178":-5,"_209":276,"_17":277},{"_33":270,"_13":262,"_66":256,"_43":175,"_35":36,"_177":40,"_205":96,"_37":271,"_39":26,"_69":233,"_173":-5,"_70":24,"_178":-5,"_209":272,"_17":273},{"_33":263,"_13":264,"_66":265,"_43":256,"_35":36,"_177":122,"_205":96,"_37":266,"_39":204,"_69":226,"_173":267,"_70":24,"_178":-5,"_209":268,"_17":269},{"_33":253,"_13":254,"_66":255,"_43":256,"_35":36,"_177":257,"_205":96,"_37":258,"_39":26,"_69":226,"_173":259,"_70":24,"_178":-5,"_209":260,"_17":261},{"_33":246,"_13":247,"_66":248,"_43":175,"_35":36,"_177":40,"_205":96,"_37":249,"_39":26,"_69":21,"_173":250,"_70":24,"_178":-5,"_209":251,"_17":252},{"_33":172,"_13":68,"_66":67,"_43":175,"_35":36,"_177":76,"_205":96,"_37":243,"_39":40,"_69":21,"_173":174,"_70":24,"_178":-5,"_209":244,"_17":245},{"_33":236,"_13":237,"_66":238,"_43":175,"_35":36,"_177":40,"_205":96,"_37":239,"_39":26,"_69":226,"_173":240,"_70":24,"_178":-5,"_209":241,"_17":242},{"_33":231,"_13":230,"_66":223,"_43":-5,"_35":36,"_177":224,"_205":96,"_37":232,"_39":26,"_69":233,"_173":-5,"_70":24,"_178":-5,"_209":234,"_17":235},{"_33":220,"_13":221,"_66":222,"_43":223,"_35":36,"_177":224,"_205":96,"_37":225,"_39":26,"_69":226,"_173":227,"_70":24,"_178":-5,"_209":228,"_17":229},{"_33":212,"_13":213,"_66":214,"_43":-5,"_35":36,"_177":215,"_205":96,"_37":216,"_39":40,"_69":21,"_173":217,"_70":24,"_178":-5,"_209":218,"_17":219},{"_33":202,"_13":203,"_66":94,"_43":-5,"_35":36,"_177":204,"_205":96,"_37":206,"_39":40,"_69":207,"_173":208,"_70":24,"_178":-5,"_209":210,"_17":211},"7c0d4fa8-4564-11f1-94d6-42b51c65c3df","index.ts",2,"latest",["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",[],[203],"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",[],[213],"81781284-4564-11f1-94d6-42b51c65c3df","types.ts","81781338-4564-11f1-94d6-42b51c65c3df","359d9061-b7ff-476e-9a59-9f122be48e8a",3,["D",1777643339620],"script","export type Todo = {\n id: number;\n text: string;\n done: boolean;\n createdAt: number;\n};\n",[],[230,221],"shared","81781c02-4564-11f1-94d6-42b51c65c3df",["D",1777643339620],"directory",[199],[230],"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();",[],[180,237],["D",1777643356695],[],[180,68],"6da89ea4-4564-11f1-bfed-42b51c65c3df","favicon.svg","019de3cc-3d7d-7038-84fe-500a0ecf9bc7",["D",1777643306241],"\n",[],[180,247],"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",[],[180,262,254],"components","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}",[],[180,262,264],"6da89b66-4564-11f1-bfed-42b51c65c3df",["D",1777643306241],[193,194],[180,262],"6da8b2cc-4564-11f1-bfed-42b51c65c3df",["D",1777643306241],[192,195,196,197],[180],["D",1777643306241],["D",1789498239291],{"_11":12,"_138":73},{"_11":12,"_134":-5,"_72":73,"_30":71,"_135":136,"_137":24},{"_39":122,"_13":16,"_33":36,"_123":84,"_124":63,"_125":126,"_127":88,"_128":129,"_130":131,"_132":14,"_133":12},"ctx",{"_52":-5,"_159":316,"_317":318,"_319":320,"_321":24,"_322":24,"_323":24,"_324":96,"_325":-5,"_326":-7,"_327":-7,"_328":26,"_329":24,"_330":24,"_331":-5,"_332":24,"_333":24,"_334":24,"_335":-5},"ENV",{"_287":288,"_289":290,"_291":16,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315},"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"]

History · index.html