\n \n \n \n\n",[18,89],"b4fe503e-e0ed-4074-885b-790a502abbaa",["D",1783332896707],"\n",[18,95],"32b40557-9796-4ce5-809a-743e9b065371",["D",1783332896707],[18,100],"pulls","branches","forks","envVars",{"_96":26,"_236":26},"connections",{"_96":26,"_235":26},"unfilledCount","emptyCount",{"_34":202,"_13":18,"_75":111,"_44":-5,"_36":37,"_205":41,"_213":24,"_38":316,"_40":26,"_78":101,"_203":-5,"_80":30,"_206":-5,"_255":317,"_17":318},{"_34":225,"_13":100,"_75":99,"_44":111,"_36":37,"_205":41,"_213":24,"_38":313,"_40":26,"_78":101,"_203":-5,"_80":30,"_206":-5,"_255":314,"_17":315},{"_34":305,"_13":306,"_75":307,"_44":99,"_36":37,"_205":308,"_213":24,"_38":309,"_40":41,"_78":79,"_203":310,"_80":30,"_206":-5,"_255":311,"_17":312},{"_34":297,"_13":298,"_75":299,"_44":99,"_36":37,"_205":300,"_213":24,"_38":301,"_40":26,"_78":79,"_203":302,"_80":30,"_206":-5,"_255":303,"_17":304},{"_34":289,"_13":290,"_75":291,"_44":99,"_36":37,"_205":292,"_213":24,"_38":293,"_40":26,"_78":79,"_203":294,"_80":30,"_206":-5,"_255":295,"_17":296},{"_34":281,"_13":282,"_75":283,"_44":99,"_36":37,"_205":284,"_213":24,"_38":285,"_40":26,"_78":79,"_203":286,"_80":30,"_206":-5,"_255":287,"_17":288},{"_34":274,"_13":275,"_75":276,"_44":99,"_36":37,"_205":97,"_213":24,"_38":277,"_40":26,"_78":79,"_203":278,"_80":30,"_206":-5,"_255":279,"_17":280},{"_34":221,"_13":95,"_75":94,"_44":111,"_36":37,"_205":41,"_213":24,"_38":271,"_40":26,"_78":21,"_203":223,"_80":30,"_206":-5,"_255":272,"_17":273},{"_34":217,"_13":89,"_75":88,"_44":111,"_36":37,"_205":104,"_213":24,"_38":268,"_40":41,"_78":21,"_203":219,"_80":30,"_206":-5,"_255":269,"_17":270},{"_34":212,"_13":77,"_75":76,"_44":111,"_36":37,"_205":41,"_213":24,"_38":265,"_40":26,"_78":79,"_203":215,"_80":30,"_206":-5,"_255":266,"_17":267},{"_34":258,"_13":259,"_75":260,"_44":-5,"_36":37,"_205":151,"_213":24,"_38":261,"_40":41,"_78":21,"_203":262,"_80":30,"_206":-5,"_255":263,"_17":264},{"_34":249,"_13":250,"_75":124,"_44":-5,"_36":37,"_205":251,"_213":24,"_38":252,"_40":41,"_78":253,"_203":254,"_80":30,"_206":-5,"_255":256,"_17":257},"61c2a357-4414-4d25-b175-8965552c6921","index.ts",2,["D",1783332915084],"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\nconst app = new Hono();\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 description TEXT NOT NULL,\n category TEXT NOT NULL DEFAULT 'General',\n date TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n )\n`);\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 routes ──────────────────────────────────────────────────\n\n// List expenses (optional ?category= filter)\napp.get(\"/api/expenses\", async (c) => {\n const category = c.req.query(\"category\");\n if (category && category !== \"All\") {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM expenses WHERE category = ? ORDER BY date DESC, id DESC\",\n args: [category],\n });\n return c.json(result.rows);\n }\n const result = await sqlite.execute(\n \"SELECT * FROM expenses ORDER BY date DESC, id DESC\",\n );\n return c.json(result.rows);\n});\n\n// Create a new expense\napp.post(\"/api/expenses\", async (c) => {\n const body = await c.req.json();\n const { amount, description, category, date } = body;\n\n if (!amount || !description || !date) {\n return c.json({ error: \"amount, description, and date are required\" }, 400);\n }\n\n const result = await sqlite.execute({\n sql: `INSERT INTO expenses (amount, description, category, date) VALUES (?, ?, ?, ?)`,\n args: [Number(amount), String(description), String(category || \"General\"), String(date)],\n });\n\n const row = await sqlite.execute({\n sql: \"SELECT * FROM expenses WHERE id = ?\",\n args: [result.lastInsertRowid],\n });\n\n return c.json(row.rows[0], 201);\n});\n\n// 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: [Number(id)],\n });\n return c.json({ success: true });\n});\n\n// Summary statistics\napp.get(\"/api/stats\", async (c) => {\n const total = await sqlite.execute(\n \"SELECT COALESCE(SUM(amount), 0) as total FROM expenses\",\n );\n const thisMonth = await sqlite.execute({\n sql: `SELECT COALESCE(SUM(amount), 0) as total FROM expenses \n WHERE strftime('%Y-%m', date) = strftime('%Y-%m', 'now')`,\n });\n const byCategory = await sqlite.execute(\n `SELECT category, SUM(amount) as total, COUNT(*) as count \n FROM expenses GROUP BY category ORDER BY total DESC`,\n );\n const count = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM expenses\",\n );\n\n return c.json({\n total: total.rows[0].total,\n thisMonth: thisMonth.rows[0].total,\n count: count.rows[0].count,\n byCategory: byCategory.rows,\n });\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[250],"4818d65d-018d-44ae-8f61-fc3059c2b4a6","README.md","019f36ec-801a-7379-875c-f26ca8918f74",["D",1783332974077],"# 💰 Expense Tracker\n\nA full-stack expense tracker built with React + Hono + SQLite on Val Town.\n\n## Features\n\n- **Add expenses** — amount, description, category, and date\n- **Summary cards** — total spending, this month's total, transaction count\n- **Category breakdown** — visual bars showing spending by category\n- **Filter by category** — clickable chips to filter the expense list\n- **Delete expenses** — remove entries with one click\n- **Persistent storage** — all data saved in val-scoped SQLite\n\n## Live URL\n\nClick the val's HTTP endpoint URL to open the app in your browser.\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 -->|fetch /api/*| API[\"Hono API routes\"]\n API -->|SQL queries| DB[\"SQLite (val-scoped)\"]\n App --> SummaryCards\n App --> ExpenseForm\n App --> ExpenseList\n App --> CategoryBreakdown\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\n favicon.svg ← App icon\n components/\n App.tsx ← Root layout, data fetching, state\n SummaryCards.tsx ← Total / this month / transaction count\n ExpenseForm.tsx ← Add new expense form\n ExpenseList.tsx ← Expense list with category filter + delete\n CategoryBreakdown.tsx ← Spending by category with progress bars\n```\n\n## API\n\n| Method | Route | Description |\n| ------ | -------------------- | ------------------------------- |\n| GET | `/api/expenses` | List all expenses |\n| POST | `/api/expenses` | Create a new expense |\n| DELETE | `/api/expenses/:id` | Delete an expense |\n| GET | `/api/stats` | Summary stats + category totals |\n",[],[259],["D",1783332896707],[],[18,77],["D",1783332921488],[],[18,89],["D",1783332896707],[],[18,95],"1b7a1e15-16ac-4e89-bb19-71a547dd4e12","SummaryCards.tsx","a3d1907e-7923-11f1-896f-1607ee4eb77e",["D",1783332940420],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nfunction formatCurrency(n: number) {\n return new Intl.NumberFormat(\"en-US\", {\n style: \"currency\",\n currency: \"USD\",\n minimumFractionDigits: 2,\n }).format(n);\n}\n\nexport function SummaryCards({ stats }: {\n stats: {\n total: number;\n thisMonth: number;\n count: number;\n };\n}) {\n const cards = [\n {\n label: \"Total Spending\",\n value: formatCurrency(stats.total),\n icon: \"💸\",\n color: \"bg-indigo-50 text-indigo-700 border-indigo-200\",\n },\n {\n label: \"This Month\",\n value: formatCurrency(stats.thisMonth),\n icon: \"📅\",\n color: \"bg-emerald-50 text-emerald-700 border-emerald-200\",\n },\n {\n label: \"Transactions\",\n value: String(stats.count),\n icon: \"🧾\",\n color: \"bg-amber-50 text-amber-700 border-amber-200\",\n },\n ];\n\n return (\n

