\",\n `

${appHtml}

`,\n );\n\n // Return the HTML with the appropriate headers\n return c.html(html);\n});\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Export the app for HTTP vals\nexport default app.fetch;","deleted",false,"label","react-router-7-example",[19,37],"5ae47cc0-14cd-11f0-bbde-569c3dd06744","database","4af61b55-4e6e-48ee-bb08-a35baadaf267",3,["D",1744153267418],0,"directory",[19,61],"5ae47a2c-14cd-11f0-bbde-569c3dd06744",["D",1744153267418],[19],{"_35":68,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":63,"_46":47,"_48":300,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":301,"_18":302},{"_35":217,"_13":218,"_38":219,"_40":-5,"_42":43,"_44":197,"_46":47,"_48":220,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":221,"_18":222},{"_35":121,"_13":122,"_38":123,"_40":-5,"_42":43,"_44":124,"_46":47,"_48":125,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":126,"_18":127},{"_35":96,"_13":97,"_38":98,"_40":-5,"_42":43,"_44":99,"_46":47,"_48":100,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":101,"_18":102},{"_35":87,"_13":88,"_38":89,"_40":-5,"_42":43,"_44":90,"_46":47,"_48":91,"_17":92,"_51":24,"_53":93,"_55":56,"_57":-5,"_84":94,"_18":95},{"_35":77,"_13":78,"_38":79,"_40":-5,"_42":43,"_44":80,"_46":47,"_48":81,"_17":82,"_51":24,"_53":83,"_55":56,"_57":-5,"_84":85,"_18":86},"db92e8f0-163c-11f0-8f3c-569c3dd06744","TODO.md","471f7894-1594-11f0-bc2d-569c3dd06744",143,["D",1744311108608],11,"- [ ] Get OpenTownie or Gemini or Claude or OpenAI to synthesize the core of these patterns into a prompt we can use to make more ReactRouter apps, such as...\n- [ ] Convert this or into the basic react router guest book (and preserve this forum app in another project?)\n- [ ] To what extent can these patterns be packaged up into a Val Town Router project? Would be neat to get the version pinning thing all centralized, can this as-a-library be that centralized place?","children",[],[78],"b26e0ca4-0fe5-11f1-bc51-42dde27851f2","README.md","513e59ca-14cd-11f0-8f60-569c3dd06744",178,["D",1771761464050],9,"# React Router 7 on Val Town\n\nA full-stack SSR + SPA reference architecture for [Val Town](https://val.town), built with **React Router 7**, **Hono**, and **SQLite**. Ships as a community message board demo, but the patterns here are designed to be extracted into a reusable framework/template.\n\n> **Live demo:** \n\n## Why This Exists\n\nVal Town gives you serverless TypeScript functions, but building a real full-stack app with SSR, client-side navigation, loaders, actions, and hydration requires wiring together several pieces. This project demonstrates one clean way to do it — and is the seed for a potential **Val Town Router** framework.\n\n## Architecture Overview\n\n```mermaid\ngraph TD\n subgraph \"Browser\"\n A[index.html] -->|loads| B[frontend/index.tsx]\n B -->|creates| C[createBrowserRouter]\n C -->|uses| D[dataStrategy]\n D -->|\"fetch with X-Data-Request: true\"| E\n end\n\n subgraph \"Val Town Server — backend/index.ts\"\n E[Hono HTTP Handler]\n E -->|\"static files\"| F[serveFile]\n E -->|\"SSR or data request\"| G[createStaticHandler]\n G -->|runs| H[Loaders / Actions]\n H -->|queries| I[(SQLite)]\n G -->|\"full page\"| J[renderToString → HTML]\n G -->|\"data request\"| K[JSON response]\n end\n\n subgraph \"Shared — shared/\"\n L[routes.ts] -.->|\"imported by both\"| C\n L -.->|\"imported by both\"| G\n M[types.ts] -.->|\"used everywhere\"| H\n end\n\n style A fill:#e0f2fe\n style B fill:#e0f2fe\n style C fill:#e0f2fe\n style D fill:#e0f2fe\n style E fill:#fef3c7\n style F fill:#fef3c7\n style G fill:#fef3c7\n style H fill:#fef3c7\n style I fill:#d1fae5\n style J fill:#fef3c7\n style K fill:#fef3c7\n style L fill:#f3e8ff\n style M fill:#f3e8ff\n```\n\n## Request Lifecycle\n\n```mermaid\nsequenceDiagram\n participant Browser\n participant Hono as Hono Server\n participant RR as React Router Static Handler\n participant DB as SQLite\n\n Note over Browser,DB: First visit (SSR)\n Browser->>Hono: GET /topics/42\n Hono->>RR: query(request)\n RR->>DB: Topic.loader → getTopicById(42)\n DB-->>RR: topic + messages\n RR-->>Hono: StaticHandlerContext\n Hono->>Hono: renderToString(StaticRouterProvider)\n Hono-->>Browser: Full HTML page\n\n Note over Browser,DB: Subsequent navigation (SPA)\n Browser->>Browser: User clicks \n Browser->>Hono: GET /search?q=hello (X-Data-Request: true)\n Hono->>RR: query(request)\n RR->>DB: Search.loader → search(\"hello\")\n DB-->>RR: search results\n RR-->>Hono: StaticHandlerContext\n Hono-->>Browser: JSON { loaderData: {...} }\n Browser->>Browser: React Router updates UI\n\n Note over Browser,DB: Form submission (Action)\n Browser->>Hono: POST /topics/42 (X-Data-Request: true, formData)\n Hono->>RR: query(request)\n RR->>DB: Topic.action → createMessage(42, content)\n DB-->>RR: new message\n RR-->>Hono: Redirect response\n Hono-->>Browser: JSON { redirect: \"/topics/42\" }\n Browser->>Browser: Client-side redirect + re-fetch loaders\n```\n\n## Features\n\n- **Server-Side Rendering** — Every page is fully rendered on first visit (SEO-friendly, fast paint)\n- **Client-Side Navigation** — After hydration, navigation is instant SPA-style\n- **Single-Fetch Data Strategy** — Client navigation makes one request per route transition, not one per loader\n- **Loaders & Actions** — Remix-style data loading and form handling, co-located with route components\n- **Redirect Handling** — Server actions return redirects as JSON for the client `dataStrategy` to follow\n- **SQLite Persistence** — Val Town's built-in SQLite with idempotent migrations and seed data\n- **Loading States** — `useNavigation()` for global loading indicators\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Hono HTTP entry point (SSR + data API + static files)\n│ └── database/\n│ ├── migrations.ts # Schema creation + seed data\n│ └── queries.ts # All database queries\n├── frontend/\n│ ├── index.html # HTML shell template\n│ ├── index.tsx # Client entry — hydration + dataStrategy\n│ └── components/\n│ ├── App.tsx # (unused legacy — see routes/App.tsx)\n│ ├── LoadingSpinner.tsx\n│ ├── MessageForm.tsx\n│ ├── MessageList.tsx\n│ ├── SearchForm.tsx\n│ └── SearchResults.tsx\n├── routes/\n│ ├── App.tsx # Root layout (Outlet + nav + footer)\n│ ├── Home.tsx # Home page — topic list + create form\n│ ├── Home.loader.ts # Loads all topics\n│ ├── Topic.tsx # Topic detail — messages + reply form\n│ ├── Topic.loader.ts # Loads topic + messages\n│ ├── Topic.action.ts # Creates a message in a topic\n│ ├── TopicMessage.loader.ts # Direct link to a specific message\n│ ├── Topics.action.ts # Creates a new topic (root action)\n│ ├── Search.tsx # Search results page\n│ └── Search.loader.ts # Runs search query\n├── shared/\n│ ├── routes.ts # Route tree (shared between server + client)\n│ └── types.ts # TypeScript interfaces (Topic, Message, SearchResults)\n├── README.md\n└── TODO.md\n```\n\n## Key Patterns\n\n### 1. Shared Route Definitions (`shared/routes.ts`)\n\nThe same route tree is used on both server and client. The `serverLoader()` / `serverAction()` helpers make this work:\n\n- **On the server:** dynamically import the real loader/action module and call it\n- **On the client:** return a no-op stub (the `dataStrategy` handles fetching)\n\nThis means loader/action code (and its database dependencies) **never ships to the browser**.\n\n### 2. Single-Fetch `dataStrategy` (`frontend/index.tsx`)\n\nInstead of React Router calling each loader individually on the client, a custom `dataStrategy` makes **one HTTP request** with a `X-Data-Request: true` header. The server runs all matched loaders/actions and returns their data as keyed JSON.\n\n### 3. SSR with Hydration (`backend/index.ts`)\n\nOn full page loads:\n1. `createStaticHandler` runs loaders\n2. `createStaticRouter` + `StaticRouterProvider` renders to HTML string\n3. HTML is injected into the `index.html` template\n4. Client picks up with `hydrateRoot` + `createBrowserRouter`\n\n### 4. Action → Redirect → Reload\n\nForm submissions go through React Router actions. On the server, the action returns a `redirect()`. For data requests, the server converts this to `{ redirect: \"/path\" }` JSON so the client `dataStrategy` can follow it, triggering a client-side navigation + loader re-fetch.\n\n## URL Structure\n\n| URL | Description |\n|-----|-------------|\n| `/` | Home — list of topics + create form |\n| `/topics/:topicId` | Topic detail — messages + reply form |\n| `/topics/:topicId/messages/:messageId` | Deep link to a specific message |\n| `/search?q=query` | Search results across topics and messages |\n\n## Tech Stack\n\n| Layer | Technology | Purpose |\n|-------|-----------|---------|\n| Server | [Hono](https://hono.dev/) | HTTP routing, static files, SSR orchestration |\n| Routing | [React Router 7](https://reactrouter.com/) | SSR + SPA routing, loaders, actions |\n| UI | [React 18](https://react.dev/) | Components + hydration |\n| Styling | [Twind](https://twind.dev/) | Tailwind-in-JS (CDN) |\n| Database | Val Town SQLite | Project-scoped persistence via `std/sqlite` |\n| Runtime | Val Town (Deno) | Serverless hosting |\n\n## Towards a Framework / Template\n\nThis project is designed to be the starting point for a reusable **Val Town fullstack framework**. Here's what could be extracted:\n\n### What's Already Framework-Ready\n\n- **`serverLoader()` / `serverAction()` pattern** — Generic helpers that work with any route tree\n- **`dataStrategy` implementation** — The single-fetch client strategy is app-agnostic\n- **SSR pipeline in `backend/index.ts`** — The Hono → StaticHandler → render → hydrate flow is generic\n- **`X-Data-Request` protocol** — Simple convention for distinguishing SSR vs data-only requests\n\n### Suggestions for Extraction\n\n```mermaid\ngraph BT\n subgraph \"Your App\"\n A[routes/Home.tsx]\n B[routes/Topic.tsx]\n C[backend/database/queries.ts]\n end\n\n subgraph \"Val Town Router Framework\"\n D[\"createValTownRouter()\"]\n E[\"createRoutes()\"]\n F[\"dataStrategy (single-fetch)\"]\n G[\"SSR pipeline\"]\n H[\"HTML shell generator\"]\n I[\"deps.ts (version pins)\"]\n J[\"File-based route discovery\"]\n end\n\n subgraph \"Val Town Platform\"\n K[Hono]\n L[SQLite]\n M[Deno Runtime]\n N[esm.sh CDN]\n end\n\n A & B -->|\"define routes via\"| E\n C -->|\"queries\"| L\n E -->|\"passed to\"| D\n D -->|\"creates\"| K\n D -->|\"wires up\"| G\n D -->|\"wires up\"| F\n D -->|\"generates\"| H\n I -->|\"pins versions for\"| N\n J -->|\"auto-discovers\"| E\n K & L & M & N -->|\"provided by\"| M\n\n style A fill:#e0f2fe\n style B fill:#e0f2fe\n style C fill:#e0f2fe\n style D fill:#fef3c7\n style E fill:#fef3c7\n style F fill:#fef3c7\n style G fill:#fef3c7\n style H fill:#fef3c7\n style I fill:#fef3c7\n style J fill:#fef3c7\n style K fill:#d1fae5\n style L fill:#d1fae5\n style M fill:#d1fae5\n style N fill:#d1fae5\n```\n\n1. **`createValTownRouter(routes, options)`** — A single function that returns a Hono app with SSR, static file serving, and the data-request protocol baked in. Users just supply routes and get a working full-stack app:\n ```ts\n import { createValTownRouter } from \"https://esm.town/v/std/valtown-router\";\n import { routes } from \"./shared/routes.ts\";\n export default createValTownRouter(routes, { title: \"My App\" });\n ```\n\n2. **Centralized `deps.ts` version pinning** — React, React Router, and React DOM versions are repeated across many files via `esm.sh` URLs (currently 7+ files all reference `react@18.2.0`). A framework could export these from a single manifest:\n ```ts\n // deps.ts — one place to update versions\n export { default as React } from \"https://esm.sh/react@18.2.0\";\n export { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n export { createBrowserRouter, ... } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\n ```\n\n3. **`createRoutes()` helper** — A typed helper that wraps the `serverLoader`/`serverAction` pattern so users don't need to understand the server/client bifurcation:\n ```ts\n createRoutes([\n { path: \"/\", Component: App, children: [\n { index: true, Component: Home, loader: \"./Home.loader.ts\" },\n { path: \"topics/:id\", Component: Topic, loader: \"./Topic.loader.ts\", action: \"./Topic.action.ts\" },\n ]}\n ])\n ```\n\n4. **File-based route discovery** — The `routes/` directory already follows Remix-style naming conventions (`Home.tsx`, `Home.loader.ts`, `Topic.action.ts`). A framework could auto-discover routes from the filesystem, eliminating the manual `shared/routes.ts` file entirely:\n ```\n routes/\n _layout.tsx → root layout (App)\n _index.tsx → / (Home)\n _index.loader.ts → Home loader\n topics.$id.tsx → /topics/:id (Topic)\n topics.$id.loader.ts\n topics.$id.action.ts\n search.tsx → /search\n search.loader.ts\n ```\n\n5. **HTML template generation** — Instead of a manual `index.html`, the framework could generate the shell with the right scripts, twind, and catch handler included. No more forgetting to add ``.\n\n6. **~~Project-scoped SQLite by default~~** ✅ **Done!** — Migrated from `@stevekrouse/sqlite` (user-scoped) to `std/sqlite` (project-scoped). Each fork now gets its own isolated database automatically.\n\n7. **Middleware hooks** — Auth, logging, error boundaries, CORS, etc. as composable Hono middleware that plugs into the framework:\n ```ts\n export default createValTownRouter(routes, {\n middleware: [authMiddleware(), corsMiddleware()],\n errorBoundary: MyErrorBoundary,\n });\n ```\n\n8. **CLI / `init` template** — A `createValTownApp` script or a Val Town project template that scaffolds the full directory structure with a working starter app in one click.\n\n### Open Questions\n\n- How much of the Hono boilerplate can be hidden vs left explicit for power users?\n- What's the right story for CSS — keep Twind CDN, support CSS modules, or Tailwind build?\n- Should the framework ship as a single Val Town val (importable library) or as an npm package on esm.sh?\n- Could hydration data be embedded in the HTML (like Remix does) instead of requiring a separate client fetch on first load?\n\n## Getting Started\n\n1. **Fork this val** on Val Town\n2. The database auto-initializes with seed data on first request\n3. Visit the HTTP endpoint to see the app\n4. Modify routes in `shared/routes.ts`, add components in `routes/`, and queries in `backend/database/`\n\n## Dependencies\n\nAll dependencies are loaded via `esm.sh` with pinned versions:\n\n- `react@18.2.0`\n- `react-dom@18.2.0`\n- `react-router@7.5.0`\n- `hono@4.1.0`\n- `@valtown/std/utils` (for `readFile` / `serveFile`)\n- `@std/sqlite` (Val Town project-scoped SQLite)\n",[],[88],"5343c3fe-14cd-11f0-b10b-569c3dd06744","shared","add21c84-9f00-4405-af88-6ec5134089df",2,["D",1744153254621],[103,104],[97],{"_35":113,"_13":114,"_38":115,"_40":98,"_42":43,"_44":45,"_46":47,"_48":116,"_17":117,"_51":109,"_53":118,"_55":56,"_57":-5,"_84":119,"_18":120},{"_35":105,"_13":106,"_38":107,"_40":98,"_42":43,"_44":99,"_46":47,"_48":108,"_17":65,"_51":109,"_53":110,"_55":56,"_57":-5,"_84":111,"_18":112},"5343bcb0-14cd-11f0-b10b-569c3dd06744","types.ts","5343bd78-14cd-11f0-b10b-569c3dd06744",["D",1744153254621],"script","/**\n * Topic model representing a discussion thread\n */\nexport interface Topic {\n id: number;\n title: string;\n createdAt: string;\n}\n\n/**\n * Message model representing a post within a topic\n */\nexport interface Message {\n id: number;\n topicId: number;\n content: string;\n createdAt: string;\n}\n\n/**\n * Search results containing matching topics and messages\n */\nexport interface SearchResults {\n topics: Topic[];\n messages: Message[];\n query: string;\n}",[],[97,106],"b51b1732-0f84-11f1-b328-42dde27851f2","routes.ts","7639f8f6-14d2-11f0-97d5-569c3dd06744",["D",1771719807352],28,"import {\n type ActionFunctionArgs,\n type LoaderFunctionArgs,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { App } from \"../routes/App.tsx\";\nimport { Home } from \"../routes/Home.tsx\";\nimport { Search } from \"../routes/Search.tsx\";\nimport { Topic } from \"../routes/Topic.tsx\";\n\nlet isServer = typeof document === \"undefined\";\n\n// On the server, dynamically import the real loader/action function.\n// On the client, return a no-op stub. The stub's presence signals to\n// React Router that this route needs data (so it appears in dataStrategy's\n// `matches` with shouldLoad=true), but dataStrategy handles the actual\n// fetching via a single HTTP request to the server.\nfunction serverLoader(importURL: string) {\n if (isServer) {\n return async (args: LoaderFunctionArgs) => {\n let module = await import(importURL);\n let loader = module.loader || module.default;\n return loader(args);\n };\n }\n // Client stub — never actually called when dataStrategy is provided\n return () => null;\n}\n\nfunction serverAction(importURL: string) {\n if (isServer) {\n return async (args: ActionFunctionArgs) => {\n let module = await import(importURL);\n let action = module.action || module.default;\n return action(args);\n };\n }\n // Client stub — never actually called when dataStrategy is provided\n return () => null;\n}\n\nexport const routes = [\n {\n path: \"/\",\n Component: App,\n action: serverAction(\"../routes/Topics.action.ts\"),\n children: [\n {\n index: true,\n Component: Home,\n loader: serverLoader(\"../routes/Home.loader.ts\"),\n },\n {\n path: \"topics/:topicId\",\n Component: Topic,\n loader: serverLoader(\"../routes/Topic.loader.ts\"),\n action: serverAction(\"../routes/Topic.action.ts\"),\n },\n {\n path: \"topics/:topicId/messages/:messageId\",\n Component: Topic,\n loader: serverLoader(\"../routes/TopicMessage.loader.ts\"),\n },\n {\n path: \"search\",\n Component: Search,\n loader: serverLoader(\"../routes/Search.loader.ts\"),\n },\n ],\n },\n];",[],[97,114],"f8ffd76c-1593-11f0-9dd6-569c3dd06744","routes","c4795b2d-41e5-4e2d-bb49-1239d72d4d2d",81,["D",1744238573020],[128,129,130,131,132,133,134,135,136,137],[122],{"_35":208,"_13":209,"_38":210,"_40":123,"_42":43,"_44":211,"_46":47,"_48":212,"_17":213,"_51":109,"_53":214,"_55":56,"_57":-5,"_84":215,"_18":216},{"_35":201,"_13":202,"_38":203,"_40":123,"_42":43,"_44":124,"_46":47,"_48":204,"_17":65,"_51":109,"_53":205,"_55":56,"_57":-5,"_84":206,"_18":207},{"_35":192,"_13":193,"_38":194,"_40":123,"_42":43,"_44":195,"_46":47,"_48":196,"_17":197,"_51":109,"_53":198,"_55":56,"_57":-5,"_84":199,"_18":200},{"_35":185,"_13":186,"_38":187,"_40":123,"_42":43,"_44":124,"_46":47,"_48":188,"_17":65,"_51":109,"_53":189,"_55":56,"_57":-5,"_84":190,"_18":191},{"_35":178,"_13":179,"_38":180,"_40":123,"_42":43,"_44":157,"_46":47,"_48":181,"_17":143,"_51":109,"_53":182,"_55":56,"_57":-5,"_84":183,"_18":184},{"_35":169,"_13":170,"_38":171,"_40":123,"_42":43,"_44":172,"_46":47,"_48":173,"_17":174,"_51":109,"_53":175,"_55":56,"_57":-5,"_84":176,"_18":177},{"_35":162,"_13":163,"_38":164,"_40":123,"_42":43,"_44":124,"_46":47,"_48":165,"_17":65,"_51":109,"_53":166,"_55":56,"_57":-5,"_84":167,"_18":168},{"_35":154,"_13":155,"_38":156,"_40":123,"_42":43,"_44":157,"_46":47,"_48":158,"_17":143,"_51":109,"_53":159,"_55":56,"_57":-5,"_84":160,"_18":161},{"_35":147,"_13":148,"_38":149,"_40":123,"_42":43,"_44":124,"_46":47,"_48":150,"_17":65,"_51":109,"_53":151,"_55":56,"_57":-5,"_84":152,"_18":153},{"_35":138,"_13":139,"_38":140,"_40":123,"_42":43,"_44":141,"_46":47,"_48":142,"_17":143,"_51":109,"_53":144,"_55":56,"_57":-5,"_84":145,"_18":146},"5bbd9ef2-1607-11f0-a798-569c3dd06744","Topics.action.ts","f8ffd5be-1593-11f0-9dd6-569c3dd06744",104,["D",1744288130811],1,"import { ActionFunctionArgs, redirect } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { createTopic } from \"../backend/database/queries.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n const formData = await request.formData();\n const title = formData.get(\"title\") as string;\n\n if (!title || title.trim() === \"\") {\n throw new Response(\"Title is required\", { status: 400 });\n }\n\n const topic = await createTopic(title);\n return redirect(`/topics/${topic.id}`);\n}",[],[122,139],"f8ffd104-1593-11f0-9dd6-569c3dd06744","TopicMessage.loader.ts","f8ffd1a4-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getTopicById, getMessageById, getMessagesByTopicId } from \"../backend/database/queries.ts\";\n\nexport async function loader({ params }: LoaderFunctionArgs) {\n const topicId = parseInt(params.topicId!, 10);\n const messageId = parseInt(params.messageId!, 10);\n\n const topic = await getTopicById(topicId);\n if (!topic) {\n throw new Response(\"Topic not found\", { status: 404 });\n }\n\n const message = await getMessageById(messageId);\n if (!message || message.topicId !== topicId) {\n throw new Response(\"Message not found\", { status: 404 });\n }\n\n const messages = await getMessagesByTopicId(topicId);\n return { topic, messages };\n}",[],[122,148],"56d97c60-163b-11f0-bf5f-569c3dd06744","Topic.tsx","f8ffcdf8-1593-11f0-9dd6-569c3dd06744",132,["D",1744310456433],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData, useParams } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { Message, Topic } from \"../shared/types.ts\";\nimport { MessageForm } from \"../frontend/components/MessageForm.tsx\";\nimport { MessageList } from \"../frontend/components/MessageList.tsx\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\n\ninterface TopicDetailData {\n topic: Topic;\n messages: Message[];\n}\n\nexport function Topic() {\n const { topic, messages } = useLoaderData() as TopicDetailData;\n const { messageId } = useParams();\n const highlightedMessageId = messageId ? parseInt(messageId, 10) : undefined;\n \n // Scroll to highlighted message if messageId is provided\n useEffect(() => {\n if (highlightedMessageId) {\n const messageElement = document.getElementById(`message-${highlightedMessageId}`);\n if (messageElement) {\n messageElement.scrollIntoView({ behavior: \"smooth\", block: \"center\" });\n }\n }\n }, [highlightedMessageId]);\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

