[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_337":338,"_339":340},"routes/_app.x.$handle.$name",{"_100":99,"_33":46,"_109":90,"_28":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":27,"_124":125,"_126":25,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":27,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":27},"version",34,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":34,"_35":20,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":34,"_35":20,"_36":37},"deleted",true,"deletedHere",false,"path","frontend/index.html","latestPath","fileId","51a1246c-07cd-11f1-9631-42dde27851f2","name","index.html","fileType","content","\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n","\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n","createdAt",["D",1770871559008],"branchVersion","branchId","d33342ec-07c5-11f1-8d85-42dde27851f2","id","d3330110-07c5-11f1-8d85-42dde27851f2","living-stories-self-registration",["D",1770868165845],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Registration for sessions at LSC Events","imageUrl","3ee322c5-8742-48e0-86c7-5f3ae129683b","pinnedFileId","dee11794-07c6-11f1-9da1-42dde27851f2","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","f427167a-3263-4778-81d8-f79626323ff5","tursoName","d333011007c511f18d8542dde27851f2","tursoHostname","d333011007c511f18d8542dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518064818],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":56,"_105":106,"_107":27},"branch",{"_13":89,"_33":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"isOwned",117,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kamalnrf","handle","displayName","Kamal","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaVpXT3l1d2hWSFdtWTNoZFIwZ0lFUUhOd2oifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_33":46,"_39":332,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":27,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":333,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":334,"_84":335,"_86":336,"_88":27},"tree",[216,220,228,229,230,231,232,233,234],"files",[216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234],"counts",{"_206":63,"_207":162,"_208":63,"_209":210,"_211":212},"contents",[131,132,133,134,135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":200,"_33":201,"_31":202,"_143":-5,"_42":43,"_41":203,"_145":25,"_39":204,"_13":63,"_35":198,"_36":-5,"_24":27,"_150":-5,"_28":205},{"_44":194,"_33":195,"_31":196,"_143":-5,"_42":43,"_41":184,"_145":27,"_39":197,"_13":63,"_35":198,"_36":-5,"_24":27,"_150":-5,"_28":199},{"_44":188,"_33":189,"_31":190,"_143":-5,"_42":43,"_41":147,"_145":25,"_39":191,"_13":63,"_35":20,"_36":192,"_24":27,"_150":-5,"_28":193},{"_44":181,"_33":182,"_31":183,"_143":-5,"_42":43,"_41":184,"_145":27,"_39":185,"_13":147,"_35":20,"_36":186,"_24":27,"_150":-5,"_28":187},{"_44":173,"_33":174,"_31":175,"_143":-5,"_42":43,"_41":176,"_145":27,"_39":177,"_13":178,"_35":20,"_36":179,"_24":27,"_150":-5,"_28":180},{"_44":166,"_33":167,"_31":168,"_143":-5,"_42":43,"_41":169,"_145":25,"_39":170,"_13":63,"_35":148,"_36":171,"_24":27,"_150":-5,"_28":172},{"_44":159,"_33":160,"_31":161,"_143":-5,"_42":43,"_41":162,"_145":25,"_39":163,"_13":63,"_35":20,"_36":164,"_24":27,"_150":-5,"_28":165},{"_44":152,"_33":153,"_31":58,"_143":-5,"_42":43,"_41":154,"_145":27,"_39":155,"_13":147,"_35":156,"_36":157,"_24":27,"_150":-5,"_28":158},{"_44":140,"_33":141,"_31":142,"_143":-5,"_42":43,"_41":144,"_145":27,"_39":146,"_13":147,"_35":148,"_36":149,"_24":27,"_150":-5,"_28":151},"58fa9df6-07c8-11f1-9025-42dde27851f2","seed.ts","f1a63db4-07c6-11f1-9554-42dde27851f2","parentId",23,"latest",["D",1770869249279],2,"script","/**\n * Seed script — run once as a \"script\" file to populate sample data.\n * Edit EVENT, SESSIONS, BOOKS below to match your actual event.\n * Re-running is safe: clears existing data first.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { initSchema } from \"./db/queries.ts\";\n\n// ─── Your event config ───────────────────────────────────────\n\nconst EVENT = {\n name: \"Living Library Hyderabad #6\",\n date: \"2026-02-22\",\n};\n\nconst SESSIONS = [\n { name: \"Session 1\", startTime: \"10:00 AM\", endTime: \"10:45 AM\", sortOrder: 1 },\n { name: \"Session 2\", startTime: \"11:00 AM\", endTime: \"11:45 AM\", sortOrder: 2 },\n { name: \"Session 3\", startTime: \"12:00 PM\", endTime: \"12:45 PM\", sortOrder: 3 },\n];\n\nconst MAX_SLOTS_PER_BOOK = 8;\n\nconst BOOKS = [\n {\n title: \"From Hacker to Healer\",\n authorName: \"Arjun\",\n synopsis: \"A former cybersecurity expert's journey into mental health advocacy.\",\n },\n {\n title: \"Living with Invisible Illness\",\n authorName: \"Meera\",\n synopsis: \"Navigating life with a chronic condition that no one can see.\",\n },\n {\n title: \"The Queer Almanac\",\n authorName: \"Ravi\",\n synopsis: \"Growing up queer in a small Indian town.\",\n },\n {\n title: \"Colours of Grief\",\n authorName: \"Priya\",\n synopsis: \"A mother's experience of loss and finding meaning after.\",\n },\n {\n title: \"Between Two Worlds\",\n authorName: \"Fatima\",\n synopsis: \"The immigrant experience — belonging everywhere and nowhere.\",\n },\n {\n title: \"Off the Grid\",\n authorName: \"Karthik\",\n synopsis: \"Leaving a tech career to farm — and what I learned about life.\",\n },\n];\n\n// Optional: restrict specific books to specific sessions.\n// Keys are book titles, values are 1-indexed session numbers.\n// null = every book in every session (default)\nconst BOOK_SESSION_OVERRIDES: Record | null = null;\n\n// ─── Seed ────────────────────────────────────────────────────\n\nawait initSchema();\n\n// Clear (order matters for FK constraints)\nawait sqlite.batch([\n \"DELETE FROM ll_registrations\",\n \"DELETE FROM ll_book_sessions\",\n \"DELETE FROM ll_books\",\n \"DELETE FROM ll_sessions\",\n \"DELETE FROM ll_events\",\n]);\n\n// Event\nconst eventResult = await sqlite.execute({\n sql: \"INSERT INTO ll_events (name, date, active) VALUES (?, ?, 1)\",\n args: [EVENT.name, EVENT.date],\n});\nconst eventId = eventResult.lastInsertRowid;\nconsole.log(`Created event: ${EVENT.name} (id=${eventId})`);\n\n// Sessions\nconst sessionIds: number[] = [];\nfor (const s of SESSIONS) {\n const r = await sqlite.execute({\n sql: \"INSERT INTO ll_sessions (event_id, name, start_time, end_time, sort_order) VALUES (?, ?, ?, ?, ?)\",\n args: [eventId, s.name, s.startTime, s.endTime, s.sortOrder],\n });\n sessionIds.push(Number(r.lastInsertRowid));\n console.log(` Session: ${s.name} (id=${r.lastInsertRowid})`);\n}\n\n// Books + book_sessions\nfor (const b of BOOKS) {\n const r = await sqlite.execute({\n sql: \"INSERT INTO ll_books (event_id, title, author_name, synopsis) VALUES (?, ?, ?, ?)\",\n args: [eventId, b.title, b.authorName, b.synopsis],\n });\n const bookId = Number(r.lastInsertRowid);\n\n const allowedSessions = BOOK_SESSION_OVERRIDES?.[b.title]\n ? BOOK_SESSION_OVERRIDES[b.title].map((i) => sessionIds[i - 1])\n : sessionIds;\n\n for (const sessionId of allowedSessions) {\n await sqlite.execute({\n sql: \"INSERT INTO ll_book_sessions (book_id, session_id, max_slots) VALUES (?, ?, ?)\",\n args: [bookId, sessionId, MAX_SLOTS_PER_BOOK],\n });\n }\n console.log(` Book: \"${b.title}\" by ${b.authorName} → ${allowedSessions.length} sessions`);\n}\n\nconsole.log(\"\\n✅ Seed complete!\");\n","label",[141],"a406e700-07cd-11f1-b546-42dde27851f2","index.ts",30,["D",1770871522665],"http","import { Hono } from \"npm:hono\";\nimport api from \"./api.ts\";\nimport { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// API routes\napp.route(\"/api\", api);\n\n// Surface real errors during development\napp.onError((err, c) => {\n console.error(err);\n return c.json({ error: err.message }, 500);\n});\n\nexport default app.fetch;\n",[153],"03abc354-07c6-11f1-b71e-42dde27851f2","deno.json","03abc3fe-07c6-11f1-b71e-42dde27851f2",1,["D",1770868247163],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/98f62cee78e85bfc47c62ed703777c6bc8794f1c/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": true,\n \"types\": [\"https://www.val.town/types/valtown.d.ts\"],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"include\": [\"deno:/https/esm.town/**/*\"],\n \"rules\": {\n \"exclude\": [\"no-explicit-any\"]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}",[160],"da44c924-07c6-11f1-931b-42dde27851f2","api.ts","da44c9c4-07c6-11f1-931b-42dde27851f2",9,["D",1770868607201],"import { Hono } from \"npm:hono\";\nimport {\n getActiveEvent,\n getEventAvailability,\n findOrCreateReader,\n registerForBook,\n unregisterFromSession,\n getReaderCard,\n} from \"./db/queries.ts\";\n\nconst api = new Hono();\n\n// ─── Event ───────────────────────────────────────────────────\n\napi.get(\"/events/active\", async (c) => {\n const event = await getActiveEvent();\n if (!event) return c.json({ error: \"No active event\" }, 404);\n return c.json(event);\n});\n\napi.get(\"/events/:id/availability\", async (c) => {\n const eventId = Number(c.req.param(\"id\"));\n const readerId = c.req.query(\"readerId\")\n ? Number(c.req.query(\"readerId\"))\n : undefined;\n const data = await getEventAvailability(eventId, readerId);\n return c.json(data);\n});\n\n// ─── Reader ──────────────────────────────────────────────────\n\napi.post(\"/reader\", async (c) => {\n const { name, email } = await c.req.json();\n if (!name?.trim() || !email?.trim()) {\n return c.json({ error: \"Name and email are required\" }, 400);\n }\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(email.trim())) {\n return c.json({ error: \"Please enter a valid email\" }, 400);\n }\n const reader = await findOrCreateReader(name.trim(), email.trim());\n return c.json(reader);\n});\n\napi.get(\"/readers/:id/card\", async (c) => {\n const readerId = Number(c.req.param(\"id\"));\n const card = await getReaderCard(readerId);\n if (!card) return c.json({ error: \"Reader not found\" }, 404);\n return c.json(card);\n});\n\n// ─── Registration ────────────────────────────────────────────\n\napi.post(\"/register\", async (c) => {\n const { readerId, bookSessionId, sessionId } = await c.req.json();\n if (!readerId || !bookSessionId || !sessionId) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n const result = await registerForBook(readerId, bookSessionId, sessionId);\n if (!result.ok) {\n return c.json(\n { error: \"This book is full — please pick another\", ok: false },\n 409,\n );\n }\n return c.json({ ok: true });\n});\n\napi.delete(\"/register\", async (c) => {\n const { readerId, sessionId } = await c.req.json();\n if (!readerId || !sessionId) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n return c.json(await unregisterFromSession(readerId, sessionId));\n});\n\nexport default api;\n",[167],"88e03486-07c8-11f1-a6ea-42dde27851f2","CLAUDE.md","af3d9332-07c6-11f1-8fba-42dde27851f2",27,["D",1770869329624],3,"# Living Library — Self-Registration System\n\nA self-service registration app for Living Library events in Hyderabad. Readers register with name + email, browse available \"books\" (people sharing their stories), and claim reading slots — all in real-time as 250+ people sign up simultaneously.\n\n## Architecture\n\n```\n┌─────────────────────────────────────────────────────────┐\n│ Client (React + Pico CSS) │\n│ ┌──────────┐ ┌──────────────┐ ┌──────────────────┐ │\n│ │ Register │→ │ Browse Books │→ │ Library Card View │ │\n│ │ (name + │ │ (polls every │ │ (reading history) │ │\n│ │ email) │ │ 3 seconds) │ │ │ │\n│ └──────────┘ └──────┬───────┘ └──────────────────┘ │\n│ │ │\n│ localStorage: { id, name, email } │\n└───────────────────────┼─────────────────────────────────┘\n │ HTTP\n┌───────────────────────┼─────────────────────────────────┐\n│ Server (Hono) │ │\n│ ▼ │\n│ /api/events/active GET → active event │\n│ /api/events/:id/availability GET → sessions + slot counts│\n│ /api/reader POST → find-or-create reader│\n│ /api/register POST → atomic slot booking │\n│ /api/register DELETE → cancel booking │\n│ /api/readers/:id/card GET → library card data │\n│ │\n│ DB Layer: Drizzle ORM (libsql/web → Val Town SQLite, val-scoped) │\n└──────────────────────────────────────────────────────────┘\n```\n\n## Key Design Decisions\n\n### Polling over SSE/WebSocket\nVal Town's serverless model keeps a Deno isolate alive per SSE connection. With 250 concurrent readers, that's 250 long-lived isolates — unsustainable. Instead, we poll every 3s. That's ~83 req/s of fast SQLite reads, which Val Town handles fine.\n\n### Atomic slot booking (race condition safety)\nThe critical path is two readers grabbing the last slot simultaneously. We solve this with a conditional INSERT:\n```sql\nINSERT INTO ll_registrations (reader_id, book_session_id, session_id)\nSELECT ?, ?, ?\nWHERE (SELECT COUNT(*) FROM ll_registrations WHERE book_session_id = ?) <\n (SELECT max_slots FROM ll_book_sessions WHERE id = ?)\n```\nIf the slot was taken between the reader's last poll and their click, 0 rows are affected → friendly error.\n\n### Drizzle ORM with libsql/web\nVal Town's SQLite is Turso/libSQL under the hood. We use the official pattern from Val Town docs: `drizzle(sqlite as any)` via `drizzle-orm/libsql/web`. The val-scoped import (`std/sqlite/main.ts`) isolates this project's DB from other vals on the same account. Raw `sqlite.execute()` is used for hot paths (availability polling) and atomic transactions (registration) where we need precise SQL control.\n\n### One book per session per reader\nEnforced at the DB level with `UNIQUE(reader_id, session_id)` on `ll_registrations`. The API deletes any existing registration for a session before inserting a new one (in a transaction), so changing your pick is seamless.\n\n## Data Model\n\n```\nll_events → An event (e.g. \"Living Library Hyderabad #6\")\nll_sessions → Time slots within an event (Session 1, 2, 3...)\nll_books → \"Books\" (people) available at an event\nll_book_sessions → Junction: which books are in which sessions (with max_slots)\nll_readers → Registered readers (name + email, unique on email)\nll_registrations → Reader ↔ BookSession assignments\n```\n\n## File Structure\n\n```\n├── CLAUDE.md ← You are here\n├── AGENTS.md ← Val Town agent instructions\n├── db/\n│ ├── schema.ts ← Drizzle table definitions (source of truth)\n│ ├── client.ts ← Drizzle instance via sqlite-proxy\n│ └── queries.ts ← All query functions\n├── api.ts ← Hono API routes\n├── views.ts ← React SPA (HTML shell + embedded React)\n├── index.ts ← HTTP entry point (Hono app)\n└── seed.ts ← Script: populate sample data\n```\n\n## Development\n\n### Seeding data\nEdit `seed.ts` with your event/book/session details, then run it as a script in Val Town. Re-running clears and re-inserts.\n\n### Schema changes\n1. Update `db/schema.ts` (Drizzle table definitions)\n2. Update `db/queries.ts` if query logic changed\n3. The schema is applied via `CREATE TABLE IF NOT EXISTS` on cold start — for breaking changes, either drop tables manually or bump table names\n\n### Adding a new API endpoint\n1. Add the query function in `db/queries.ts`\n2. Add the route in `api.ts`\n3. Update the React app in `views.ts` if it needs to call the new endpoint\n\n## Trust model\nWe trust readers to provide accurate name/email. No auth, no verification. The `UNIQUE(email)` constraint on readers means returning with the same email resumes their session.",[174],"51a1388a-07cd-11f1-9631-42dde27851f2","AGENTS.md","03f9a1f0-07c6-11f1-bdf4-42dde27851f2",29,["D",1770871384419],"# Living Library — Self-Registration System\n\nA self-service registration app for Living Library events in Hyderabad. Readers\nregister with name + email, browse available \"books\" (people sharing their\nstories), and claim reading slots — all in real-time as 250+ people sign up\nsimultaneously.\n\n## Architecture\n\n```\n┌─────────────────────────────────────────────────────────┐\n│ Client (React) │\n│ ┌──────────┐ ┌──────────────┐ ┌──────────────────┐ │\n│ │ Register │→ │ Browse Books │→ │ Library Card View │ │\n│ │ (name + │ │ (polls every │ │ (reading history) │ │\n│ │ email) │ │ 3 seconds) │ │ │ │\n│ └──────────┘ └──────┬───────┘ └──────────────────┘ │\n│ │ │\n│ localStorage: { id, name, email } │\n└───────────────────────┼─────────────────────────────────┘\n │ HTTP\n┌───────────────────────┼─────────────────────────────────┐\n│ Server (Hono) │ │\n│ ▼ │\n│ /api/events/active GET → active event │\n│ /api/events/:id/availability GET → sessions + slot counts│\n│ /api/reader POST → find-or-create reader│\n│ /api/register POST → atomic slot booking │\n│ /api/register DELETE → cancel booking │\n│ /api/readers/:id/card GET → library card data │\n│ │\n│ DB Layer: Drizzle ORM (sqlite-proxy → Val Town SQLite) │\n└──────────────────────────────────────────────────────────┘\n```\n\n## Key Design Decisions\n\n### Polling over SSE/WebSocket\n\nVal Town's serverless model keeps a Deno isolate alive per SSE connection. With\n250 concurrent readers, that's 250 long-lived isolates — unsustainable. Instead,\nwe poll every 3s. That's ~83 req/s of fast SQLite reads, which Val Town handles\nfine.\n\n### Atomic slot booking (race condition safety)\n\nThe critical path is two readers grabbing the last slot simultaneously. We solve\nthis with a conditional INSERT:\n\n```sql\nINSERT INTO ll_registrations (reader_id, book_session_id, session_id)\nSELECT ?, ?, ?\nWHERE (SELECT COUNT(*) FROM ll_registrations WHERE book_session_id = ?) <\n (SELECT max_slots FROM ll_book_sessions WHERE id = ?)\n```\n\nIf the slot was taken between the reader's last poll and their click, 0 rows are\naffected → friendly error.\n\n### Drizzle ORM with sqlite-proxy\n\nVal Town provides SQLite via `https://esm.town/v/std/sqlite` (a Turso HTTP\nwrapper). We bridge it with `drizzle-orm/sqlite-proxy` which lets us plug in\ncustom execute/batch callbacks. This gives us type-safe queries while staying on\nVal Town's native SQLite.\n\n### One book per session per reader\n\nEnforced at the DB level with `UNIQUE(reader_id, session_id)` on\n`ll_registrations`. The API deletes any existing registration for a session\nbefore inserting a new one (in a transaction), so changing your pick is\nseamless.\n\n## Data Model\n\n```\nll_events → An event (e.g. \"Living Library Hyderabad #6\")\nll_sessions → Time slots within an event (Session 1, 2, 3...)\nll_books → \"Books\" (people) available at an event\nll_book_sessions → Junction: which books are in which sessions (with max_slots)\nll_readers → Registered readers (name + email, unique on email)\nll_registrations → Reader ↔ BookSession assignments\n```\n\n## File Structure\n\n```\n├── CLAUDE.md ← You are here\n├── AGENTS.md ← Val Town agent instructions\n├── db/\n│ ├── schema.ts ← Drizzle table definitions (source of truth)\n│ ├── client.ts ← Drizzle instance via sqlite-proxy\n│ └── queries.ts ← All query functions\n├── api.ts ← Hono API routes\n├── views.ts ← React SPA (HTML shell + embedded React)\n├── index.ts ← HTTP entry point (Hono app)\n└── seed.ts ← Script: populate sample data\n```\n\n## Development\n\n### Seeding data\n\nEdit `seed.ts` with your event/book/session details, then run it as a script in\nVal Town. Re-running clears and re-inserts.\n\n### Schema changes\n\n1. Update `db/schema.ts` (Drizzle table definitions)\n2. Update `db/queries.ts` if query logic changed\n3. The schema is applied via `CREATE TABLE IF NOT EXISTS` on cold start — for\n breaking changes, either drop tables manually or bump table names\n\n### Adding a new API endpoint\n\n1. Add the query function in `db/queries.ts`\n2. Add the route in `api.ts`\n3. Update the React app in `views.ts` if it needs to call the new endpoint\n\n## Trust model\n\nWe trust readers to provide accurate name/email. No auth, no verification. The\n`UNIQUE(email)` constraint on readers means returning with the same email\nresumes their session.\n",[182],"03b2562e-07c6-11f1-8153-42dde27851f2",".vtignore","03b25796-07c6-11f1-8153-42dde27851f2",["D",1770868247174],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[189],"51a1339e-07cd-11f1-9631-42dde27851f2","frontend","019c5028-e961-70b8-9c87-acfe3c39dc79",["D",1770871384419],"directory",[195],"b20402cc-07c6-11f1-b4ca-42dde27851f2","db","b204038a-07c6-11f1-b4ca-42dde27851f2",5,["D",1770868539664],[201],"pulls","branches","forks","envVars",{"_213":63,"_215":63},"connections",{"_213":63,"_214":63},"count","unfilledCount","emptyCount",{"_44":200,"_33":201,"_31":202,"_143":-5,"_42":43,"_41":203,"_145":25,"_39":329,"_13":63,"_35":198,"_36":-5,"_24":27,"_150":-5,"_236":330,"_28":331},{"_44":321,"_33":322,"_31":323,"_143":202,"_42":43,"_41":324,"_145":25,"_39":325,"_13":178,"_35":148,"_36":326,"_24":27,"_150":-5,"_236":327,"_28":328},{"_44":313,"_33":314,"_31":315,"_143":202,"_42":43,"_41":316,"_145":27,"_39":317,"_13":203,"_35":148,"_36":318,"_24":27,"_150":-5,"_236":319,"_28":320},{"_44":305,"_33":306,"_31":307,"_143":202,"_42":43,"_41":308,"_145":27,"_39":309,"_13":63,"_35":148,"_36":310,"_24":27,"_150":-5,"_236":311,"_28":312},{"_44":194,"_33":195,"_31":196,"_143":-5,"_42":43,"_41":184,"_145":27,"_39":302,"_13":63,"_35":198,"_36":-5,"_24":27,"_150":-5,"_236":303,"_28":304},{"_44":298,"_33":297,"_31":292,"_143":196,"_42":43,"_41":184,"_145":27,"_39":299,"_13":63,"_35":198,"_36":-5,"_24":27,"_150":-5,"_236":300,"_28":301},{"_44":289,"_33":290,"_31":291,"_143":292,"_42":43,"_41":184,"_145":27,"_39":293,"_13":63,"_35":148,"_36":294,"_24":27,"_150":-5,"_236":295,"_28":296},{"_44":282,"_33":283,"_31":284,"_143":196,"_42":43,"_41":184,"_145":27,"_39":285,"_13":63,"_35":20,"_36":286,"_24":27,"_150":-5,"_236":287,"_28":288},{"_44":278,"_33":34,"_31":32,"_143":196,"_42":43,"_41":14,"_145":27,"_39":279,"_13":162,"_35":20,"_36":38,"_24":27,"_150":-5,"_236":280,"_28":281},{"_44":271,"_33":272,"_31":273,"_143":196,"_42":43,"_41":184,"_145":27,"_39":274,"_13":63,"_35":148,"_36":275,"_24":27,"_150":-5,"_236":276,"_28":277},{"_44":264,"_33":265,"_31":266,"_143":196,"_42":43,"_41":267,"_145":27,"_39":268,"_13":147,"_35":20,"_36":110,"_24":27,"_150":-5,"_236":269,"_28":270},{"_44":257,"_33":258,"_31":259,"_143":196,"_42":43,"_41":184,"_145":27,"_39":260,"_13":63,"_35":20,"_36":261,"_24":27,"_150":-5,"_236":262,"_28":263},{"_44":188,"_33":189,"_31":190,"_143":-5,"_42":43,"_41":147,"_145":25,"_39":254,"_13":63,"_35":20,"_36":192,"_24":27,"_150":-5,"_236":255,"_28":256},{"_44":181,"_33":182,"_31":183,"_143":-5,"_42":43,"_41":184,"_145":27,"_39":251,"_13":147,"_35":20,"_36":186,"_24":27,"_150":-5,"_236":252,"_28":253},{"_44":173,"_33":174,"_31":175,"_143":-5,"_42":43,"_41":176,"_145":27,"_39":248,"_13":178,"_35":20,"_36":179,"_24":27,"_150":-5,"_236":249,"_28":250},{"_44":166,"_33":167,"_31":168,"_143":-5,"_42":43,"_41":169,"_145":25,"_39":245,"_13":63,"_35":148,"_36":171,"_24":27,"_150":-5,"_236":246,"_28":247},{"_44":159,"_33":160,"_31":161,"_143":-5,"_42":43,"_41":162,"_145":25,"_39":242,"_13":63,"_35":20,"_36":164,"_24":27,"_150":-5,"_236":243,"_28":244},{"_44":152,"_33":153,"_31":58,"_143":-5,"_42":43,"_41":154,"_145":27,"_39":239,"_13":147,"_35":156,"_36":157,"_24":27,"_150":-5,"_236":240,"_28":241},{"_44":140,"_33":141,"_31":142,"_143":-5,"_42":43,"_41":144,"_145":27,"_39":235,"_13":147,"_35":148,"_36":149,"_24":27,"_150":-5,"_236":237,"_28":238},["D",1770869249279],"children",[],[141],["D",1770871522665],[],[153],["D",1770868247163],[],[160],["D",1770868607201],[],[167],["D",1770869329624],[],[174],["D",1770871384419],[],[182],["D",1770868247174],[],[189],"51a12fe8-07cd-11f1-9631-42dde27851f2","style.css","51a13056-07cd-11f1-9631-42dde27851f2",["D",1770871384419],"body {\n font-family: -apple-system, Arial, sans-serif;\n color: #333;\n padding: 20px;\n}\n\nbutton {\n background-color: #4a90e2;\n color: white;\n border: none;\n padding: 8px 16px;\n border-radius: 4px;\n cursor: pointer;\n}\n\nbutton:hover {\n background-color: #357ae8;\n}",[],[195,258],"b2e34eee-07cd-11f1-acd8-42dde27851f2","somenthingelse.html","af9480c8-07cd-11f1-acd8-42dde27851f2",33,["D",1770871547598],[],[195,265],"51a12c32-07cd-11f1-9631-42dde27851f2","index.tsx","51a12caa-07cd-11f1-9631-42dde27851f2",["D",1770871384419],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[195,272],"b9b09402-07cd-11f1-842f-42dde27851f2",["D",1770871559008],[],[195,34],"51a11e68-07cd-11f1-9631-42dde27851f2","favicon.svg","51a11ef4-07cd-11f1-9631-42dde27851f2",["D",1770871384419],"\n",[],[195,283],"51a101ee-07cd-11f1-9631-42dde27851f2","App.tsx","51a102b6-07cd-11f1-9631-42dde27851f2","019c5028-e961-70b8-9c87-b144cb98315b",["D",1770871384419],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function App() {\n const [clicked, setClicked] = useState(0);\n return (\n

Val Town React + Hono Starter

\n I've been clicked times\n

\n );\n}",[],[195,297,290],"components","51a135d8-07cd-11f1-9631-42dde27851f2",["D",1770871384419],[222],[195,297],["D",1770871384419],[221,223,224,225,226,227],[195],"b92fdb7a-07c6-11f1-9d4c-42dde27851f2","schema.ts","b92fdc1a-07c6-11f1-9d4c-42dde27851f2",6,["D",1770868551696],"import { sqliteTable, text, integer, uniqueIndex } from \"npm:drizzle-orm/sqlite-core\";\nimport { sql } from \"npm:drizzle-orm\";\n\n// ─── Table prefix to avoid collisions with other vals ─────\n\nexport const events = sqliteTable(\"ll_events\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n name: text(\"name\").notNull(),\n date: text(\"date\").notNull(),\n active: integer(\"active\", { mode: \"boolean\" }).default(false),\n});\n\nexport const sessions = sqliteTable(\"ll_sessions\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n eventId: integer(\"event_id\")\n .notNull()\n .references(() => events.id),\n name: text(\"name\").notNull(),\n startTime: text(\"start_time\"),\n endTime: text(\"end_time\"),\n sortOrder: integer(\"sort_order\").default(0),\n});\n\nexport const books = sqliteTable(\"ll_books\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n eventId: integer(\"event_id\")\n .notNull()\n .references(() => events.id),\n title: text(\"title\").notNull(),\n authorName: text(\"author_name\").notNull(),\n synopsis: text(\"synopsis\").default(\"\"),\n});\n\nexport const bookSessions = sqliteTable(\n \"ll_book_sessions\",\n {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n bookId: integer(\"book_id\")\n .notNull()\n .references(() => books.id),\n sessionId: integer(\"session_id\")\n .notNull()\n .references(() => sessions.id),\n maxSlots: integer(\"max_slots\").notNull().default(8),\n },\n (table) => [uniqueIndex(\"book_session_uniq\").on(table.bookId, table.sessionId)],\n);\n\nexport const readers = sqliteTable(\"ll_readers\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n name: text(\"name\").notNull(),\n email: text(\"email\").notNull().unique(),\n createdAt: text(\"created_at\").default(sql`(datetime('now'))`),\n});\n\nexport const registrations = sqliteTable(\n \"ll_registrations\",\n {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n readerId: integer(\"reader_id\")\n .notNull()\n .references(() => readers.id),\n bookSessionId: integer(\"book_session_id\")\n .notNull()\n .references(() => bookSessions.id),\n sessionId: integer(\"session_id\")\n .notNull()\n .references(() => sessions.id),\n createdAt: text(\"created_at\").default(sql`(datetime('now'))`),\n },\n (table) => [uniqueIndex(\"reader_session_uniq\").on(table.readerId, table.sessionId)],\n);\n",[],[201,306],"8bd9f0be-07c8-11f1-bb1a-42dde27851f2","queries.ts","d37e0b8c-07c6-11f1-ab37-42dde27851f2",28,["D",1770869334626],"import { eq, and, sql, count } from \"npm:drizzle-orm\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { db, schema } from \"./client.ts\";\n\nconst { events, sessions, books, bookSessions, readers, registrations } = schema;\n\n// ─── Schema bootstrap ────────────────────────────────────────\n// We use raw SQL here because Drizzle doesn't generate\n// CREATE TABLE IF NOT EXISTS. This runs once on cold start.\n\nexport async function initSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS ll_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n date TEXT NOT NULL,\n active INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS ll_sessions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id INTEGER NOT NULL REFERENCES ll_events(id),\n name TEXT NOT NULL,\n start_time TEXT,\n end_time TEXT,\n sort_order INTEGER DEFAULT 0\n )`,\n `CREATE TABLE IF NOT EXISTS ll_books (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id INTEGER NOT NULL REFERENCES ll_events(id),\n title TEXT NOT NULL,\n author_name TEXT NOT NULL,\n synopsis TEXT DEFAULT ''\n )`,\n `CREATE TABLE IF NOT EXISTS ll_book_sessions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n book_id INTEGER NOT NULL REFERENCES ll_books(id),\n session_id INTEGER NOT NULL REFERENCES ll_sessions(id),\n max_slots INTEGER NOT NULL DEFAULT 8,\n UNIQUE(book_id, session_id)\n )`,\n `CREATE TABLE IF NOT EXISTS ll_readers (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL UNIQUE,\n created_at TEXT DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS ll_registrations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n reader_id INTEGER NOT NULL REFERENCES ll_readers(id),\n book_session_id INTEGER NOT NULL REFERENCES ll_book_sessions(id),\n session_id INTEGER NOT NULL REFERENCES ll_sessions(id),\n created_at TEXT DEFAULT (datetime('now')),\n UNIQUE(reader_id, session_id)\n )`,\n ]);\n}\n\n// ─── Events ──────────────────────────────────────────────────\n\nexport async function getActiveEvent() {\n const result = await db\n .select({\n id: events.id,\n name: events.name,\n date: events.date,\n })\n .from(events)\n .where(eq(events.active, true))\n .limit(1);\n\n return result[0] ?? null;\n}\n\n// ─── Availability ────────────────────────────────────────────\n// This is the hot path — polled every 3s by 250 clients.\n// Single query, no N+1.\n\nexport async function getEventAvailability(eventId: number, readerId?: number) {\n const result = await sqlite.execute({\n sql: `\n SELECT \n s.id as session_id,\n s.name as session_name,\n s.start_time,\n s.end_time,\n s.sort_order,\n bs.id as book_session_id,\n b.id as book_id,\n b.title,\n b.author_name,\n b.synopsis,\n bs.max_slots,\n (SELECT COUNT(*) FROM ll_registrations r WHERE r.book_session_id = bs.id) as registered_count\n FROM ll_sessions s\n JOIN ll_book_sessions bs ON bs.session_id = s.id\n JOIN ll_books b ON b.id = bs.book_id\n WHERE s.event_id = ?\n ORDER BY s.sort_order, s.id, b.title\n `,\n args: [eventId],\n });\n\n // Fetch reader's current registrations if logged in\n let myRegs: { sessionId: number; bookSessionId: number }[] = [];\n if (readerId) {\n const regsResult = await db\n .select({\n sessionId: registrations.sessionId,\n bookSessionId: registrations.bookSessionId,\n })\n .from(registrations)\n .where(eq(registrations.readerId, readerId));\n\n myRegs = regsResult;\n }\n\n // Group flat rows into session → books structure\n const sessionsMap = new Map();\n\n for (const row of result.rows) {\n const r = row as any;\n const sessionId = r.session_id;\n const sessionName = r.session_name;\n const startTime = r.start_time;\n const endTime = r.end_time;\n const bookSessionId = r.book_session_id;\n const bookId = r.book_id;\n const title = r.title;\n const authorName = r.author_name;\n const synopsis = r.synopsis;\n const maxSlots = r.max_slots;\n const registeredCount = r.registered_count;\n\n if (!sessionsMap.has(sessionId)) {\n sessionsMap.set(sessionId, {\n id: sessionId,\n name: sessionName,\n startTime,\n endTime,\n books: [],\n });\n }\n\n const myReg = myRegs.find((mr) => mr.sessionId === sessionId);\n\n sessionsMap.get(sessionId).books.push({\n bookSessionId,\n bookId,\n title,\n authorName,\n synopsis,\n maxSlots,\n registeredCount,\n slotsLeft: maxSlots - registeredCount,\n isRegistered: myReg?.bookSessionId === bookSessionId,\n });\n }\n\n return {\n sessions: Array.from(sessionsMap.values()),\n myRegistrations: myRegs,\n };\n}\n\n// ─── Readers ─────────────────────────────────────────────────\n\nexport async function findOrCreateReader(name: string, email: string) {\n const normalizedEmail = email.toLowerCase().trim();\n\n const existing = await db\n .select({ id: readers.id, name: readers.name, email: readers.email })\n .from(readers)\n .where(eq(readers.email, normalizedEmail))\n .limit(1);\n\n if (existing.length > 0) {\n const reader = existing[0];\n // Update name if changed (e.g. typo fix)\n if (reader.name !== name) {\n await db\n .update(readers)\n .set({ name })\n .where(eq(readers.id, reader.id));\n }\n return { id: reader.id, name, email: reader.email };\n }\n\n const result = await db\n .insert(readers)\n .values({ name, email: normalizedEmail })\n .returning({ id: readers.id, name: readers.name, email: readers.email });\n\n return result[0];\n}\n\n// ─── Registration ────────────────────────────────────────────\n// Atomic: delete existing pick for this session, then conditionally\n// insert if slots remain. Both in a single batch (transaction).\n\nexport async function registerForBook(\n readerId: number,\n bookSessionId: number,\n sessionId: number,\n) {\n const results = await sqlite.batch([\n {\n sql: `DELETE FROM ll_registrations WHERE reader_id = ? AND session_id = ?`,\n args: [readerId, sessionId],\n },\n {\n sql: `\n INSERT INTO ll_registrations (reader_id, book_session_id, session_id)\n SELECT ?, ?, ?\n WHERE (SELECT COUNT(*) FROM ll_registrations WHERE book_session_id = ?) <\n (SELECT max_slots FROM ll_book_sessions WHERE id = ?)\n `,\n args: [readerId, bookSessionId, sessionId, bookSessionId, bookSessionId],\n },\n ]);\n\n return { ok: results[1].rowsAffected > 0 };\n}\n\nexport async function unregisterFromSession(readerId: number, sessionId: number) {\n await db\n .delete(registrations)\n .where(\n and(\n eq(registrations.readerId, readerId),\n eq(registrations.sessionId, sessionId),\n ),\n );\n\n return { ok: true };\n}\n\n// ─── Library Card ────────────────────────────────────────────\n\nexport async function getReaderCard(readerId: number) {\n const readerResult = await db\n .select({ id: readers.id, name: readers.name, email: readers.email })\n .from(readers)\n .where(eq(readers.id, readerId))\n .limit(1);\n\n if (readerResult.length === 0) return null;\n const reader = readerResult[0];\n\n const regsResult = await sqlite.execute({\n sql: `\n SELECT \n s.name as session_name,\n s.start_time,\n s.end_time,\n b.title,\n b.author_name,\n e.name as event_name,\n e.date as event_date\n FROM ll_registrations r\n JOIN ll_book_sessions bs ON bs.id = r.book_session_id\n JOIN ll_sessions s ON s.id = r.session_id\n JOIN ll_books b ON b.id = bs.book_id\n JOIN ll_events e ON e.id = s.event_id\n WHERE r.reader_id = ?\n ORDER BY e.date DESC, s.sort_order, s.id\n `,\n args: [readerId],\n });\n\n const readings = regsResult.rows.map((row: any) => ({\n sessionName: row.session_name,\n startTime: row.start_time,\n endTime: row.end_time,\n title: row.title,\n authorName: row.author_name,\n eventName: row.event_name,\n eventDate: row.event_date,\n }));\n\n return { ...reader, readings };\n}\n",[],[201,314],"52f5f068-07c8-11f1-b235-42dde27851f2","client.ts","bfc988aa-07c6-11f1-ab3d-42dde27851f2",21,["D",1770869239116],"/**\n * Drizzle ORM instance using Val Town's built-in SQLite.\n *\n * Uses val-scoped sqlite (isolated to this project) with\n * drizzle-orm/libsql/web as recommended by Val Town docs.\n */\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { drizzle } from \"npm:drizzle-orm/libsql/web\";\nimport * as schema from \"./schema.ts\";\n\nexport const db = drizzle(sqlite as any, { schema });\n\nexport { schema };\n",[],[201,322],["D",1770868539664],[217,218,219],[201],["D",1770868165845],["D",1789518064818],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":56,"_105":106,"_107":27},{"_13":89,"_33":90,"_44":43,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":46,"_98":99},"ctx",{"_82":-5,"_128":370,"_371":372,"_373":374,"_375":27,"_376":27,"_377":27,"_378":25,"_379":-5,"_380":-7,"_381":-7,"_382":63,"_383":27,"_384":27,"_385":-5,"_386":27,"_387":27,"_388":27,"_389":-5},"ENV",{"_341":342,"_343":344,"_345":90,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369},"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"]

Diff · v34