\n {cards.map((card) => (\n \n

\n {card.label}\n {card.icon}\n

{card.value}

\n ))}\n \n );\n}\n",[],[18,100,275],"cddb1656-e944-43e5-87e8-027bd1fd9201","ExpenseList.tsx","a92e70be-7923-11f1-b059-1607ee4eb77e",7,["D",1783332949429],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nconst CATEGORIES = [\n \"All\",\n \"General\",\n \"Food\",\n \"Transport\",\n \"Shopping\",\n \"Bills\",\n \"Entertainment\",\n \"Health\",\n \"Other\",\n];\n\nconst CATEGORY_BADGES: Record = {\n Food: \"bg-orange-100 text-orange-700\",\n Transport: \"bg-blue-100 text-blue-700\",\n Shopping: \"bg-pink-100 text-pink-700\",\n Bills: \"bg-red-100 text-red-700\",\n Entertainment: \"bg-purple-100 text-purple-700\",\n Health: \"bg-green-100 text-green-700\",\n General: \"bg-gray-100 text-gray-700\",\n Other: \"bg-yellow-100 text-yellow-700\",\n};\n\nfunction formatCurrency(n: number) {\n return new Intl.NumberFormat(\"en-US\", {\n style: \"currency\",\n currency: \"USD\",\n minimumFractionDigits: 2,\n }).format(n);\n}\n\nfunction formatDate(d: string) {\n return new Date(d + \"T00:00:00\").toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n}\n\nexport interface Expense {\n id: number;\n amount: number;\n description: string;\n category: string;\n date: string;\n}\n\nexport function ExpenseList({\n expenses,\n onDelete,\n}: {\n expenses: Expense[];\n onDelete: (id: number) => void;\n}) {\n const [filter, setFilter] = useState(\"All\");\n\n const filtered = filter === \"All\"\n ? expenses\n : expenses.filter((e) => e.category === filter);\n\n return (\n