{topic.title}

\n Created {new Date(topic.createdAt).toDateString()}\n

\n \n

Messages

\n \n \n \n \n

\n );\n}",[],[122,155],"f8ffcace-1593-11f0-9dd6-569c3dd06744","Topic.loader.ts","f8ffcb78-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getTopicById, getMessagesByTopicId } from \"../backend/database/queries.ts\";\n\nexport async function loader({ params }: LoaderFunctionArgs) {\n const topicId = parseInt(params.topicId!, 10);\n const topic = await getTopicById(topicId);\n\n if (!topic) {\n throw new Response(\"Topic not found\", { status: 404 });\n }\n\n const messages = await getMessagesByTopicId(topicId);\n return { topic, messages };\n}",[],[122,163],"5136c04e-1607-11f0-ab9a-569c3dd06744","Topic.action.ts","f8ffc948-1593-11f0-9dd6-569c3dd06744",103,["D",1744288113149],6,"import { ActionFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { createMessage } from \"../backend/database/queries.ts\";\n\nexport async function action({ request }: ActionFunctionArgs) {\n console.log(\"HERE!\");\n const formData = await request.formData();\n const topicId = parseInt(formData.get(\"topicId\") as string, 10);\n const content = formData.get(\"content\") as string;\n\n if (!content || content.trim() === \"\") {\n throw new Response(\"Content is required\", { status: 400 });\n }\n\n const message = await createMessage(topicId, content);\n return message;\n}",[],[122,170],"56d99d76-163b-11f0-bf5f-569c3dd06744","Search.tsx","f8ffc506-1593-11f0-9dd6-569c3dd06744",["D",1744310456433],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { SearchResults as SearchResultsType } from \"../shared/types.ts\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\n\nexport function Search() {\n const { topics, messages, query } = useLoaderData() as SearchResultsType;\n const hasResults = topics.length > 0 || messages.length > 0;\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

