\n \n \n \n","label",[194,69],"frontend","pulls","branches","forks","envVars",{"_202":26,"_204":26},"connections",{"_202":26,"_203":26},"count","unfilledCount","emptyCount",{"_34":298,"_13":194,"_67":185,"_44":-5,"_36":37,"_186":41,"_187":106,"_38":299,"_40":26,"_70":248,"_190":-5,"_71":24,"_192":-5,"_223":300,"_17":301},{"_34":294,"_13":277,"_67":271,"_44":185,"_36":37,"_186":41,"_187":106,"_38":295,"_40":26,"_70":248,"_190":-5,"_71":24,"_192":-5,"_223":296,"_17":297},{"_34":286,"_13":287,"_67":288,"_44":271,"_36":37,"_186":289,"_187":106,"_38":290,"_40":189,"_70":240,"_190":291,"_71":24,"_192":-5,"_223":292,"_17":293},{"_34":278,"_13":279,"_67":280,"_44":271,"_36":37,"_186":281,"_187":106,"_38":282,"_40":26,"_70":240,"_190":283,"_71":24,"_192":-5,"_223":284,"_17":285},{"_34":268,"_13":269,"_67":270,"_44":271,"_36":37,"_186":272,"_187":106,"_38":273,"_40":230,"_70":240,"_190":274,"_71":24,"_192":-5,"_223":275,"_17":276},{"_34":261,"_13":262,"_67":263,"_44":185,"_36":37,"_186":41,"_187":106,"_38":264,"_40":26,"_70":21,"_190":265,"_71":24,"_192":-5,"_223":266,"_17":267},{"_34":184,"_13":69,"_67":68,"_44":185,"_36":37,"_186":86,"_187":106,"_38":258,"_40":189,"_70":21,"_190":191,"_71":24,"_192":-5,"_223":259,"_17":260},{"_34":251,"_13":252,"_67":253,"_44":185,"_36":37,"_186":41,"_187":106,"_38":254,"_40":26,"_70":240,"_190":255,"_71":24,"_192":-5,"_223":256,"_17":257},{"_34":245,"_13":244,"_67":237,"_44":-5,"_36":37,"_186":246,"_187":106,"_38":247,"_40":26,"_70":248,"_190":-5,"_71":24,"_192":-5,"_223":249,"_17":250},{"_34":234,"_13":235,"_67":236,"_44":237,"_36":37,"_186":238,"_187":106,"_38":239,"_40":41,"_70":240,"_190":241,"_71":24,"_192":-5,"_223":242,"_17":243},{"_34":226,"_13":227,"_67":228,"_44":-5,"_36":37,"_186":132,"_187":106,"_38":229,"_40":230,"_70":21,"_190":231,"_71":24,"_192":-5,"_223":232,"_17":233},{"_34":217,"_13":218,"_67":104,"_44":-5,"_36":37,"_186":219,"_187":106,"_38":220,"_40":189,"_70":221,"_190":222,"_71":24,"_192":-5,"_223":224,"_17":225},"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",[],[218],"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",[],[227],"c8615b9e-5688-11f1-890d-ee650bb23af1","types.ts","406e3ca2-5688-11f1-b1db-ee650bb23af1","9e564f9c-0cb6-4db6-87b8-2f1dd7679d0b",11,["D",1779528090232],"script","/** 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",[],[244,235],"shared","406e60a6-5688-11f1-b1db-ee650bb23af1",7,["D",1779527862148],"directory",[214],[244],"7d1c58ec-5687-11f1-8c19-ee650bb23af1","index.tsx","019e541b-4768-75cd-abda-bcdfd0a3da16",["D",1779527534382],"/** @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();",[],[194,252],["D",1779528159459],[],[194,69],"7d1c4dde-5687-11f1-8c19-ee650bb23af1","favicon.svg","019e541b-4768-75cd-abda-b4b5dde958ab",["D",1779527534382],"\n",[],[194,262],"4e786e26-5688-11f1-85d8-ee650bb23af1","RequestForm.tsx","019e541b-4768-75cd-abda-af418b764a12","019e541b-4768-75cd-abda-b0627a87a23a",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",[],[194,277,269],"components","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",[],[194,277,279],"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",[],[194,277,287],"7d1c4bae-5687-11f1-8c19-ee650bb23af1",["D",1779527534382],[207,208,209],[194,277],"7d1c5e96-5687-11f1-8c19-ee650bb23af1",["D",1779527534382],[206,210,211,212],[194],["D",1779527534382],["D",1789469441210],{"_11":12,"_149":74},{"_11":12,"_144":145,"_73":74,"_30":72,"_146":147,"_148":24},{"_40":132,"_13":16,"_34":37,"_133":94,"_134":64,"_135":136,"_137":98,"_138":139,"_140":141,"_142":14,"_143":12},"ctx",{"_53":-5,"_170":340,"_341":342,"_343":344,"_345":24,"_346":24,"_347":24,"_348":106,"_349":-5,"_350":-7,"_351":-7,"_352":26,"_353":24,"_354":24,"_355":-5,"_356":24,"_357":24,"_358":24,"_359":-5},"ENV",{"_311":312,"_313":314,"_315":16,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339},"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 · index.html