\n \n \n \n",[18,90],"7d1c4dde-5687-11f1-8c19-ee650bb23af1",["D",1779527534382],"\n",[18,96],"7d1c4bae-5687-11f1-8c19-ee650bb23af1",["D",1779527534382],[18,101],"pulls","branches","forks","envVars",{"_97":26,"_247":26},"connections",{"_97":26,"_246":26},"unfilledCount","emptyCount",{"_35":212,"_13":18,"_76":121,"_45":-5,"_37":38,"_215":42,"_223":24,"_39":328,"_41":26,"_79":102,"_213":-5,"_81":30,"_216":-5,"_266":329,"_17":330},{"_35":236,"_13":101,"_76":100,"_45":121,"_37":38,"_215":42,"_223":24,"_39":325,"_41":26,"_79":102,"_213":-5,"_81":30,"_216":-5,"_266":326,"_17":327},{"_35":317,"_13":318,"_76":319,"_45":100,"_37":38,"_215":320,"_223":24,"_39":321,"_41":229,"_79":80,"_213":322,"_81":30,"_216":-5,"_266":323,"_17":324},{"_35":309,"_13":310,"_76":311,"_45":100,"_37":38,"_215":312,"_223":24,"_39":313,"_41":26,"_79":80,"_213":314,"_81":30,"_216":-5,"_266":315,"_17":316},{"_35":301,"_13":302,"_76":303,"_45":100,"_37":38,"_215":304,"_223":24,"_39":305,"_41":273,"_79":80,"_213":306,"_81":30,"_216":-5,"_266":307,"_17":308},{"_35":232,"_13":96,"_76":95,"_45":121,"_37":38,"_215":42,"_223":24,"_39":298,"_41":26,"_79":21,"_213":234,"_81":30,"_216":-5,"_266":299,"_17":300},{"_35":227,"_13":90,"_76":89,"_45":121,"_37":38,"_215":114,"_223":24,"_39":295,"_41":229,"_79":21,"_213":230,"_81":30,"_216":-5,"_266":296,"_17":297},{"_35":222,"_13":78,"_76":77,"_45":121,"_37":38,"_215":42,"_223":24,"_39":292,"_41":26,"_79":80,"_213":225,"_81":30,"_216":-5,"_266":293,"_17":294},{"_35":287,"_13":286,"_76":280,"_45":-5,"_37":38,"_215":288,"_223":24,"_39":289,"_41":26,"_79":102,"_213":-5,"_81":30,"_216":-5,"_266":290,"_17":291},{"_35":277,"_13":278,"_76":279,"_45":280,"_37":38,"_215":281,"_223":24,"_39":282,"_41":42,"_79":80,"_213":283,"_81":30,"_216":-5,"_266":284,"_17":285},{"_35":269,"_13":270,"_76":271,"_45":-5,"_37":38,"_215":160,"_223":24,"_39":272,"_41":273,"_79":21,"_213":274,"_81":30,"_216":-5,"_266":275,"_17":276},{"_35":260,"_13":261,"_76":133,"_45":-5,"_37":38,"_215":262,"_223":24,"_39":263,"_41":229,"_79":264,"_213":265,"_81":30,"_216":-5,"_266":267,"_17":268},"d48872f4-5688-11f1-b680-ee650bb23af1","index.ts",12,["D",1779528110631],"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\nimport type { AssistanceRequest, ChatMessage } from \"./shared/types.ts\";\n\nconst app = new Hono();\n\n// ── Initialise DB tables on cold start ─────────────────────\nawait sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS assistance_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n textContent TEXT NOT NULL,\n timestamp TEXT NOT NULL\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS chat_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp TEXT NOT NULL\n )`,\n },\n]);\n\n// ── SSE: connected chat clients ────────────────────────────\ntype SSEClient = { controller: ReadableStreamDefaultController; closed: boolean };\nconst sseClients = new Set();\n\nfunction broadcastSSE(msg: ChatMessage) {\n const data = `data: ${JSON.stringify(msg)}\\n\\n`;\n for (const client of sseClients) {\n if (client.closed) {\n sseClients.delete(client);\n continue;\n }\n try {\n client.controller.enqueue(new TextEncoder().encode(data));\n } catch {\n client.closed = true;\n sseClients.delete(client);\n }\n }\n}\n\n// ── Assistance Request API ─────────────────────────────────\n\napp.get(\"/api/requests\", async (c) => {\n const result = await sqlite.execute(\n \"SELECT id, textContent, timestamp FROM assistance_requests ORDER BY id DESC\",\n );\n return c.json(result.rows as AssistanceRequest[]);\n});\n\napp.post(\"/api/requests\", async (c) => {\n const body = await c.req.json<{ textContent?: string }>();\n const text = (body.textContent ?? \"\").trim();\n if (!text) {\n return c.json({ error: \"textContent is required and cannot be empty\" }, 400);\n }\n const timestamp = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO assistance_requests (textContent, timestamp) VALUES (?, ?)\",\n args: [text, timestamp],\n });\n const saved: AssistanceRequest = {\n id: Number(result.lastInsertRowid),\n textContent: text,\n timestamp,\n };\n return c.json(saved, 201);\n});\n\n// ── Chat API ───────────────────────────────────────────────\n\n// Get chat history (last 100 messages, oldest first for display)\napp.get(\"/api/chat\", async (c) => {\n const result = await sqlite.execute(\n `SELECT id, username, message, timestamp FROM chat_messages\n ORDER BY id DESC LIMIT 100`,\n );\n const rows = result.rows as ChatMessage[];\n rows.reverse(); // oldest first for chronological display\n return c.json(rows);\n});\n\n// Post a new chat message\napp.post(\"/api/chat\", async (c) => {\n const body = await c.req.json<{ username?: string; message?: string }>();\n const username = (body.username ?? \"\").trim();\n const message = (body.message ?? \"\").trim();\n\n if (!username) {\n return c.json({ error: \"username is required\" }, 400);\n }\n if (!message) {\n return c.json({ error: \"message cannot be empty\" }, 400);\n }\n\n const timestamp = new Date().toISOString();\n const result = await sqlite.execute({\n sql: \"INSERT INTO chat_messages (username, message, timestamp) VALUES (?, ?, ?)\",\n args: [username, message, timestamp],\n });\n\n const saved: ChatMessage = {\n id: Number(result.lastInsertRowid),\n username,\n message,\n timestamp,\n };\n\n // Push to all SSE listeners\n broadcastSSE(saved);\n\n return c.json(saved, 201);\n});\n\n// SSE stream — clients connect here to receive real-time messages\napp.get(\"/api/chat/stream\", (c) => {\n const stream = new ReadableStream({\n start(controller) {\n const client: SSEClient = { controller, closed: false };\n sseClients.add(client);\n\n // Send a keep-alive comment immediately so the connection establishes\n controller.enqueue(new TextEncoder().encode(\": connected\\n\\n\"));\n },\n cancel() {\n // Client disconnected — cleanup happens in broadcastSSE\n },\n });\n\n return new Response(stream, {\n headers: {\n \"Content-Type\": \"text/event-stream\",\n \"Cache-Control\": \"no-cache\",\n Connection: \"keep-alive\",\n },\n });\n});\n\n// ── Static files ───────────────────────────────────────────\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Unwrap Hono errors for full stack traces\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","children",[],[261],"f94987b8-5688-11f1-b10d-ee650bb23af1","README.md","019e541b-4768-75cd-abda-c5708e4b09e5",["D",1779528172288],3,"# 🛎️ Assistance Hub\n\nA full-stack app with two features: **assistance requests** and **live chat** — both persisted in SQLite.\n\n## Features\n\n### 📋 Requests Tab\n- Submit assistance requests with validation\n- All requests saved to the database and displayed newest-first\n- Persists across page refreshes\n\n### 💬 Live Chat Tab\n- Enter a username to join the chat room\n- Messages delivered in real-time via **Server-Sent Events (SSE)**\n- Chat history (last 100 messages) loaded from the database on join\n- Messages from you appear on the right (blue), others on the left (white)\n- Live indicator shows connection status\n\n## Data model\n\n**assistance_requests**\n| Column | Type | Description |\n|--------|------|-------------|\n| `id` | INTEGER | Auto-incrementing PK |\n| `textContent` | TEXT | Request content (validated non-empty) |\n| `timestamp` | TEXT | ISO 8601 |\n\n**chat_messages**\n| Column | Type | Description |\n|--------|------|-------------|\n| `id` | INTEGER | Auto-incrementing PK |\n| `username` | TEXT | Sender's display name |\n| `message` | TEXT | Message content (validated non-empty) |\n| `timestamp` | TEXT | ISO 8601 |\n\n## API\n\n| Method | Endpoint | Description |\n|--------|----------|-------------|\n| `GET` | `/api/requests` | All assistance requests |\n| `POST` | `/api/requests` | Submit a request |\n| `GET` | `/api/chat` | Chat history (last 100) |\n| `POST` | `/api/chat` | Send a chat message |\n| `GET` | `/api/chat/stream` | SSE stream for real-time messages |\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts (Hono)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| React[\"App.tsx\"]\n React -->|tab| RQ[\"RequestForm.tsx\"]\n React -->|tab| LC[\"LiveChat.tsx\"]\n RQ -->|\"REST API\"| Hono\n LC -->|\"REST + SSE\"| Hono\n Hono -->|read/write| DB[\"SQLite\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono server (API + SSE + static files)\nshared/\n types.ts ← AssistanceRequest & ChatMessage types\nfrontend/\n index.html ← HTML shell\n index.tsx ← React entrypoint\n components/\n App.tsx ← Tab navigation (Requests / Chat)\n RequestForm.tsx ← Assistance request form + list\n LiveChat.tsx ← Username gate + chat UI + SSE listener\n```\n",[],[270],"c8615b9e-5688-11f1-890d-ee650bb23af1","types.ts","406e3ca2-5688-11f1-b1db-ee650bb23af1","9e564f9c-0cb6-4db6-87b8-2f1dd7679d0b",11,["D",1779528090232],"/** A single assistance request stored in the database */\nexport interface AssistanceRequest {\n id: number;\n textContent: string;\n timestamp: string; // ISO 8601\n}\n\n/** A single chat message stored in the database */\nexport interface ChatMessage {\n id: number;\n username: string;\n message: string;\n timestamp: string; // ISO 8601\n}\n",[],[286,278],"shared","406e60a6-5688-11f1-b1db-ee650bb23af1",7,["D",1779527862148],[257],[286],["D",1779527534382],[],[18,78],["D",1779528159459],[],[18,90],["D",1779527534382],[],[18,96],"4e786e26-5688-11f1-85d8-ee650bb23af1","RequestForm.tsx","019e541b-4768-75cd-abda-af418b764a12",9,["D",1779527885707],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { AssistanceRequest } from \"../../shared/types.ts\";\n\nexport function RequestForm() {\n const [input, setInput] = useState(\"\");\n const [requests, setRequests] = useState([]);\n const [loading, setLoading] = useState(true);\n const [submitting, setSubmitting] = useState(false);\n const [error, setError] = useState(null);\n\n // Load all saved requests on mount\n useEffect(() => {\n fetch(\"/api/requests\")\n .then((r) => r.json())\n .then((data) => setRequests(data))\n .catch(() => setError(\"Failed to load requests\"))\n .finally(() => setLoading(false));\n }, []);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n const trimmed = input.trim();\n if (!trimmed) return;\n\n setSubmitting(true);\n setError(null);\n\n try {\n const res = await fetch(\"/api/requests\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ textContent: trimmed }),\n });\n\n if (!res.ok) {\n const err = await res.json();\n throw new Error(err.error || \"Failed to save request\");\n }\n\n const saved: AssistanceRequest = await res.json();\n setRequests((prev) => [saved, ...prev]);\n setInput(\"\");\n } catch (err: any) {\n setError(err.message);\n } finally {\n setSubmitting(false);\n }\n };\n\n const formatTime = (iso: string) => {\n const d = new Date(iso);\n return d.toLocaleDateString() + \" \" + d.toLocaleTimeString();\n };\n\n return (\n