\n Search Results for \"{query}\"\n

\n \n {!hasResults ? (\n

\n No results found for \"{query}\". Try a different search term.\n

\n ) : (\n

\n {topics.length > 0 && (\n

Topics ({topics.length})

\n {topics.map((topic) => (\n

\n \n {topic.title}\n \n

\n Created {new Date(topic.createdAt).toDateString()}\n

\n ))}\n

\n )}\n \n {messages.length > 0 && (\n

Messages ({messages.length})

\n {messages.map((message) => (\n

{message.content}

\n \n View in topic\n \n \n {new Date(message.createdAt).toDateString()}\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[122,179],"f8ffc20e-1593-11f0-9dd6-569c3dd06744","Search.loader.ts","f8ffc2cc-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { search } from \"../backend/database/queries.ts\";\n\nexport async function loader({ request }: LoaderFunctionArgs) {\n const url = new URL(request.url);\n const query = url.searchParams.get(\"q\") || \"\";\n\n if (!query || query.trim() === \"\") {\n return { topics: [], messages: [], query: \"\" };\n }\n\n return await search(query);\n}",[],[122,186],"3d47a160-163f-11f0-809e-569c3dd06744","Home.tsx","f8ffb6d8-1593-11f0-9dd6-569c3dd06744",150,["D",1744312131524],5,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Form,\n Link,\n useLoaderData,\n useNavigation,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { SearchForm } from \"../frontend/components/SearchForm.tsx\";\nimport { Topic } from \"../shared/types.ts\";\n\ninterface TopicListProps {\n topics: Topic[];\n}\n\nexport function Home() {\n const navigation = useNavigation();\n const { topics } = useLoaderData();\n const isCreatingTopic = navigation.formAction === \"/\" && navigation.state === \"submitting\";\n let $form = React.useRef(null);\n\n // reset the form on success\n React.useEffect(function() {\n if (navigation.state === \"idle\" && $form.current) {\n $form.current.reset();\n }\n }, [navigation.state]);\n\n return (\n

Community Message Board

\n \n Home\n \n

\n\n \n\n

Create a New Topic

\n \n

\n\n

Topics

\n\n {topics.length === 0\n ? (\n

\n No topics yet. Create the first one!\n

\n )\n : (\n

\n {topics.map((topic) => (\n

\n \n {topic.title}\n \n

\n Created {new Date(topic.createdAt).toDateString()}\n

\n ))}\n

\n )}\n

\n );\n}",[],[122,193],"f8ffb372-1593-11f0-9dd6-569c3dd06744","Home.loader.ts","f8ffb44e-1593-11f0-9dd6-569c3dd06744",["D",1744238573020],"import { LoaderFunctionArgs } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { getAllTopics } from \"../backend/database/queries.ts\";\n\nexport async function loader() {\n return { topics: await getAllTopics() };\n}",[],[122,202],"9c168580-0f86-11f1-858f-42dde27851f2","App.tsx","f8ff993c-1593-11f0-9dd6-569c3dd06744",177,["D",1771720624387],4,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Outlet, useNavigation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"../frontend/components/LoadingSpinner.tsx\";\n\nexport function App() {\n const navigation = useNavigation();\n const isLoading = navigation.state === \"loading\";\n return (\n

\n \n

\n\n \n

\n );\n}",[],[122,209],"65bd0400-14cd-11f0-9e26-569c3dd06744","frontend","25ba79aa-990f-468a-a9a9-3feab00a24d6",["D",1744153285607],[223,224,225],[218],{"_35":241,"_13":242,"_38":243,"_40":219,"_42":43,"_44":174,"_46":47,"_48":244,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":245,"_18":246},{"_35":233,"_13":234,"_38":235,"_40":219,"_42":43,"_44":236,"_46":47,"_48":237,"_17":99,"_51":24,"_53":238,"_55":56,"_57":-5,"_84":239,"_18":240},{"_35":226,"_13":227,"_38":228,"_40":219,"_42":43,"_44":45,"_46":47,"_48":229,"_17":197,"_51":109,"_53":230,"_55":56,"_57":-5,"_84":231,"_18":232},"b51b0576-0f84-11f1-b328-42dde27851f2","index.tsx","95142d28-14cd-11f0-b4b7-569c3dd06744",["D",1771719807352],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { hydrateRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport {\n createBrowserRouter,\n redirect,\n RouterProvider,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { routes } from \"../shared/routes.ts\";\n\n// Create a browser router with dataStrategy for single-fetch\nconst router = createBrowserRouter(\n routes,\n {\n // @ts-ignore - The window.__staticRouterHydrationData is added by the server\n hydrationData: window.__staticRouterHydrationData,\n\n async dataStrategy({ request, matches }) {\n // Filter to matches that need their handler called\n const matchesToLoad = matches.filter(m => m.shouldLoad);\n\n // If no matches need loading, return empty results\n if (matchesToLoad.length === 0) {\n return {};\n }\n\n console.log(\"[dataStrategy] fetching:\", request.url, \"method:\", request.method);\n console.log(\"[dataStrategy] matchesToLoad:\", matchesToLoad.map(m => m.route.id));\n\n const fetchInit: RequestInit = {\n method: request.method,\n headers: {\n \"X-Data-Request\": \"true\",\n },\n signal: request.signal,\n };\n\n // For non-GET requests (actions), forward the body\n if (request.method !== \"GET\") {\n fetchInit.body = await request.formData();\n }\n\n const res = await fetch(request.url, fetchInit);\n const json = await res.json();\n\n console.log(\"[dataStrategy] response keys:\", Object.keys(json));\n\n // Handle redirects from actions\n // The server sends { redirect: \"/path\" } instead of a 302\n // Return the redirect Response as a DataStrategyResult for the action route.\n // React Router unwraps Response results — a 302 triggers client-side navigation.\n if (json.redirect) {\n console.log(\"[dataStrategy] redirect to:\", json.redirect);\n const results: Record = {};\n for (const match of matchesToLoad) {\n results[match.route.id] = {\n type: \"data\",\n result: redirect(json.redirect),\n };\n }\n return results;\n }\n\n // Build results keyed by route ID\n // dataStrategy must return Record\n const results: Record = {};\n for (const match of matchesToLoad) {\n const routeId = match.route.id;\n // For actions, prefer actionData; for loaders, use loaderData\n if (json.actionData && json.actionData[routeId] !== undefined && json.actionData[routeId] !== null) {\n results[routeId] = { type: \"data\", result: json.actionData[routeId] };\n } else if (json.loaderData && json.loaderData[routeId] !== undefined) {\n results[routeId] = { type: \"data\", result: json.loaderData[routeId] };\n }\n }\n\n console.log(\"[dataStrategy] returning results for routes:\", Object.keys(results));\n return results;\n },\n },\n);\n\n// Hydrate the app\nhydrateRoot(\n document.getElementById(\"root\")!,\n \n \n ,\n);",[],[218,227],"4cc3ba60-14d3-11f0-abe2-569c3dd06744","index.html","65bcfe06-14cd-11f0-9e26-569c3dd06744",62,["D",1744155820694],"\n\n \n \n \n Community Message Board\n \n \n \n \n \n

\n \n \n",[],[218,234],"68b50b94-14cd-11f0-98df-569c3dd06744","components","dea96277-3d90-41f7-8b34-da954ceef6fc",["D",1744153290594],[247,248,249,250,251,252],[218,242],{"_35":292,"_13":209,"_38":293,"_40":243,"_42":43,"_44":294,"_46":47,"_48":295,"_17":296,"_51":109,"_53":297,"_55":56,"_57":-5,"_84":298,"_18":299},{"_35":285,"_13":286,"_38":287,"_40":243,"_42":43,"_44":263,"_46":47,"_48":288,"_17":143,"_51":109,"_53":289,"_55":56,"_57":-5,"_84":290,"_18":291},{"_35":276,"_13":277,"_38":278,"_40":243,"_42":43,"_44":279,"_46":47,"_48":280,"_17":281,"_51":109,"_53":282,"_55":56,"_57":-5,"_84":283,"_18":284},{"_35":268,"_13":269,"_38":270,"_40":243,"_42":43,"_44":271,"_46":47,"_48":272,"_17":63,"_51":109,"_53":273,"_55":56,"_57":-5,"_84":274,"_18":275},{"_35":260,"_13":261,"_38":262,"_40":243,"_42":43,"_44":263,"_46":47,"_48":264,"_17":99,"_51":109,"_53":265,"_55":56,"_57":-5,"_84":266,"_18":267},{"_35":253,"_13":254,"_38":255,"_40":243,"_42":43,"_44":157,"_46":47,"_48":256,"_17":63,"_51":109,"_53":257,"_55":56,"_57":-5,"_84":258,"_18":259},"56d9a406-163b-11f0-bf5f-569c3dd06744","SearchResults.tsx","90a036c4-14cd-11f0-8b75-569c3dd06744",["D",1744310456433],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Link, useLoaderData } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { SearchResults as SearchResultsType } from \"../../shared/types.ts\";\nimport { SearchForm } from \"./SearchForm.tsx\";\n\nexport function SearchResults() {\n const { topics, messages, query } = useLoaderData() as SearchResultsType;\n const hasResults = topics.length > 0 || messages.length > 0;\n \n return (\n

Community Message Board

\n \n Home\n \n

\n \n \n \n

\n Search Results for \"{query}\"\n

\n \n {!hasResults ? (\n

\n No results found for \"{query}\". Try a different search term.\n

\n ) : (\n

\n {topics.length > 0 && (\n

Topics ({topics.length})

\n {topics.map((topic) => (\n

\n \n {topic.title}\n \n

\n Created {new Date(topic.createdAt).toDateString()}\n

\n ))}\n

\n )}\n \n {messages.length > 0 && (\n

Messages ({messages.length})

\n {messages.map((message) => (\n

{message.content}

\n \n View in topic\n \n \n {new Date(message.createdAt).toDateString()}\n \n

\n ))}\n

\n )}\n

\n );\n}",[],[218,242,254],"eefdb18c-14d3-11f0-b7c3-569c3dd06744","SearchForm.tsx","7700eaba-14cd-11f0-82fd-569c3dd06744",68,["D",1744156092862],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Form, useNavigation, useSearchParams } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\nexport function SearchForm() {\n const navigation = useNavigation();\n const [searchParams] = useSearchParams();\n const query = searchParams.get(\"q\") || \"\";\n const isSearching = navigation.state === \"loading\" && navigation.location.pathname === \"/search\";\n \n return (\n \n );\n}",[],[218,242,261],"3fb3a7c2-163b-11f0-a98e-569c3dd06744","MessageList.tsx","722f6066-14cd-11f0-83b3-569c3dd06744",130,["D",1744310417601],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Link, useLocation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { Message } from \"../../shared/types.ts\";\n\ninterface MessageListProps {\n messages: Message[];\n topicId: number;\n highlightedMessageId?: number;\n}\n\nexport function MessageList({ messages, topicId, highlightedMessageId }: MessageListProps) {\n const location = useLocation();\n\n if (messages.length === 0) {\n return (\n

\n No messages yet. Be the first to post!\n

\n );\n }\n\n return (\n

\n {messages.map((message) => {\n const isHighlighted = message.id === highlightedMessageId;\n const formattedDate = new Date(message.createdAt).toDateString();\n const messageUrl = `/topics/${topicId}/messages/${message.id}`;\n\n return (\n \n

{message.content}

\n \n {formattedDate}\n \n

\n );\n })}\n \n );\n}",[],[218,242,269],"8e3adbcc-163b-11f0-a02e-569c3dd06744","MessageForm.tsx","6d98d532-14cd-11f0-9771-569c3dd06744",135,["D",1744310549349],8,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n Form,\n useActionData,\n useNavigation,\n} from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\ninterface MessageFormProps {\n topicId: number;\n}\n\nexport function MessageForm({ topicId }: MessageFormProps) {\n const navigation = useNavigation();\n const isSubmitting = navigation.state === \"submitting\";\n let $form = React.useRef(null);\n\n // reset the form on success\n React.useEffect(function() {\n if (navigation.state === \"idle\" && $form.current) {\n $form.current.reset();\n }\n }, [navigation.state]);\n\n return (\n

Post a Message

\n \n

\n );\n}",[],[218,242,277],"eefdb72c-14d3-11f0-b7c3-569c3dd06744","LoadingSpinner.tsx","68b504be-14cd-11f0-98df-569c3dd06744",["D",1744156092862],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\ninterface LoadingSpinnerProps {\n size?: \"small\" | \"medium\" | \"large\";\n}\n\nexport function LoadingSpinner({ size = \"medium\" }: LoadingSpinnerProps) {\n const sizeClasses = {\n small: \"w-4 h-4 border-2\",\n medium: \"w-8 h-8 border-3\",\n large: \"w-12 h-12 border-4\"\n };\n\n return (\n

