[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_319":320,"_321":322},"routes/_app.x.$handle.$name",{"_146":145,"_38":91,"_155":136,"_33":156,"_13":14,"_157":-5,"_11":158,"_159":160,"_161":162,"_163":164,"_165":166,"_26":-5,"_167":-5,"_168":-5,"_169":95,"_170":171,"_172":31,"_173":-5,"_174":-5,"_175":176},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_89":90,"_38":91,"_43":92,"_93":-5,"_94":95,"_96":97,"_98":97,"_99":100,"_101":-5,"_18":102,"_103":104,"_105":95,"_106":-5,"_107":-5,"_108":109,"_110":111,"_112":113,"_114":115,"_116":117,"_118":-5,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_128":129,"_130":131,"_132":133,"_134":95},"version",38,"changes",[19,20,21,22,23,24,25],"aiChatInfo","userId",{"_26":84,"_28":85,"_30":31,"_32":31,"_33":86,"_35":86},{"_26":77,"_28":78,"_30":31,"_32":31,"_33":79,"_35":79},{"_26":70,"_28":71,"_30":31,"_32":31,"_33":72,"_35":72},{"_26":63,"_28":64,"_30":31,"_32":31,"_33":65,"_35":65},{"_26":56,"_28":57,"_30":31,"_32":31,"_33":58,"_35":58},{"_26":48,"_28":49,"_30":31,"_32":31,"_33":50,"_35":50},{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":26,"_41":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":39,"_40":26,"_41":42},"deleted",true,"deletedHere","path","frontend/style.css","latestPath","fileId","51a13056-07cd-11f1-9631-42dde27851f2","name","style.css","fileType","content","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}","createdAt",["D",1770871618752],"branchVersion","branchId","d33342ec-07c5-11f1-8d85-42dde27851f2",{"_36":51,"_38":52,"_40":53,"_41":54,"_43":55,"_45":14,"_46":47,"_30":31},{"_36":51,"_38":52,"_40":53,"_41":54},"frontend/index.tsx","51a12caa-07cd-11f1-9631-42dde27851f2","index.tsx","script","/** @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();",["D",1770871618752],{"_36":59,"_38":60,"_40":26,"_41":61,"_43":62,"_45":14,"_46":47,"_30":31},{"_36":59,"_38":60,"_40":26,"_41":61},"frontend/index.html","51a1246c-07cd-11f1-9631-42dde27851f2","index.html","\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",["D",1770871618752],{"_36":66,"_38":67,"_40":26,"_41":68,"_43":69,"_45":14,"_46":47,"_30":31},{"_36":66,"_38":67,"_40":26,"_41":68},"frontend/favicon.svg","51a11ef4-07cd-11f1-9631-42dde27851f2","favicon.svg","\n",["D",1770871618752],{"_36":73,"_38":74,"_40":53,"_41":75,"_43":76,"_45":14,"_46":47,"_30":31},{"_36":73,"_38":74,"_40":53,"_41":75},"frontend/components/App.tsx","51a102b6-07cd-11f1-9631-42dde27851f2","App.tsx","/** @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}",["D",1770871618752],{"_36":80,"_38":81,"_40":82,"_41":-5,"_43":83,"_45":14,"_46":47,"_30":31},{"_36":80,"_38":81,"_40":82,"_41":-5},"frontend/components","019c5028-e961-70b8-9c87-b144cb98315b","components","directory",["D",1770871618752],{"_36":87,"_38":86,"_40":82,"_41":-5,"_43":88,"_45":14,"_46":47,"_30":31},{"_36":87,"_38":86,"_40":82,"_41":-5},"frontend","019c5028-e961-70b8-9c87-acfe3c39dc79",["D",1770871618752],"id","d3330110-07c5-11f1-8d85-42dde27851f2","living-stories-self-registration",["D",1770868165845],"deletedAt","legacyEnvVars",false,"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",{"_146":145,"_154":150},"org",{"_146":145,"_147":148,"_149":150,"_18":102,"_151":152,"_153":95},"branch",{"_13":135,"_38":136,"_89":47,"_137":90,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":91,"_144":145},"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",{"_89":90,"_38":91,"_43":314,"_93":-5,"_94":95,"_96":97,"_98":97,"_99":100,"_101":-5,"_18":102,"_103":104,"_105":95,"_106":-5,"_107":-5,"_108":109,"_110":111,"_112":113,"_114":115,"_116":315,"_118":-5,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_128":316,"_130":317,"_132":318,"_134":95},"tree",[254,258,259,260,261,262,263,264],"files",[254,255,256,257,258,259,260,261,262,263,264],"counts",{"_244":109,"_245":206,"_246":109,"_247":248,"_249":250},"contents",[177,178,179,180,181,182,183,184],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_89":238,"_38":239,"_36":240,"_188":-5,"_46":47,"_45":241,"_190":31,"_43":242,"_13":109,"_40":82,"_41":-5,"_30":95,"_194":-5,"_33":243},{"_89":232,"_38":233,"_36":234,"_188":-5,"_46":47,"_45":192,"_190":31,"_43":235,"_13":109,"_40":26,"_41":236,"_30":95,"_194":-5,"_33":237},{"_89":225,"_38":226,"_36":227,"_188":-5,"_46":47,"_45":228,"_190":95,"_43":229,"_13":192,"_40":26,"_41":230,"_30":95,"_194":-5,"_33":231},{"_89":217,"_38":218,"_36":219,"_188":-5,"_46":47,"_45":220,"_190":95,"_43":221,"_13":222,"_40":26,"_41":223,"_30":95,"_194":-5,"_33":224},{"_89":210,"_38":211,"_36":212,"_188":-5,"_46":47,"_45":213,"_190":31,"_43":214,"_13":109,"_40":53,"_41":215,"_30":95,"_194":-5,"_33":216},{"_89":203,"_38":204,"_36":205,"_188":-5,"_46":47,"_45":206,"_190":31,"_43":207,"_13":109,"_40":26,"_41":208,"_30":95,"_194":-5,"_33":209},{"_89":196,"_38":197,"_36":104,"_188":-5,"_46":47,"_45":198,"_190":95,"_43":199,"_13":192,"_40":200,"_41":201,"_30":95,"_194":-5,"_33":202},{"_89":185,"_38":186,"_36":187,"_188":-5,"_46":47,"_45":189,"_190":95,"_43":191,"_13":192,"_40":53,"_41":193,"_30":95,"_194":-5,"_33":195},"58fa9df6-07c8-11f1-9025-42dde27851f2","seed.ts","f1a63db4-07c6-11f1-9554-42dde27851f2","parentId",23,"latest",["D",1770869249279],2,"/**\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",[186],"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",[197],"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}",[204],"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",[211],"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.",[218],"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",[226],"03b2562e-07c6-11f1-8153-42dde27851f2",".vtignore","03b25796-07c6-11f1-8153-42dde27851f2",["D",1770868247174],".git\n.vscode\n.cursorrules\n.DS_Store\nnode_modules\nvendor",[233],"b20402cc-07c6-11f1-b4ca-42dde27851f2","db","b204038a-07c6-11f1-b4ca-42dde27851f2",5,["D",1770868539664],[239],"pulls","branches","forks","envVars",{"_251":109,"_253":109},"connections",{"_251":109,"_252":109},"count","unfilledCount","emptyCount",{"_89":238,"_38":239,"_36":240,"_188":-5,"_46":47,"_45":241,"_190":31,"_43":311,"_13":109,"_40":82,"_41":-5,"_30":95,"_194":-5,"_266":312,"_33":313},{"_89":303,"_38":304,"_36":305,"_188":240,"_46":47,"_45":306,"_190":31,"_43":307,"_13":222,"_40":53,"_41":308,"_30":95,"_194":-5,"_266":309,"_33":310},{"_89":295,"_38":296,"_36":297,"_188":240,"_46":47,"_45":298,"_190":95,"_43":299,"_13":241,"_40":53,"_41":300,"_30":95,"_194":-5,"_266":301,"_33":302},{"_89":287,"_38":288,"_36":289,"_188":240,"_46":47,"_45":290,"_190":95,"_43":291,"_13":109,"_40":53,"_41":292,"_30":95,"_194":-5,"_266":293,"_33":294},{"_89":232,"_38":233,"_36":234,"_188":-5,"_46":47,"_45":192,"_190":31,"_43":284,"_13":109,"_40":26,"_41":236,"_30":95,"_194":-5,"_266":285,"_33":286},{"_89":225,"_38":226,"_36":227,"_188":-5,"_46":47,"_45":228,"_190":95,"_43":281,"_13":192,"_40":26,"_41":230,"_30":95,"_194":-5,"_266":282,"_33":283},{"_89":217,"_38":218,"_36":219,"_188":-5,"_46":47,"_45":220,"_190":95,"_43":278,"_13":222,"_40":26,"_41":223,"_30":95,"_194":-5,"_266":279,"_33":280},{"_89":210,"_38":211,"_36":212,"_188":-5,"_46":47,"_45":213,"_190":31,"_43":275,"_13":109,"_40":53,"_41":215,"_30":95,"_194":-5,"_266":276,"_33":277},{"_89":203,"_38":204,"_36":205,"_188":-5,"_46":47,"_45":206,"_190":31,"_43":272,"_13":109,"_40":26,"_41":208,"_30":95,"_194":-5,"_266":273,"_33":274},{"_89":196,"_38":197,"_36":104,"_188":-5,"_46":47,"_45":198,"_190":95,"_43":269,"_13":192,"_40":200,"_41":201,"_30":95,"_194":-5,"_266":270,"_33":271},{"_89":185,"_38":186,"_36":187,"_188":-5,"_46":47,"_45":189,"_190":95,"_43":265,"_13":192,"_40":53,"_41":193,"_30":95,"_194":-5,"_266":267,"_33":268},["D",1770869249279],"children",[],[186],["D",1770871522665],[],[197],["D",1770868247163],[],[204],["D",1770868607201],[],[211],["D",1770869329624],[],[218],["D",1770871384419],[],[226],["D",1770868247174],[],[233],"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",[],[239,288],"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",[],[239,296],"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",[],[239,304],["D",1770868539664],[255,256,257],[239],["D",1770868165845],["D",1789518064818],{"_146":145,"_154":150},{"_146":145,"_147":148,"_149":150,"_18":102,"_151":152,"_153":95},{"_13":135,"_38":136,"_89":47,"_137":90,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":91,"_144":145},"ctx",{"_128":-5,"_174":352,"_353":354,"_355":356,"_357":95,"_358":95,"_359":95,"_360":31,"_361":-5,"_362":-7,"_363":-7,"_364":109,"_365":95,"_366":95,"_367":-5,"_368":95,"_369":95,"_370":95,"_371":-5},"ENV",{"_323":324,"_325":326,"_327":136,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351},"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 · v38