\n {/* Input form */}\n

\n setInput((e.target as HTMLInputElement).value)}\n placeholder=\"Describe what you need help with...\"\n disabled={submitting}\n class=\"flex-1 border border-gray-300 rounded-lg px-4 py-2 text-base focus:outline-none focus:ring-2 focus:ring-blue-400 focus:border-transparent disabled:opacity-50\"\n />\n \n {submitting ? \"Saving...\" : \"Submit\"}\n \n \n\n {/* Error message */}\n {error && (\n

{error}

\n )}\n\n {/* Display area */}\n

\n {loading\n ?

Loading requests...

\n : requests.length === 0\n ? (\n

\n No requests yet. Submit one above!\n

\n )\n : (\n

\n {req.textContent}\n \n {formatTime(req.timestamp)}\n \n \n ))}\n

\n )}\n

\n );\n}\n",[],[18,101,302],"e2f57cba-5688-11f1-b350-ee650bb23af1","LiveChat.tsx","e2f57d8c-5688-11f1-b350-ee650bb23af1",13,["D",1779528134822],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ChatMessage } from \"../../shared/types.ts\";\n\nexport function LiveChat() {\n const [username, setUsername] = useState(\"\");\n const [joined, setJoined] = useState(false);\n const [messages, setMessages] = useState([]);\n const [input, setInput] = useState(\"\");\n const [sending, setSending] = useState(false);\n const [error, setError] = useState(null);\n const bottomRef = useRef(null);\n const eventSourceRef = useRef(null);\n\n // Scroll to bottom when messages change\n useEffect(() => {\n bottomRef.current?.scrollIntoView({ behavior: \"smooth\" });\n }, [messages]);\n\n // On join: load history + connect SSE\n useEffect(() => {\n if (!joined) return;\n\n // Load chat history\n fetch(\"/api/chat\")\n .then((r) => r.json())\n .then((data: ChatMessage[]) => setMessages(data))\n .catch(() => setError(\"Failed to load chat history\"));\n\n // Connect to SSE stream for real-time updates\n const es = new EventSource(\"/api/chat/stream\");\n eventSourceRef.current = es;\n\n es.onmessage = (event) => {\n const msg: ChatMessage = JSON.parse(event.data);\n setMessages((prev) => [...prev, msg]);\n };\n\n es.onerror = () => {\n // EventSource auto-reconnects, but we can show a transient note\n console.warn(\"SSE connection lost, reconnecting...\");\n };\n\n return () => {\n es.close();\n eventSourceRef.current = null;\n };\n }, [joined]);\n\n const handleJoin = (e: React.FormEvent) => {\n e.preventDefault();\n if (username.trim()) {\n setJoined(true);\n }\n };\n\n const handleSend = async (e: React.FormEvent) => {\n e.preventDefault();\n const trimmed = input.trim();\n if (!trimmed || sending) return;\n\n setSending(true);\n setError(null);\n\n try {\n const res = await fetch(\"/api/chat\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ username, message: trimmed }),\n });\n if (!res.ok) {\n const err = await res.json();\n throw new Error(err.error || \"Failed to send\");\n }\n // Don't append here — SSE will deliver it back to us (and all other clients)\n setInput(\"\");\n } catch (err: any) {\n setError(err.message);\n } finally {\n setSending(false);\n }\n };\n\n const formatTime = (iso: string) => {\n return new Date(iso).toLocaleTimeString([], { hour: \"2-digit\", minute: \"2-digit\" });\n };\n\n // ── Join screen ──────────────────────────────────────────\n if (!joined) {\n return (\n