📝 Expenses

\n {filtered.length} entries\n

\n\n {/* Category filter chips */}\n

\n {CATEGORIES.map((cat) => (\n setFilter(cat)}\n class={`px-3 py-1 text-xs font-medium rounded-full transition-colors cursor-pointer ${\n filter === cat\n ? \"bg-indigo-600 text-white\"\n : \"bg-gray-100 text-gray-600 hover:bg-gray-200\"\n }`}\n >\n {cat}\n \n ))}\n

\n\n {filtered.length === 0\n ? (\n

📭

\n {expenses.length === 0\n ? \"No expenses yet — add one above!\"\n : \"No expenses in this category.\"}\n

\n )\n : (\n

\n {filtered.map((e) => (\n \n

\n {e.description}\n

\n \n {e.category}\n \n \n {formatDate(e.date)}\n \n

\n \n {formatCurrency(e.amount)}\n \n onDelete(e.id)}\n class=\"text-gray-300 hover:text-red-500 transition-colors cursor-pointer p-1\"\n title=\"Delete\"\n >\n ✕\n \n

\n ))}\n

\n )}\n \n );\n}\n",[],[18,100,282],"77a38ec1-9a5a-4cae-bcb7-7fdaac88b08e","ExpenseForm.tsx","a8d4d25c-7923-11f1-9043-1607ee4eb77e",5,["D",1783332948838],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nconst CATEGORIES = [\n \"General\",\n \"Food\",\n \"Transport\",\n \"Shopping\",\n \"Bills\",\n \"Entertainment\",\n \"Health\",\n \"Other\",\n];\n\nfunction todayISO() {\n return new Date().toISOString().slice(0, 10);\n}\n\nexport function ExpenseForm({ onAdd }: { onAdd: () => void }) {\n const [amount, setAmount] = useState(\"\");\n const [description, setDescription] = useState(\"\");\n const [category, setCategory] = useState(\"General\");\n const [date, setDate] = useState(todayISO());\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(\"\");\n\n async function handleSubmit(e: Event) {\n e.preventDefault();\n setError(\"\");\n\n if (!amount || !description || !date) {\n setError(\"All fields are required\");\n return;\n }\n\n setLoading(true);\n try {\n const res = await fetch(\"/api/expenses\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n amount: parseFloat(amount),\n description,\n category,\n date,\n }),\n });\n if (!res.ok) {\n const data = await res.json();\n throw new Error(data.error || \"Failed to add expense\");\n }\n setAmount(\"\");\n setDescription(\"\");\n setCategory(\"General\");\n setDate(todayISO());\n onAdd();\n } catch (err) {\n setError(err.message);\n } finally {\n setLoading(false);\n }\n }\n\n return (\n \n

➕ Add Expense

