`, 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",{"_367":368,"_369":370},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_274":-5,"_20":275,"_22":276,"_277":278,"_279":280,"_26":281,"_24":282,"_283":-5,"_284":-5,"_285":55,"_286":287,"_288":46,"_289":-5,"_290":-5,"_291":292},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","thimbunhuv","name","ecommerce-fullstack","branchName","main","version","path","api","project",{"_34":217,"_13":14,"_47":218,"_219":-5,"_220":55,"_221":222,"_223":222,"_224":225,"_226":-5,"_227":228,"_229":70,"_230":46,"_231":-5,"_232":-5,"_233":49,"_234":235,"_236":237,"_238":239,"_240":241,"_242":-5,"_243":244,"_245":244,"_246":247,"_248":247,"_249":247,"_250":244,"_251":244,"_252":253,"_254":255,"_256":257,"_258":55},"tree",[62,63,64,65,66,67],"file",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":59,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_18":61},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","c4b1fdfd-d2ea-4dcb-96ad-989022c7ea13","routes.ts","fileId","4ab1c9e8-adc4-11f1-9997-1607ee4eb77e","parentId","3dad3ae0-86bd-4de4-a381-259e50143d4d","branchId","6b84f907-9e8f-45d7-a71c-56a2a983dc31","branchVersion",4,"latest",true,"createdAt",["D",1789119400342],0,"fileType","script","content","import { Hono } from \"npm:hono\";\nimport { getCookie, setCookie } from \"npm:hono/cookie\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initSchema } from \"../db/schema.ts\";\n\nlet ready: Promise | null = null;\nfunction ensureReady() {\n if (!ready) ready = initSchema();\n return ready;\n}\n\nfunction sessionId(c: any): string {\n let sid = getCookie(c, \"session_id\");\n if (!sid) {\n sid = crypto.randomUUID();\n setCookie(c, \"session_id\", sid, { path: \"/\", httpOnly: true, maxAge: 60 * 60 * 24 * 30 });\n }\n return sid;\n}\n\nexport const api = new Hono();\n\napi.use(\"*\", async (c, next) => {\n await ensureReady();\n await next();\n});\n\n// ---- Products ----\napi.get(\"/products\", async (c) => {\n const { rows } = await sqlite.execute(\"SELECT * FROM products ORDER BY id\");\n return c.json(rows);\n});\n\napi.get(\"/products/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { rows } = await sqlite.execute({ sql: \"SELECT * FROM products WHERE id = ?\", args: [id] });\n if (rows.length === 0) return c.json({ error: \"Not found\" }, 404);\n return c.json(rows[0]);\n});\n\n// ---- Cart ----\napi.get(\"/cart\", async (c) => {\n const sid = sessionId(c);\n const { rows } = await sqlite.execute({\n sql: `SELECT ci.id, ci.product_id, ci.quantity, p.name, p.price, p.emoji, p.stock\n FROM cart_items ci JOIN products p ON p.id = ci.product_id\n WHERE ci.session_id = ? ORDER BY ci.id`,\n args: [sid],\n });\n const total = rows.reduce((sum: number, r: any) => sum + r.price * r.quantity, 0);\n return c.json({ items: rows, total });\n});\n\napi.post(\"/cart\", async (c) => {\n const sid = sessionId(c);\n const body = await c.req.json<{ productId: number; quantity?: number }>();\n const qty = body.quantity ?? 1;\n\n const { rows: prodRows } = await sqlite.execute({\n sql: \"SELECT * FROM products WHERE id = ?\",\n args: [body.productId],\n });\n if (prodRows.length === 0) return c.json({ error: \"Product not found\" }, 404);\n\n const { rows: existing } = await sqlite.execute({\n sql: \"SELECT * FROM cart_items WHERE session_id = ? AND product_id = ?\",\n args: [sid, body.productId],\n });\n\n if (existing.length > 0) {\n await sqlite.execute({\n sql: \"UPDATE cart_items SET quantity = quantity + ? WHERE session_id = ? AND product_id = ?\",\n args: [qty, sid, body.productId],\n });\n } else {\n await sqlite.execute({\n sql: \"INSERT INTO cart_items (session_id, product_id, quantity) VALUES (?, ?, ?)\",\n args: [sid, body.productId, qty],\n });\n }\n return c.json({ ok: true });\n});\n\napi.patch(\"/cart/:productId\", async (c) => {\n const sid = sessionId(c);\n const productId = Number(c.req.param(\"productId\"));\n const body = await c.req.json<{ quantity: number }>();\n\n if (body.quantity <= 0) {\n await sqlite.execute({\n sql: \"DELETE FROM cart_items WHERE session_id = ? AND product_id = ?\",\n args: [sid, productId],\n });\n } else {\n await sqlite.execute({\n sql: \"UPDATE cart_items SET quantity = ? WHERE session_id = ? AND product_id = ?\",\n args: [body.quantity, sid, productId],\n });\n }\n return c.json({ ok: true });\n});\n\napi.delete(\"/cart/:productId\", async (c) => {\n const sid = sessionId(c);\n const productId = Number(c.req.param(\"productId\"));\n await sqlite.execute({\n sql: \"DELETE FROM cart_items WHERE session_id = ? AND product_id = ?\",\n args: [sid, productId],\n });\n return c.json({ ok: true });\n});\n\n// ---- Checkout / Orders ----\napi.post(\"/checkout\", async (c) => {\n const sid = sessionId(c);\n const body = await c.req.json<{ name: string; email: string }>();\n\n const { rows: items } = await sqlite.execute({\n sql: `SELECT ci.product_id, ci.quantity, p.name, p.price\n FROM cart_items ci JOIN products p ON p.id = ci.product_id\n WHERE ci.session_id = ?`,\n args: [sid],\n });\n\n if (items.length === 0) return c.json({ error: \"Cart is empty\" }, 400);\n\n const total = items.reduce((sum: number, r: any) => sum + r.price * r.quantity, 0);\n\n const orderResult = await sqlite.execute({\n sql: \"INSERT INTO orders (session_id, customer_name, customer_email, total) VALUES (?, ?, ?, ?)\",\n args: [sid, body.name, body.email, total],\n });\n const orderId = Number(orderResult.lastInsertRowid);\n\n const statements = items.map((r: any) => ({\n sql: \"INSERT INTO order_items (order_id, product_id, product_name, unit_price, quantity) VALUES (?, ?, ?, ?, ?)\",\n args: [orderId, r.product_id, r.name, r.price, r.quantity],\n }));\n statements.push({ sql: \"DELETE FROM cart_items WHERE session_id = ?\", args: [sid] } as any);\n await sqlite.batch(statements as any);\n\n return c.json({ ok: true, orderId, total });\n});\n\napi.get(\"/orders/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const { rows: orderRows } = await sqlite.execute({ sql: \"SELECT * FROM orders WHERE id = ?\", args: [id] });\n if (orderRows.length === 0) return c.json({ error: \"Not found\" }, 404);\n const { rows: itemRows } = await sqlite.execute({\n sql: \"SELECT * FROM order_items WHERE order_id = ?\",\n args: [id],\n });\n return c.json({ ...orderRows[0], items: itemRows });\n});\n","deleted",false,"label",[19,36],"fdff1be4-c35d-4c17-b65e-14d1fb2b286e",["D",1789119400342],"directory",[19],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":210,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_77":211,"_18":212},{"_34":194,"_13":195,"_37":196,"_39":-5,"_41":42,"_43":197,"_45":46,"_47":198,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_77":199,"_18":200},{"_34":95,"_13":96,"_37":97,"_39":-5,"_41":42,"_43":73,"_45":46,"_47":98,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_77":99,"_18":100},{"_34":88,"_13":89,"_37":90,"_39":-5,"_41":42,"_43":73,"_45":46,"_47":91,"_17":49,"_50":24,"_52":92,"_54":55,"_56":-5,"_77":93,"_18":94},{"_34":80,"_13":81,"_37":82,"_39":-5,"_41":42,"_43":83,"_45":46,"_47":84,"_17":73,"_50":24,"_52":85,"_54":55,"_56":-5,"_77":86,"_18":87},{"_34":68,"_13":69,"_37":70,"_39":-5,"_41":42,"_43":71,"_45":46,"_47":72,"_17":73,"_50":74,"_52":75,"_54":55,"_56":76,"_77":78,"_18":79},"0ed376b4-0951-4732-965d-7e23e2ea3bb0","index.ts","01a08fd2-faaf-742b-b80a-89f8be99ffa6",5,["D",1789119406023],1,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\nimport { api } from \"./api/routes.ts\";\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// API routes\napp.route(\"/api\", api);\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","thimbunhuv-ecommerce","children",[],[69],"84c5ac83-ef78-4caa-b847-a733e7845ca4","README.md","01a08fd2-faaf-742b-b80a-850b9087b214",13,["D",1789119492626],"# 🛍️ Fullstack Ecommerce (Hono + React + SQLite)\n\nA fullstack ecommerce demo on Val Town. Val Town runs Deno (TypeScript), not\nPython, so this uses **Hono** — a lightweight web framework with the same\nroute/middleware feel as FastAPI — instead of FastAPI itself.\n\n[Open the shop](url:index.ts)\n\n## Stack\n\n- **Backend**: Hono REST API (`api/routes.ts`), cookie-based session cart\n- **Database**: Val Town SQLite (`db/schema.ts`) — products, cart, orders, order_items\n- **Frontend**: Client-side React SPA (`frontend/`), Twind for styling\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|GET /| Hono[\"index.ts (Hono)\"]\n Hono -->|serves| Root[\"frontend/root.tsx\"]\n Root -->|loads| App[\"frontend/components/App.tsx\"]\n App --> ProductList\n App --> CartPanel\n App --> Checkout\n Browser -.->|fetch /api/*| API[\"api/routes.ts\"]\n API --> DB[(SQLite)]\n```\n\n## API routes\n\n| Method | Path | Description |\n| --- | --- | --- |\n| GET | `/api/products` | List all products |\n| GET | `/api/products/:id` | Get one product |\n| GET | `/api/cart` | Get current session's cart |\n| POST | `/api/cart` | Add item to cart `{ productId, quantity }` |\n| PATCH | `/api/cart/:productId` | Update quantity `{ quantity }` (0 removes) |\n| DELETE | `/api/cart/:productId` | Remove item from cart |\n| POST | `/api/checkout` | Place order `{ name, email }`, clears cart |\n| GET | `/api/orders/:id` | Get an order + its line items |\n\n## File structure\n\n```\nindex.ts ← Hono entrypoint (serves frontend + /api)\napi/routes.ts ← All REST API routes\ndb/schema.ts ← SQLite schema + seed data\nfrontend/\n root.tsx ← HTML shell\n index.tsx ← React entrypoint\n lib/api.ts ← Typed fetch client for the API\n components/\n App.tsx ← Root layout / view router\n ProductList.tsx ← Product grid\n CartPanel.tsx ← Cart sidebar\n Checkout.tsx ← Checkout form\n OrderConfirmation.tsx ← Post-order confirmation\n```\n\n## Next steps\n\n- Add product images/categories\n- Add an admin view to manage inventory\n- Add auth so orders are tied to real user accounts instead of a cart cookie\n",[],[81],"8fa491da-7567-43d0-8e01-e9d19fff6f8f","CHANGELOG.md","01a08fd2-faaf-742b-b80a-825098e8b7ab",["D",1789119363697],"# 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