➕ Add Expense

{error}

\n \n Amount\n \n

\n \n $\n \n setAmount(e.target.value)}\n placeholder=\"0.00\"\n required\n class=\"w-full pl-7 pr-3 py-2 rounded-lg border border-gray-300 focus:ring-2 focus:ring-blue-400 focus:border-transparent outline-none transition\"\n />\n

\n\n

\n \n Date\n \n setDate(e.target.value)}\n required\n class=\"w-full px-3 py-2 rounded-lg border border-gray-300 focus:ring-2 focus:ring-blue-400 focus:border-transparent outline-none transition\"\n />\n

\n \n Category\n \n setCategory(e.target.value)}\n class=\"w-full px-3 py-2 rounded-lg border border-gray-300 focus:ring-2 focus:ring-blue-400 focus:border-transparent outline-none transition bg-white\"\n >\n {CATEGORIES.map((cat) => (\n \n ))}\n \n

\n \n Description (optional)\n \n setDescription(e.target.value)}\n placeholder=\"What was it for?\"\n class=\"w-full px-3 py-2 rounded-lg border border-gray-300 focus:ring-2 focus:ring-blue-400 focus:border-transparent outline-none transition\"\n />\n

\n {loading ? \"Adding...\" : \"Add Expense\"}\n \n \n );\n}\n","createdAt",["D",1784306555458],"branchVersion","branchId","a982a973-90b0-4212-a175-5038de968ece","id","4e418b59-ab97-4108-b1fa-6201c9efa5a0","expenses-tracker",["D",1784306518202],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Track expenses with categories, amounts, and a summary dashboard","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789545599&sig=91cfcc631bd9f3dd8274549c04838d172adf2572755982193460d49bfd04bd62","7c1318b7-a61a-42ba-b56d-1c91b3511153","pinnedFileId","019f70f4-c933-741e-92e7-5076c99d777a","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f70ed-cc64-70ba-bd3d-918542477ad7","tursoName","4e418b59ab974108b1fa6201c9efa5a0","tursoHostname","4e418b59ab974108b1fa6201c9efa5a0-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_110":109,"_118":114},"org",{"_110":109,"_111":112,"_113":114,"_19":61,"_115":116,"_117":30},"branch",{"_13":95,"_37":96,"_48":47,"_97":49,"_98":99,"_100":101,"_102":55,"_103":104,"_105":106,"_107":50,"_108":109},"isOwned",9,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",89,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","rizmafarhanas","handle","displayName","Rizma Farhana S","avatar","https://lh3.googleusercontent.com/a/ACg8ocLod4s2OWCSx1qq0JGisFRzjNW2gIoJezW0PrVZLhOqA_fbT3g=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":247,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":60,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":248,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":249,"_90":250,"_92":251,"_94":30},"tree",[190,197,198],"files",[190,191,192,193,194,195,196,197,198],"counts",{"_180":69,"_181":163,"_182":69,"_183":184,"_185":186},"contents",[154,155,156],"upstreamProject",{"_48":104,"_37":150,"_57":151,"_59":60,"_54":55,"_88":152},"upstreamBranch",{"_48":99,"_43":143,"_144":145,"_37":96,"_97":104,"_13":146,"_98":-5,"_100":-5,"_147":148,"_52":-5,"_94":30,"_54":55,"_108":149,"_70":106,"_107":150},"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","Starter template with client-side React & Hono server",{"_110":149,"_118":153},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789545599&sig=2316df07e67031dd48e537f6ce0c4c14b92716fed790ec83ecf27974cc65aa31",{"_48":174,"_37":175,"_35":176,"_159":-5,"_46":47,"_45":163,"_161":65,"_43":177,"_13":69,"_39":178,"_41":-5,"_29":30,"_166":-5,"_32":179},{"_48":168,"_37":169,"_35":170,"_159":-5,"_46":47,"_45":163,"_161":30,"_43":171,"_13":69,"_39":26,"_41":172,"_29":30,"_166":-5,"_32":173},{"_48":157,"_37":158,"_35":63,"_159":-5,"_46":47,"_45":160,"_161":65,"_43":162,"_13":163,"_39":164,"_41":165,"_29":30,"_166":-5,"_32":167},"d4578a33-4efe-4df5-9d36-43604d540f15","index.ts","parentId",2,"latest",["D",1784306530932],1,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// --- Database setup ---\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS expenses (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n amount REAL NOT NULL,\n category TEXT NOT NULL,\n description TEXT DEFAULT '',\n date TEXT NOT NULL\n )\n`);\n\nconst app = new Hono();\n\n// --- Serve 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: List all expenses ---\napp.get(\"/api/expenses\", async () => {\n const result = await sqlite.execute(\n \"SELECT * FROM expenses ORDER BY date DESC, id DESC\",\n );\n return Response.json(result.rows);\n});\n\n// --- API: Add an expense ---\napp.post(\"/api/expenses\", async (c) => {\n const body = await c.req.json();\n const { amount, category, description, date } = body;\n\n if (!amount || !category || !date) {\n return c.json({ error: \"amount, category, and date are required\" }, 400);\n }\n\n const result = await sqlite.execute({\n sql: \"INSERT INTO expenses (amount, category, description, date) VALUES (?, ?, ?, ?)\",\n args: [amount, category, description ?? \"\", date],\n });\n\n return c.json({\n id: Number(result.lastInsertRowid),\n amount,\n category,\n description: description ?? \"\",\n date,\n }, 201);\n});\n\n// --- API: Delete an expense ---\napp.delete(\"/api/expenses/:id\", async (c) => {\n const id = c.req.param(\"id\");\n await sqlite.execute({\n sql: \"DELETE FROM expenses WHERE id = ?\",\n args: [id],\n });\n return c.json({ ok: true });\n});\n\n// --- API: Summary (total + breakdown by category) ---\napp.get(\"/api/summary\", async () => {\n const totalResult = await sqlite.execute(\n \"SELECT COALESCE(SUM(amount), 0) as total FROM expenses\",\n );\n const categoryResult = await sqlite.execute(\n \"SELECT category, SUM(amount) as total FROM expenses GROUP BY category ORDER BY total DESC\",\n );\n\n return Response.json({\n total: totalResult.rows[0].total,\n byCategory: categoryResult.rows,\n });\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[158],"134950d7-87d6-42df-8a3c-21b616d347bd","README.md","019f70f4-c933-741e-92e7-4ff4f168893c",["D",1784306518202],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n",[169],"d7d9f853-3e98-4d9d-ac21-54a4dd56e689","frontend","019f70f4-c933-741e-92e7-483b32d84f69",["D",1784306518202],"directory",[175],"pulls","branches","forks","envVars",{"_187":69,"_189":69},"connections",{"_187":69,"_188":69},"count","unfilledCount","emptyCount",{"_48":174,"_37":175,"_35":176,"_159":-5,"_46":47,"_45":163,"_161":65,"_43":244,"_13":69,"_39":178,"_41":-5,"_29":30,"_166":-5,"_200":245,"_32":246},{"_48":240,"_37":232,"_35":228,"_159":176,"_46":47,"_45":163,"_161":65,"_43":241,"_13":69,"_39":178,"_41":-5,"_29":30,"_166":-5,"_200":242,"_32":243},{"_48":233,"_37":234,"_35":235,"_159":228,"_46":47,"_45":163,"_161":30,"_43":236,"_13":69,"_39":40,"_41":237,"_29":30,"_166":-5,"_200":238,"_32":239},{"_48":227,"_37":38,"_35":36,"_159":228,"_46":47,"_45":14,"_161":65,"_43":229,"_13":69,"_39":40,"_41":42,"_29":30,"_166":-5,"_200":230,"_32":231},{"_48":220,"_37":221,"_35":222,"_159":176,"_46":47,"_45":163,"_161":65,"_43":223,"_13":69,"_39":26,"_41":224,"_29":30,"_166":-5,"_200":225,"_32":226},{"_48":213,"_37":214,"_35":215,"_159":176,"_46":47,"_45":163,"_161":30,"_43":216,"_13":69,"_39":26,"_41":217,"_29":30,"_166":-5,"_200":218,"_32":219},{"_48":206,"_37":207,"_35":208,"_159":176,"_46":47,"_45":163,"_161":65,"_43":209,"_13":69,"_39":40,"_41":210,"_29":30,"_166":-5,"_200":211,"_32":212},{"_48":168,"_37":169,"_35":170,"_159":-5,"_46":47,"_45":163,"_161":30,"_43":203,"_13":69,"_39":26,"_41":172,"_29":30,"_166":-5,"_200":204,"_32":205},{"_48":157,"_37":158,"_35":63,"_159":-5,"_46":47,"_45":160,"_161":65,"_43":199,"_13":163,"_39":164,"_41":165,"_29":30,"_166":-5,"_200":201,"_32":202},["D",1784306530932],"children",[],[158],["D",1784306518202],[],[169],"91d94ec7-bb5d-4251-886c-ed35a192397c","index.tsx","019f70f4-c933-741e-92e7-46c1c300e105",["D",1784306518202],"/** @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();",[],[175,207],"737aee85-9af3-4371-a0f7-549511e2e45c","index.html","019f70f4-c933-741e-92e7-41d0f45c2259",["D",1784306518202],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[175,214],"8c513f2c-a950-42a1-841c-ad8834f7d86e","favicon.svg","019f70f4-c933-741e-92e7-3e527ce95521",["D",1784306518202],"\n",[],[175,221],"cfdb9055-b99e-49c4-aa7f-d40395204771","019f70f4-c933-741e-92e7-39049856c834",["D",1784306555458],[],[175,232,38],"components","4569cc2b-0d54-4d75-9b7d-156c09e702ac","App.tsx","019f70f4-c932-773f-882f-8386e5e772f7",["D",1784306518202],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Counter } from \"./Counter.tsx\";\n\nexport function App() {\n return (\n

React + Hono Starter

\n \n

\n View source\n

\n );\n}\n",[],[175,232,234],"f50fa858-87c9-4379-80b4-c3c3f1b571d1",["D",1784306518202],[192,193],[175,232],["D",1784306518202],[191,194,195,196],[175],["D",1784306518202],["D",1789472446807],{"_110":109,"_118":114},{"_110":109,"_111":112,"_113":114,"_19":61,"_115":116,"_117":30},{"_13":95,"_37":96,"_48":47,"_97":49,"_98":99,"_100":101,"_102":55,"_103":104,"_105":106,"_107":50,"_108":109},"ctx",{"_88":-5,"_140":285,"_286":287,"_288":289,"_290":30,"_291":30,"_292":30,"_293":65,"_294":-5,"_295":-7,"_296":-7,"_297":69,"_298":30,"_299":30,"_300":-5,"_301":30,"_302":30,"_303":30,"_304":-5},"ENV",{"_256":257,"_258":259,"_260":96,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284},"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 · v4