\n\n {error && (\n

\n {error}\n

\n )}\n\n

\n \n Amount\n \n

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

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

\n\n

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

\n\n

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

\n\n \n {loading ? \"Adding…\" : \"Add Expense\"}\n \n

\n \n );\n}\n",[],[18,100,290],"32f7d7d4-e608-450f-b5b8-27467940827d","CategoryBreakdown.tsx","a9001e08-7923-11f1-b059-1607ee4eb77e",6,["D",1783332949122],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nfunction formatCurrency(n: number) {\n return new Intl.NumberFormat(\"en-US\", {\n style: \"currency\",\n currency: \"USD\",\n minimumFractionDigits: 2,\n }).format(n);\n}\n\nconst CATEGORY_COLORS: Record = {\n Food: \"bg-orange-400\",\n Transport: \"bg-blue-400\",\n Shopping: \"bg-pink-400\",\n Bills: \"bg-red-400\",\n Entertainment: \"bg-purple-400\",\n Health: \"bg-green-400\",\n General: \"bg-gray-400\",\n Other: \"bg-yellow-400\",\n};\n\nexport function CategoryBreakdown({ categories }: {\n categories: Array<{ category: string; total: number; count: number }>;\n}) {\n if (!categories.length) {\n return (\n

📊 By Category

No data yet — add an expense!

\n );\n }\n\n const maxTotal = Math.max(...categories.map((c) => c.total));\n\n return (\n

📊 By Category

\n {categories.map((c) => (\n

\n {c.category}\n \n {formatCurrency(c.total)} · {c.count}{\" \"}\n {c.count === 1 ? \"item\" : \"items\"}\n \n

\n \n

\n ))}\n

\n \n );\n}\n",[],[18,100,298],"891cb42c-cba0-4e28-9922-195899a0bf5b","App.tsx","019f36ec-801a-7379-875c-d6344678b863",8,["D",1783332954404],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState, useCallback } from \"https://esm.sh/react@18.2.0\";\nimport { SummaryCards } from \"./SummaryCards.tsx\";\nimport { ExpenseForm } from \"./ExpenseForm.tsx\";\nimport { ExpenseList, type Expense } from \"./ExpenseList.tsx\";\nimport { CategoryBreakdown } from \"./CategoryBreakdown.tsx\";\n\ninterface Stats {\n total: number;\n thisMonth: number;\n count: number;\n byCategory: Array<{ category: string; total: number; count: number }>;\n}\n\nexport function App() {\n const [expenses, setExpenses] = useState([]);\n const [stats, setStats] = useState({\n total: 0,\n thisMonth: 0,\n count: 0,\n byCategory: [],\n });\n\n const refresh = useCallback(async () => {\n const [expRes, statRes] = await Promise.all([\n fetch(\"/api/expenses\"),\n fetch(\"/api/stats\"),\n ]);\n setExpenses(await expRes.json());\n setStats(await statRes.json());\n }, []);\n\n useEffect(() => {\n refresh();\n }, [refresh]);\n\n const handleDelete = useCallback(async (id: number) => {\n await fetch(`/api/expenses/${id}`, { method: \"DELETE\" });\n refresh();\n }, [refresh]);\n\n return (\n

\n {/* Header */}\n

\n 💰 Expense Tracker\n

\n Track your spending, spot patterns, stay on budget.\n

\n\n {/* Summary cards */}\n

\n \n

\n\n {/* Main grid: form + breakdown (left), list (right) */}\n

\n \n \n

\n \n

\n\n {/* Footer */}\n \n

\n );\n}\n",[],[18,100,306],["D",1783332896707],[239,240,241,242,243],[18,100],["D",1783332896707],[238,244,245,246],[18],["D",1783332896707],["D",1789521041830],{"_11":12,"_168":83},{"_11":12,"_163":164,"_82":83,"_31":81,"_165":166,"_167":30},{"_40":151,"_13":16,"_34":37,"_152":113,"_153":72,"_154":155,"_156":117,"_157":158,"_159":160,"_161":14,"_162":12},"ctx",{"_53":-5,"_189":357,"_358":359,"_360":361,"_362":30,"_363":30,"_364":30,"_365":24,"_366":-5,"_367":-7,"_368":-7,"_369":26,"_370":30,"_371":30,"_372":-5,"_373":30,"_374":30,"_375":30,"_376":-5},"ENV",{"_328":329,"_330":331,"_332":16,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356},"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 · frontend