\n );\n}",[],[218,242,286],"1368ebb8-14d4-11f0-b4aa-569c3dd06744","892aec86-14cd-11f0-897e-569c3dd06744",71,["D",1744156153964],10,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Outlet, useNavigation } from \"https://esm.sh/react-router@7.5.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { LoadingSpinner } from \"./LoadingSpinner.tsx\";\n\nexport function App() {\n const navigation = useNavigation();\n const isLoading = navigation.state === \"loading\";\n return (\n

\n {isLoading && (\n

\n \n

\n )}\n\n \n\n \n

\n );\n}",[],[218,242,209],["D",1744153267418],[303,304],[19],{"_35":60,"_13":61,"_38":62,"_40":41,"_42":43,"_44":63,"_46":47,"_48":308,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":309,"_18":310},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":305,"_17":50,"_51":52,"_53":54,"_55":56,"_57":58,"_84":306,"_18":307},["D",1771719807352],[],[19,37],["D",1744153267418],[311,312],[19,61],{"_35":320,"_13":321,"_38":322,"_40":62,"_42":43,"_44":90,"_46":47,"_48":323,"_17":63,"_51":109,"_53":324,"_55":56,"_57":-5,"_84":325,"_18":326},{"_35":313,"_13":314,"_38":315,"_40":62,"_42":43,"_44":90,"_46":47,"_48":316,"_17":197,"_51":109,"_53":317,"_55":56,"_57":-5,"_84":318,"_18":319},"b26e6cda-0fe5-11f1-bc51-42dde27851f2","queries.ts","6229805c-14cd-11f0-800b-569c3dd06744",["D",1771761464050],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Message, SearchResults, Topic } from \"../../shared/types.ts\";\nimport { MESSAGES_TABLE, TOPICS_TABLE } from \"./migrations.ts\";\n\n/**\n * Get all topics ordered by creation date (newest first)\n */\nexport async function getAllTopics(): Promise {\n const result = await sqlite.execute(`\n SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n ORDER BY createdAt DESC\n `);\n return result.rows as Topic[];\n}\n\n/**\n * Get a single topic by ID\n */\nexport async function getTopicById(id: number): Promise {\n const result = await sqlite.execute({\n sql: `\n SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n WHERE id = ?\n `,\n args: [id],\n });\n\n return result.rows.length > 0 ? (result.rows[0] as Topic) : null;\n}\n\n/**\n * Create a new topic\n */\nexport async function createTopic(title: string): Promise {\n const createdAt = new Date().toISOString();\n\n const result = await sqlite.execute({\n sql: `\n INSERT INTO ${TOPICS_TABLE} (title, createdAt)\n VALUES (?, ?)\n RETURNING id, title, createdAt\n `,\n args: [title, createdAt],\n });\n\n return result.rows[0] as Topic;\n}\n\n/**\n * Get all messages for a topic\n */\nexport async function getMessagesByTopicId(topicId: number): Promise {\n const result = await sqlite.execute({\n sql: `\n SELECT id, topicId, content, createdAt \n FROM ${MESSAGES_TABLE} \n WHERE topicId = ? \n ORDER BY createdAt ASC\n `,\n args: [topicId],\n });\n\n return result.rows as Message[];\n}\n\n/**\n * Get a single message by ID\n */\nexport async function getMessageById(id: number): Promise {\n const result = await sqlite.execute({\n sql: `\n SELECT id, topicId, content, createdAt \n FROM ${MESSAGES_TABLE} \n WHERE id = ?\n `,\n args: [id],\n });\n\n return result.rows.length > 0 ? (result.rows[0] as Message) : null;\n}\n\n/**\n * Create a new message in a topic\n */\nexport async function createMessage(topicId: number, content: string): Promise {\n const createdAt = new Date().toISOString();\n\n const result = await sqlite.execute({\n sql: `\n INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt)\n VALUES (?, ?, ?)\n RETURNING id, topicId, content, createdAt\n `,\n args: [topicId, content, createdAt],\n });\n\n return result.rows[0] as Message;\n}\n\n/**\n * Search for topics and messages containing the query string\n */\nexport async function search(query: string): Promise {\n // Search in topics\n const topicsResult = await sqlite.execute({\n sql: `\n SELECT id, title, createdAt \n FROM ${TOPICS_TABLE} \n WHERE title LIKE ? \n ORDER BY createdAt DESC\n `,\n args: [`%${query}%`],\n });\n\n // Search in messages\n const messagesResult = await sqlite.execute({\n sql: `\n SELECT m.id, m.topicId, m.content, m.createdAt \n FROM ${MESSAGES_TABLE} m\n JOIN ${TOPICS_TABLE} t ON m.topicId = t.id\n WHERE m.content LIKE ? \n ORDER BY m.createdAt DESC\n `,\n args: [`%${query}%`],\n });\n\n return {\n topics: topicsResult.rows as Topic[],\n messages: messagesResult.rows as Message[],\n query,\n };\n}\n",[],[19,61,314],"b26e7f54-0fe5-11f1-bc51-42dde27851f2","migrations.ts","5ae46b72-14cd-11f0-bbde-569c3dd06744",["D",1771761464050],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Table names with versioning to allow for schema changes\nexport const TOPICS_TABLE = \"message_board_topics_v1\";\nexport const MESSAGES_TABLE = \"message_board_messages_v1\";\n\n/**\n * Initialize the database schema\n */\nexport async function initializeDatabase() {\n // Create topics table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TOPICS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n createdAt TEXT NOT NULL\n )\n `);\n\n // Create messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n topicId INTEGER NOT NULL,\n content TEXT NOT NULL,\n createdAt TEXT NOT NULL,\n FOREIGN KEY (topicId) REFERENCES ${TOPICS_TABLE}(id)\n )\n `);\n\n // Create indexes for faster queries\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_messages_topicId \n ON ${MESSAGES_TABLE} (topicId)\n `);\n\n // Seed initial data if the topics table is empty\n const existingTopics = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TOPICS_TABLE}`);\n \n if (existingTopics.rows[0].count === 0) {\n await seedInitialData();\n }\n}\n\n/**\n * Seed the database with initial data for demonstration\n */\nasync function seedInitialData() {\n const now = new Date().toISOString();\n\n // Insert sample topics using parameterized queries\n await sqlite.batch([\n {\n sql: `INSERT INTO ${TOPICS_TABLE} (title, createdAt) VALUES (?, ?)`,\n args: [\"Welcome to the Message Board\", now],\n },\n {\n sql: `INSERT INTO ${TOPICS_TABLE} (title, createdAt) VALUES (?, ?)`,\n args: [\"Tips and Tricks for Val Town\", now],\n },\n {\n sql: `INSERT INTO ${TOPICS_TABLE} (title, createdAt) VALUES (?, ?)`,\n args: [\"Introduce Yourself\", now],\n },\n ]);\n\n // Get the IDs of the inserted topics\n const topics = await sqlite.execute(`SELECT id FROM ${TOPICS_TABLE} ORDER BY id ASC LIMIT 3`);\n\n // Insert sample messages for each topic\n if (topics.rows.length >= 3) {\n const welcomeTopicId = topics.rows[0].id;\n const tipsTopicId = topics.rows[1].id;\n const introTopicId = topics.rows[2].id;\n\n await sqlite.batch([\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [welcomeTopicId, \"Welcome to our community message board! Feel free to browse around and join the discussions.\", now],\n },\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [welcomeTopicId, \"If you have any questions, just post them here!\", new Date(Date.now() - 3600000).toISOString()],\n },\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [tipsTopicId, \"Val Town makes it easy to build and share serverless functions.\", now],\n },\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [tipsTopicId, \"You can use TypeScript for better type safety in your projects.\", new Date(Date.now() - 7200000).toISOString()],\n },\n {\n sql: `INSERT INTO ${MESSAGES_TABLE} (topicId, content, createdAt) VALUES (?, ?, ?)`,\n args: [introTopicId, \"Hi everyone! I'm the creator of this message board example.\", now],\n },\n ]);\n }\n}\n",[],[19,61,321],"f1a22d8a-14cb-11f0-b108-569c3dd06744",["D",1744152661331],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Full-stack example ReactRouter7 project","imageUrl","userId","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","pinPreview","pinMigrated","screenshotVersion",151,"likeCount","orgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","tursoName","f1a22d8a14cb11f0b108569c3dd06744","tursoHostname","f1a22d8a14cb11f0b108569c3dd06744-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789558275908],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_384":380},"org",{"_11":12,"_378":-5,"_379":380,"_337":338,"_381":382,"_383":56},"branch",{"_17":90,"_13":16,"_35":43,"_370":327,"_371":-5,"_372":-5,"_373":-5,"_374":-5,"_375":-5,"_376":14,"_377":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":327,"_13":14,"_48":512,"_329":-5,"_330":56,"_331":332,"_333":332,"_334":335,"_336":-5,"_337":338,"_339":39,"_340":47,"_341":-5,"_342":343,"_344":63,"_345":346,"_347":348,"_349":350,"_351":513,"_353":-5,"_354":355,"_356":355,"_357":358,"_359":358,"_360":358,"_361":355,"_362":355,"_363":514,"_365":515,"_367":516,"_369":56},[419,424,434,445,448,449],"files",[419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449],"counts",{"_410":143,"_411":197,"_412":63,"_32":413,"_414":415},[406,407],{"_35":68,"_42":43,"_38":41,"_13":19,"_53":-5,"_51":66,"_17":65,"_40":-5,"_48":404,"_44":63,"_57":-5,"_18":405},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1744153267418],[19],{"_35":60,"_13":61,"_38":62,"_40":41,"_42":43,"_44":63,"_46":47,"_48":64,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_18":409},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":58,"_18":408},[19,37],[19,61],"pulls","branches","forks",{"_416":65,"_418":65},"connections",{"_416":65,"_417":65},"count","unfilledCount","emptyCount",{"_35":68,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":63,"_46":47,"_48":300,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":510,"_18":511},{"_35":60,"_13":61,"_38":62,"_40":41,"_42":43,"_44":63,"_46":47,"_48":308,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":508,"_18":509},{"_35":320,"_13":321,"_38":322,"_40":62,"_42":43,"_44":90,"_46":47,"_48":323,"_17":63,"_51":109,"_53":324,"_55":56,"_57":-5,"_84":506,"_18":507},{"_35":313,"_13":314,"_38":315,"_40":62,"_42":43,"_44":90,"_46":47,"_48":316,"_17":197,"_51":109,"_53":317,"_55":56,"_57":-5,"_84":504,"_18":505},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":305,"_17":50,"_51":52,"_53":54,"_55":56,"_57":58,"_84":502,"_18":503},{"_35":217,"_13":218,"_38":219,"_40":-5,"_42":43,"_44":197,"_46":47,"_48":220,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":500,"_18":501},{"_35":241,"_13":242,"_38":243,"_40":219,"_42":43,"_44":174,"_46":47,"_48":244,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":498,"_18":499},{"_35":292,"_13":209,"_38":293,"_40":243,"_42":43,"_44":294,"_46":47,"_48":295,"_17":296,"_51":109,"_53":297,"_55":56,"_57":-5,"_84":496,"_18":497},{"_35":285,"_13":286,"_38":287,"_40":243,"_42":43,"_44":263,"_46":47,"_48":288,"_17":143,"_51":109,"_53":289,"_55":56,"_57":-5,"_84":494,"_18":495},{"_35":276,"_13":277,"_38":278,"_40":243,"_42":43,"_44":279,"_46":47,"_48":280,"_17":281,"_51":109,"_53":282,"_55":56,"_57":-5,"_84":492,"_18":493},{"_35":268,"_13":269,"_38":270,"_40":243,"_42":43,"_44":271,"_46":47,"_48":272,"_17":63,"_51":109,"_53":273,"_55":56,"_57":-5,"_84":490,"_18":491},{"_35":260,"_13":261,"_38":262,"_40":243,"_42":43,"_44":263,"_46":47,"_48":264,"_17":99,"_51":109,"_53":265,"_55":56,"_57":-5,"_84":488,"_18":489},{"_35":253,"_13":254,"_38":255,"_40":243,"_42":43,"_44":157,"_46":47,"_48":256,"_17":63,"_51":109,"_53":257,"_55":56,"_57":-5,"_84":486,"_18":487},{"_35":233,"_13":234,"_38":235,"_40":219,"_42":43,"_44":236,"_46":47,"_48":237,"_17":99,"_51":24,"_53":238,"_55":56,"_57":-5,"_84":484,"_18":485},{"_35":226,"_13":227,"_38":228,"_40":219,"_42":43,"_44":45,"_46":47,"_48":229,"_17":197,"_51":109,"_53":230,"_55":56,"_57":-5,"_84":482,"_18":483},{"_35":121,"_13":122,"_38":123,"_40":-5,"_42":43,"_44":124,"_46":47,"_48":125,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":480,"_18":481},{"_35":208,"_13":209,"_38":210,"_40":123,"_42":43,"_44":211,"_46":47,"_48":212,"_17":213,"_51":109,"_53":214,"_55":56,"_57":-5,"_84":478,"_18":479},{"_35":201,"_13":202,"_38":203,"_40":123,"_42":43,"_44":124,"_46":47,"_48":204,"_17":65,"_51":109,"_53":205,"_55":56,"_57":-5,"_84":476,"_18":477},{"_35":192,"_13":193,"_38":194,"_40":123,"_42":43,"_44":195,"_46":47,"_48":196,"_17":197,"_51":109,"_53":198,"_55":56,"_57":-5,"_84":474,"_18":475},{"_35":185,"_13":186,"_38":187,"_40":123,"_42":43,"_44":124,"_46":47,"_48":188,"_17":65,"_51":109,"_53":189,"_55":56,"_57":-5,"_84":472,"_18":473},{"_35":178,"_13":179,"_38":180,"_40":123,"_42":43,"_44":157,"_46":47,"_48":181,"_17":143,"_51":109,"_53":182,"_55":56,"_57":-5,"_84":470,"_18":471},{"_35":169,"_13":170,"_38":171,"_40":123,"_42":43,"_44":172,"_46":47,"_48":173,"_17":174,"_51":109,"_53":175,"_55":56,"_57":-5,"_84":468,"_18":469},{"_35":162,"_13":163,"_38":164,"_40":123,"_42":43,"_44":124,"_46":47,"_48":165,"_17":65,"_51":109,"_53":166,"_55":56,"_57":-5,"_84":466,"_18":467},{"_35":154,"_13":155,"_38":156,"_40":123,"_42":43,"_44":157,"_46":47,"_48":158,"_17":143,"_51":109,"_53":159,"_55":56,"_57":-5,"_84":464,"_18":465},{"_35":147,"_13":148,"_38":149,"_40":123,"_42":43,"_44":124,"_46":47,"_48":150,"_17":65,"_51":109,"_53":151,"_55":56,"_57":-5,"_84":462,"_18":463},{"_35":138,"_13":139,"_38":140,"_40":123,"_42":43,"_44":141,"_46":47,"_48":142,"_17":143,"_51":109,"_53":144,"_55":56,"_57":-5,"_84":460,"_18":461},{"_35":96,"_13":97,"_38":98,"_40":-5,"_42":43,"_44":99,"_46":47,"_48":100,"_17":65,"_51":66,"_53":-5,"_55":56,"_57":-5,"_84":458,"_18":459},{"_35":113,"_13":114,"_38":115,"_40":98,"_42":43,"_44":45,"_46":47,"_48":116,"_17":117,"_51":109,"_53":118,"_55":56,"_57":-5,"_84":456,"_18":457},{"_35":105,"_13":106,"_38":107,"_40":98,"_42":43,"_44":99,"_46":47,"_48":108,"_17":65,"_51":109,"_53":110,"_55":56,"_57":-5,"_84":454,"_18":455},{"_35":87,"_13":88,"_38":89,"_40":-5,"_42":43,"_44":90,"_46":47,"_48":91,"_17":92,"_51":24,"_53":93,"_55":56,"_57":-5,"_84":452,"_18":453},{"_35":77,"_13":78,"_38":79,"_40":-5,"_42":43,"_44":80,"_46":47,"_48":81,"_17":82,"_51":24,"_53":83,"_55":56,"_57":-5,"_84":450,"_18":451},[],[78],[],[88],[],[97,106],[],[97,114],[446,447],[97],[],[122,139],[],[122,148],[],[122,155],[],[122,163],[],[122,170],[],[122,179],[],[122,186],[],[122,193],[],[122,202],[],[122,209],[435,436,437,438,439,440,441,442,443,444],[122],[],[218,227],[],[218,234],[],[218,242,254],[],[218,242,261],[],[218,242,269],[],[218,242,277],[],[218,242,286],[],[218,242,209],[426,427,428,429,430,431],[218,242],[425,432,433],[218],[],[19,37],[],[19,61,314],[],[19,61,321],[421,422],[19,61],[420,423],[19],["D",1744152661331],["D",1789558275908],{"_11":12,"_384":380},{"_11":12,"_378":-5,"_379":380,"_337":338,"_381":382,"_383":56},{"_17":90,"_13":16,"_35":43,"_370":327,"_371":-5,"_372":-5,"_373":-5,"_374":-5,"_375":-5,"_376":14,"_377":12},"ctx",{"_363":-5,"_401":550,"_551":552,"_553":554,"_555":56,"_556":56,"_557":56,"_558":47,"_559":-5,"_560":-7,"_561":-7,"_562":65,"_563":56,"_564":56,"_565":-5,"_566":56,"_567":56,"_568":56,"_569":-5},"ENV",{"_521":522,"_523":524,"_525":16,"_526":527,"_528":529,"_530":531,"_532":533,"_534":535,"_536":537,"_538":539,"_540":541,"_542":543,"_544":545,"_546":547,"_548":549},"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"]