NEXUS SCHOOL OS

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_257":258,"_259":260},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_192":-5,"_20":193,"_22":194,"_195":196,"_197":198,"_26":199,"_24":200,"_201":-5,"_202":-5,"_203":59,"_204":205,"_206":56,"_207":-5,"_208":-5,"_209":210},"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","alizhan0818","name","nexus-school-os","branchName","main","version","path","index.ts","project",{"_33":134,"_13":14,"_45":135,"_136":-5,"_137":59,"_138":139,"_140":139,"_141":142,"_143":-5,"_144":145,"_146":38,"_147":56,"_148":-5,"_149":-5,"_150":68,"_151":152,"_153":154,"_155":156,"_157":158,"_159":-5,"_160":161,"_162":161,"_163":164,"_165":164,"_166":164,"_167":161,"_168":161,"_169":170,"_171":172,"_173":174,"_175":59},"tree",[51,52,53,54],"file",{"_33":34,"_35":36,"_37":38,"_13":19,"_39":40,"_41":42,"_17":43,"_44":-5,"_45":46,"_47":48,"_49":-5,"_18":50},"contents",[],"upstream","pull","ahead","behind","envVars","id","03163139-2ca1-42f0-9228-472822cf42f1","branchId","eba0ae0b-c46f-4d1f-8076-2d4e48288fc4","fileId","01a081fe-8a60-7580-867f-1fc231bac9ef","content","import { Hono } from \"npm:hono\";\nimport { cors } from \"npm:hono/cors\";\nimport { sqlite as db } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst app = new Hono();\napp.use(\"*\", cors());\n\nconst q = async (strings: TemplateStringsArray, ...values: unknown[]) => {\n const sql = strings.reduce((out, s, i) => out + s + (i < values.length ? \"?\" : \"\"), \"\");\n return db.execute({ sql, args: values as any[] });\n};\n\nawait q`CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT UNIQUE NOT NULL, pin_hash TEXT NOT NULL, balance INTEGER NOT NULL DEFAULT 100000, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`;\nawait q`CREATE TABLE IF NOT EXISTS transactions (id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, kind TEXT NOT NULL, amount INTEGER NOT NULL, note TEXT, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`;\nawait q`CREATE TABLE IF NOT EXISTS notes (id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, title TEXT NOT NULL, body TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`;\n\nconst hash = async (s:string) => {\n const b = await crypto.subtle.digest(\"SHA-256\", new TextEncoder().encode(s));\n return [...new Uint8Array(b)].map(x=>x.toString(16).padStart(2,\"0\")).join(\"\");\n};\nconst json = (c:any, data:any, status=200) => c.json(data,status);\n\napp.get(\"/api/health\", c => json(c,{ok:true,app:\"NEXUS SCHOOL OS\",version:\"1.0\"}));\n\napp.post(\"/api/register\", async c => {\n const {name,pin}=await c.req.json();\n if(!name || !/^\\\\d{4,8}$/.test(String(pin))) return json(c,{error:\"Имя и PIN 4–8 цифр обязательны\"},400);\n try {\n const r=await q`INSERT INTO users (name,pin_hash) VALUES (${String(name).trim()},${await hash(String(pin))}) RETURNING id,name,balance`;\n return json(c,{user:r.rows[0]});\n } catch { return json(c,{error:\"Пользователь уже существует\"},409); }\n});\n\napp.post(\"/api/login\", async c => {\n const {name,pin}=await c.req.json();\n const r=await q`SELECT id,name,balance FROM users WHERE name=${String(name||\"\").trim()} AND pin_hash=${await hash(String(pin||\"\"))}`;\n return r.rows.length ? json(c,{user:r.rows[0]}) : json(c,{error:\"Неверные данные\"},401);\n});\n\napp.get(\"/api/dashboard\", async c => {\n const id=Number(c.req.query(\"user_id\"));\n const u=await q`SELECT id,name,balance,created_at FROM users WHERE id=${id}`;\n if(!u.rows.length) return json(c,{error:\"Пользователь не найден\"},404);\n const tx=await q`SELECT id,kind,amount,note,created_at FROM transactions WHERE user_id=${id} ORDER BY id DESC LIMIT 12`;\n const notes=await q`SELECT id,title,body,created_at FROM notes WHERE user_id=${id} ORDER BY id DESC LIMIT 20`;\n return json(c,{user:u.rows[0],transactions:tx.rows,notes:notes.rows});\n});\n\napp.post(\"/api/payment\", async c => {\n const {user_id,amount,note}=await c.req.json();\n const id=Number(user_id), n=Math.floor(Number(amount));\n if(!Number.isFinite(n)||n<=0||n>100000000) return json(c,{error:\"Некорректная сумма\"},400);\n const u=await q`SELECT balance FROM users WHERE id=${id}`;\n if(!u.rows.length) return json(c,{error:\"Пользователь не найден\"},404);\n if(Number(u.rows[0].balance) {\n const {user_id,amount}=await c.req.json();\n const id=Number(user_id), n=Math.floor(Number(amount));\n if(!Number.isFinite(n)||n<=0||n>100000000) return json(c,{error:\"Некорректная сумма\"},400);\n await q`UPDATE users SET balance=balance+${n} WHERE id=${id}`;\n await q`INSERT INTO transactions(user_id,kind,amount,note) VALUES(${id},'topup',${n},'Учебное пополнение')`;\n const u=await q`SELECT balance FROM users WHERE id=${id}`;\n return json(c,{ok:true,balance:u.rows[0]?.balance});\n});\n\napp.post(\"/api/notes\", async c => {\n const {user_id,title,body}=await c.req.json();\n if(!user_id||!title||!body) return json(c,{error:\"Заполните все поля\"},400);\n const r=await q`INSERT INTO notes(user_id,title,body) VALUES(${Number(user_id)},${String(title).slice(0,120)},${String(body).slice(0,5000)}) RETURNING *`;\n return json(c,{note:r.rows[0]});\n});\n\nconst page=`NEXUS SCHOOL OS

`;\napp.get(\"/\", c => c.html(page));\nexport default app.fetch;","fileType","http",8,"parentId","createdAt",["D",1788887544248],"branchVersion",9,"label",[19],{"_33":79,"_13":80,"_37":81,"_44":-5,"_35":36,"_47":66,"_55":56,"_45":82,"_17":68,"_41":83,"_39":-5,"_58":59,"_49":-5,"_60":84,"_18":85},{"_33":72,"_13":73,"_37":74,"_44":-5,"_35":36,"_47":66,"_55":56,"_45":75,"_17":68,"_41":24,"_39":76,"_58":59,"_49":-5,"_60":77,"_18":78},{"_33":63,"_13":64,"_37":65,"_44":-5,"_35":36,"_47":66,"_55":56,"_45":67,"_17":68,"_41":24,"_39":69,"_58":59,"_49":-5,"_60":70,"_18":71},{"_33":34,"_13":19,"_37":38,"_44":-5,"_35":36,"_47":48,"_55":56,"_45":57,"_17":43,"_41":42,"_39":40,"_58":59,"_49":-5,"_60":61,"_18":62},"latest",true,["D",1788887544248],"deleted",false,"children",[],[19],"20960bd9-0914-4221-ae88-b7f8da4b1149","README.md","01a081fe-8a60-7580-867f-19eb4a87e681",1,["D",1788887337369],0,"# 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",[],[64],"f3bd512c-fb04-4c89-8747-df84da5c33c7","CHANGELOG.md","01a081fe-8a60-7580-867f-15883940d5dc",["D",1788887337369],"# 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