`, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_292":293,"_294":295},"routes/_app.x.$handle.$name",{"_105":104,"_38":51,"_114":95,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":31,"_129":130,"_131":64,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","a2fb862c-03cd-4ef7-9d7e-df8dbd700617","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","index.ts","latestPath","fileId","01a03bc6-6207-76cc-b747-3d47da3fc315","name","fileType","http","content","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst app = new Hono();\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;\n","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initializeDatabase, seedDemoData } from \"./db/schema.ts\";\n\nconst app = new Hono();\n\n// Initialize database on startup\nlet dbInitialized = false;\n\nconst ensureDatabase = async () => {\n if (!dbInitialized) {\n await initializeDatabase();\n await seedDemoData();\n dbInitialized = true;\n }\n};\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ===== API ENDPOINTS =====\n\n// Get all products\napp.get(\"/api/products\", async (c) => {\n await ensureDatabase();\n const result = await sqlite.execute(\"SELECT id, name, sku, category, price, stock FROM products ORDER BY category, name\");\n return c.json(result.rows);\n});\n\n// Get product by ID\napp.get(\"/api/products/:id\", async (c) => {\n await ensureDatabase();\n const id = c.req.param(\"id\");\n const result = await sqlite.execute(\n \"SELECT id, name, sku, category, price, cost, stock, description FROM products WHERE id = ?\",\n [id]\n );\n if (result.rows.length === 0) {\n return c.json({ error: \"Product not found\" }, 404);\n }\n return c.json(result.rows[0]);\n});\n\n// Create sale transaction\napp.post(\"/api/sales\", async (c) => {\n await ensureDatabase();\n \n const body = await c.req.json() as any;\n const { items, paymentMethod } = body;\n\n if (!items || items.length === 0) {\n return c.json({ error: \"No items in cart\" }, 400);\n }\n\n try {\n // Calculate totals\n let subtotal = 0;\n for (const item of items) {\n subtotal += item.price * item.quantity;\n }\n const vatAmount = subtotal * 0.05;\n const total = subtotal + vatAmount;\n const transactionId = `TXN-${Date.now()}`;\n\n // Insert sale\n const saleResult = await sqlite.execute(\n `INSERT INTO sales (transactionId, total, subtotal, vatAmount, paymentMethod) \n VALUES (?, ?, ?, ?, ?)`,\n [transactionId, total, subtotal, vatAmount, paymentMethod]\n );\n\n const saleId = saleResult.lastInsertRowid;\n\n // Insert sale items and update inventory\n for (const item of items) {\n // Insert sale item\n await sqlite.execute(\n `INSERT INTO sale_items (saleId, productId, quantity, unitPrice, lineTotal) \n VALUES (?, ?, ?, ?, ?)`,\n [saleId, item.id, item.quantity, item.price, item.price * item.quantity]\n );\n\n // Update product stock\n await sqlite.execute(\n \"UPDATE products SET stock = stock - ? WHERE id = ?\",\n [item.quantity, item.id]\n );\n\n // Log inventory movement\n await sqlite.execute(\n \"INSERT INTO inventory (productId, quantity, type, reference) VALUES (?, ?, ?, ?)\",\n [item.id, item.quantity, \"sale\", transactionId]\n );\n }\n\n return c.json({\n success: true,\n transactionId,\n total,\n subtotal,\n vatAmount,\n itemCount: items.length,\n });\n } catch (error) {\n console.error(\"Sale error:\", error);\n return c.json({ error: \"Failed to process sale\" }, 500);\n }\n});\n\n// Get sales report (by date range)\napp.get(\"/api/reports/sales\", async (c) => {\n await ensureDatabase();\n \n const startDate = c.req.query(\"startDate\");\n const endDate = c.req.query(\"endDate\");\n\n let query = \"SELECT id, transactionId, total, subtotal, vatAmount, paymentMethod, createdAt FROM sales WHERE 1=1\";\n const params: any[] = [];\n\n if (startDate) {\n query += \" AND DATE(createdAt) >= DATE(?)\";\n params.push(startDate);\n }\n\n if (endDate) {\n query += \" AND DATE(createdAt) <= DATE(?)\";\n params.push(endDate);\n }\n\n query += \" ORDER BY createdAt DESC\";\n\n const result = await sqlite.execute(query, params);\n\n // Calculate totals\n const totalSales = (result.rows as any[]).reduce((sum, row) => sum + row.total, 0);\n const totalVat = (result.rows as any[]).reduce((sum, row) => sum + row.vatAmount, 0);\n\n return c.json({\n sales: result.rows,\n summary: {\n transactionCount: result.rows.length,\n totalRevenue: totalSales,\n totalVat,\n },\n });\n});\n\n// Get inventory status\napp.get(\"/api/inventory\", async (c) => {\n await ensureDatabase();\n \n const result = await sqlite.execute(\n \"SELECT id, name, sku, category, price, stock FROM products ORDER BY category, name\"\n );\n\n const lowStock = (result.rows as any[]).filter((p) => p.stock < 20);\n\n return c.json({\n products: result.rows,\n stats: {\n totalProducts: result.rows.length,\n lowStockItems: lowStock.length,\n lowStockList: lowStock,\n },\n });\n});\n\n// Update product stock (for inventory management)\napp.post(\"/api/inventory/stock\", async (c) => {\n await ensureDatabase();\n \n const body = await c.req.json() as any;\n const { productId, quantity, type, reference } = body;\n\n try {\n // Update stock\n await sqlite.execute(\n \"UPDATE products SET stock = stock + ? WHERE id = ?\",\n [quantity, productId]\n );\n\n // Log inventory movement\n await sqlite.execute(\n \"INSERT INTO inventory (productId, quantity, type, reference) VALUES (?, ?, ?, ?)\",\n [productId, quantity, type, reference || null]\n );\n\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Stock update error:\", error);\n return c.json({ error: \"Failed to update stock\" }, 500);\n }\n});\n\n// Get dashboard stats\napp.get(\"/api/dashboard\", async (c) => {\n await ensureDatabase();\n \n // Today's sales\n const todaySales = await sqlite.execute(\n \"SELECT SUM(total) as total, COUNT(*) as count FROM sales WHERE DATE(createdAt) = DATE('now')\"\n );\n\n // Low stock products\n const lowStock = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM products WHERE stock < 20\"\n );\n\n // Total products\n const totalProducts = await sqlite.execute(\n \"SELECT COUNT(*) as count FROM products\"\n );\n\n return c.json({\n todaysSales: (todaySales.rows[0] as any)?.total || 0,\n todaysTransactions: (todaySales.rows[0] as any)?.count || 0,\n lowStockAlert: (lowStock.rows[0] as any).count,\n totalProducts: (totalProducts.rows[0] as any).count,\n });\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;\n","createdAt",["D",1787709313189],"branchVersion","branchId","ca6acab9-0471-47bf-83e1-d0aa1c2b75bf","id","541ded6a-9f5e-41f6-b1f6-b7ac30b25722","perfume-pos-uae",["D",1787709252059],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Full-stack POS for UAE perfume retail with inventory & payments","imageUrl","46851fd6-9a47-485b-8891-db89cbf86507","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a03bc5-1b35-7460-96e1-c82089aa770e","tursoName","541ded6a9f5e41f6b1f6b7ac30b25722","tursoHostname","541ded6a9f5e41f6b1f6b7ac30b25722-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789534231467],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":61,"_110":111,"_112":31},"branch",{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"isOwned",12,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jinzstallionz","handle","displayName","Jinz Stallionz","avatar","https://lh3.googleusercontent.com/a/ACg8ocJAWTrFwG6txw3q-fFuNNMyVL9mI_GhIdB1yzX9tJIknRmFMh3P=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":287,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":288,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":289,"_89":290,"_91":291,"_93":31},"tree",[182,184,194,195,196],"files",[182,183,184,185,186,187,188,189,190,191,192,193,194,195,196],"counts",{"_172":68,"_173":145,"_174":68,"_175":176,"_177":178},"contents",[136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":166,"_38":167,"_36":168,"_142":-5,"_47":48,"_46":169,"_143":64,"_44":170,"_13":68,"_39":164,"_41":-5,"_30":31,"_146":-5,"_33":171},{"_49":160,"_38":161,"_36":162,"_142":-5,"_47":48,"_46":145,"_143":64,"_44":163,"_13":68,"_39":164,"_41":-5,"_30":31,"_146":-5,"_33":165},{"_49":154,"_38":155,"_36":156,"_142":-5,"_47":48,"_46":145,"_143":64,"_44":157,"_13":68,"_39":26,"_41":158,"_30":31,"_146":-5,"_33":159},{"_49":148,"_38":149,"_36":150,"_142":-5,"_47":48,"_46":145,"_143":31,"_44":151,"_13":68,"_39":26,"_41":152,"_30":31,"_146":-5,"_33":153},{"_49":141,"_38":34,"_36":37,"_142":-5,"_47":48,"_46":14,"_143":64,"_44":144,"_13":145,"_39":40,"_41":43,"_30":31,"_146":51,"_33":147},"559192ea-7a12-4b59-918c-50f8dbc62ef0","parentId","latest",["D",1787709313189],1,"label",[34],"99639912-69e1-48b7-a065-1ac579a52603","README.md","01a03bc6-6207-76cc-b747-38367f9b29fe",["D",1787709252059],"# 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[\"root.tsx\"]\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 root.tsx ← HTML shell (stamps immutable asset URLs)\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/root.tsx`** is the HTML shell — it loads Twind and stamps\n immutable asset URLs for the favicon and 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\nTemplate updates and upgrade paths for existing remixes: [CHANGELOG.md](/CHANGELOG.md)\n",[149],"b4333182-b6fa-4e90-a520-b9749f84406e","CHANGELOG.md","01a03bc6-6207-76cc-b747-37b7e7cd24e3",["D",1787709252059],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

Diff · v7