💬

Join the Chat

Enter a username to start chatting

\n );\n }\n\n // ── Chat screen ──────────────────────────────────────────\n return (\n

\n {/* Header */}\n

\n \n Chatting as {username}\n \n \n Live\n \n

\n\n {/* Messages area */}\n

\n {messages.length === 0 && (\n

\n No messages yet. Say something!\n

\n )}\n {messages.map((msg) => {\n const isMe = msg.username === username;\n return (\n

\n \n {isMe ? \"You\" : msg.username} · {formatTime(msg.timestamp)}\n \n \n {msg.message}\n

\n );\n })}\n

\n\n {/* Error */}\n {error &&

{error}

}\n\n {/* Input */}\n

\n );\n}\n",[],[18,101,310],"e96ed528-5688-11f1-9b52-ee650bb23af1","App.tsx","019e541b-4768-75cd-abda-aafeb363f75c",14,["D",1779528145690],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { RequestForm } from \"./RequestForm.tsx\";\nimport { LiveChat } from \"./LiveChat.tsx\";\n\ntype Tab = \"requests\" | \"chat\";\n\nexport function App() {\n const [tab, setTab] = useState(\"requests\");\n\n const tabClass = (t: Tab) =>\n `px-5 py-2 font-medium text-sm rounded-t-lg cursor-pointer transition-colors ${\n tab === t\n ? \"bg-white border border-b-0 border-gray-200 text-blue-600\"\n : \"text-gray-500 hover:text-gray-700 hover:bg-gray-100\"\n }`;\n\n return (\n

🛎️ Assistance Hub

Submit requests or chat live with others.

\n\n {/* Tabs */}\n

\n \n \n

\n\n {/* Tab content */}\n

\n {tab === \"requests\" ? : }\n

\n\n

\n View source\n

\n );\n}\n",[],[18,101,318],["D",1779527534382],[250,251,252],[18,101],["D",1779527534382],[249,253,254,255],[18],["D",1779527534382],["D",1789469441210],{"_11":12,"_177":84},{"_11":12,"_172":173,"_83":84,"_31":82,"_174":175,"_176":30},{"_41":160,"_13":16,"_35":38,"_161":123,"_162":73,"_163":164,"_165":127,"_166":167,"_168":169,"_170":14,"_171":12},"ctx",{"_54":-5,"_198":369,"_370":371,"_372":373,"_374":30,"_375":30,"_376":30,"_377":24,"_378":-5,"_379":-7,"_380":-7,"_381":26,"_382":30,"_383":30,"_384":-5,"_385":30,"_386":30,"_387":30,"_388":-5},"ENV",{"_340":341,"_342":343,"_344":16,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368},"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"]

History · frontend