NEXUS SCHOOL OS

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_240":241,"_242":243},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","index.ts","latestPath","fileId","01a081fe-8a60-7580-867f-1fc231bac9ef","name","fileType","http","content","import { Hono } from \"npm:hono\";\nimport { cors } from \"npm:hono/cors\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst app = new Hono();\napp.use(\"*\", cors());\n\nawait sqlite`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 sqlite`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 sqlite`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 sqlite`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 sqlite`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 sqlite`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 sqlite`SELECT id,kind,amount,note,created_at FROM transactions WHERE user_id=${id} ORDER BY id DESC LIMIT 12`;\n const notes=await sqlite`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 sqlite`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 sqlite`UPDATE users SET balance=balance+${n} WHERE id=${id}`;\n await sqlite`INSERT INTO transactions(user_id,kind,amount,note) VALUES(${id},'topup',${n},'Учебное пополнение')`;\n const u=await sqlite`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 sqlite`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;","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\nawait sqlite`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 sqlite`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 sqlite`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 sqlite`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 sqlite`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 sqlite`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 sqlite`SELECT id,kind,amount,note,created_at FROM transactions WHERE user_id=${id} ORDER BY id DESC LIMIT 12`;\n const notes=await sqlite`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 sqlite`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 sqlite`UPDATE users SET balance=balance+${n} WHERE id=${id}`;\n await sqlite`INSERT INTO transactions(user_id,kind,amount,note) VALUES(${id},'topup',${n},'Учебное пополнение')`;\n const u=await sqlite`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 sqlite`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;","createdAt",["D",1788887511040],"branchVersion","branchId","eba0ae0b-c46f-4d1f-8076-2d4e48288fc4","id","1f47a200-9cf4-407d-a3ec-38056e90de65","nexus-school-os",["D",1788887337369],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Учебная интеллектуальная система с виртуальными платежами","imageUrl","6fbccba7-1304-452e-9c47-63a82b93ab80","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a07777-e619-74c3-b583-4fbaca18818a","tursoName","1f47a2009cf4407da3ec38056e90de65","tursoHostname","1f47a2009cf4407da3ec38056e90de65-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789495880338],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",9,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","alizhan0818","handle","displayName","Алижан","avatar","https://lh3.googleusercontent.com/a/ACg8ocJCKDI1euTzxy69SEJ3KYyrMIx0Lsefabw9acb-nqWJ6PtpYA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":235,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":236,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":237,"_83":238,"_85":239,"_87":25},"tree",[170,177,178,179],"files",[170,171,172,173,174,175,176,177,178,179],"counts",{"_160":62,"_161":144,"_162":62,"_163":164,"_165":166},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":154,"_32":155,"_30":156,"_135":-5,"_41":42,"_40":144,"_136":58,"_38":157,"_13":62,"_33":158,"_35":-5,"_24":25,"_139":-5,"_27":159},{"_43":148,"_32":149,"_30":150,"_135":-5,"_41":42,"_40":144,"_136":58,"_38":151,"_13":62,"_33":20,"_35":152,"_24":25,"_139":-5,"_27":153},{"_43":141,"_32":142,"_30":143,"_135":-5,"_41":42,"_40":144,"_136":58,"_38":145,"_13":62,"_33":20,"_35":146,"_24":25,"_139":-5,"_27":147},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":25,"_38":137,"_13":138,"_33":34,"_35":37,"_24":25,"_139":-5,"_27":140},"a1e2886e-6198-4396-ad97-57363d1fcccd","parentId","latest",["D",1788887511040],2,"label",[28],"20960bd9-0914-4221-ae88-b7f8da4b1149","README.md","01a081fe-8a60-7580-867f-19eb4a87e681",1,["D",1788887337369],"# 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",[142],"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

Diff · v3