[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_444":445,"_446":447},"routes/_app.x.$handle.$name",{"_118":117,"_34":63,"_126":108,"_29":127,"_13":14,"_128":-5,"_11":129,"_130":131,"_132":133,"_134":135,"_136":137,"_22":-5,"_138":-5,"_139":-5,"_140":27,"_141":142,"_143":77,"_144":-5,"_145":-5,"_146":147},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_61":62,"_34":63,"_41":64,"_65":-5,"_66":27,"_67":68,"_69":68,"_70":71,"_72":-5,"_18":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":82,"_83":84,"_85":86,"_87":88,"_89":90,"_91":-5,"_92":93,"_94":93,"_95":96,"_97":96,"_98":96,"_99":93,"_100":93,"_101":102,"_103":104,"_105":106,"_107":27},"version",178,"changes",[19,20,21],"aiChatInfo","userId",{"_22":54,"_24":55,"_26":27,"_28":27,"_29":56,"_31":56},{"_22":46,"_24":47,"_26":27,"_28":27,"_29":48,"_31":48},{"_22":23,"_24":25,"_26":27,"_28":27,"_29":30,"_31":30},"file",{"_32":33,"_34":35,"_36":37,"_38":40,"_41":42,"_43":14,"_44":45,"_26":27},"previous",{"_32":33,"_34":35,"_36":37,"_38":39},"deleted",false,"deletedHere","path","backend/database/queries.ts","latestPath","fileId","6229805c-14cd-11f0-800b-569c3dd06744","name","queries.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite@14-main/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","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","createdAt",["D",1771761464050],"branchVersion","branchId","f1a26f20-14cb-11f0-b108-569c3dd06744",{"_32":49,"_34":50,"_36":37,"_38":52,"_41":53,"_43":14,"_44":45,"_26":27},{"_32":49,"_34":50,"_36":37,"_38":51},"backend/database/migrations.ts","5ae46b72-14cd-11f0-bbde-569c3dd06744","migrations.ts","import { sqlite } from \"https://esm.town/v/std/sqlite@14-main/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","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",["D",1771761464050],{"_32":57,"_34":56,"_36":22,"_38":59,"_41":60,"_43":14,"_44":45,"_26":27},{"_32":57,"_34":56,"_36":22,"_38":58},"README.md","513e59ca-14cd-11f0-8f60-569c3dd06744","# 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@14-main` |\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@14-main` (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@14-main` (Val Town project-scoped SQLite)\n","# 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",["D",1771761464050],"id","f1a22d8a-14cb-11f0-b108-569c3dd06744","reactRouter7Example",["D",1744152661331],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Full-stack example ReactRouter7 project","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","e315d710-14cd-11f0-a969-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion",151,"likeCount",3,"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",{"_118":117,"_125":121},"org",{"_118":117,"_119":-5,"_120":121,"_18":73,"_122":123,"_124":27},"branch",{"_13":14,"_34":108,"_61":45,"_109":62,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":63,"_116":117},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","stevekrouse","handle","displayName","avatar","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_61":62,"_34":63,"_41":439,"_65":-5,"_66":27,"_67":68,"_69":68,"_70":71,"_72":-5,"_18":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":82,"_83":84,"_85":86,"_87":88,"_89":440,"_91":-5,"_92":93,"_94":93,"_95":96,"_97":96,"_98":96,"_99":93,"_100":93,"_101":441,"_103":442,"_105":443,"_107":27},"tree",[205,210,220,231,234,235],"files",[205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235],"counts",{"_194":195,"_196":186,"_197":82,"_198":199,"_200":201},"contents",[148,149,150,151,152,153],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_61":189,"_34":190,"_32":191,"_157":-5,"_44":45,"_43":82,"_159":77,"_41":192,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_29":193},{"_61":183,"_34":184,"_32":185,"_157":-5,"_44":45,"_43":186,"_159":77,"_41":187,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_29":188},{"_61":177,"_34":178,"_32":179,"_157":-5,"_44":45,"_43":180,"_159":77,"_41":181,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_29":182},{"_61":169,"_34":170,"_32":171,"_157":-5,"_44":45,"_43":172,"_159":77,"_41":173,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_29":176},{"_61":165,"_34":56,"_32":57,"_157":-5,"_44":45,"_43":14,"_159":77,"_41":166,"_13":167,"_36":22,"_38":59,"_26":27,"_163":-5,"_29":168},{"_61":154,"_34":155,"_32":156,"_157":-5,"_44":45,"_43":158,"_159":77,"_41":160,"_13":161,"_36":22,"_38":162,"_26":27,"_163":-5,"_29":164},"db92e8f0-163c-11f0-8f3c-569c3dd06744","TODO.md","471f7894-1594-11f0-bc2d-569c3dd06744","parentId",143,"latest",["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?","label",[155],"b26e0ca4-0fe5-11f1-bc51-42dde27851f2",["D",1771761464050],9,[56],"5343c3fe-14cd-11f0-b10b-569c3dd06744","shared","add21c84-9f00-4405-af88-6ec5134089df",2,["D",1744153254621],0,"directory",[170],"f8ffd76c-1593-11f0-9dd6-569c3dd06744","routes","c4795b2d-41e5-4e2d-bb49-1239d72d4d2d",81,["D",1744238573020],[178],"65bd0400-14cd-11f0-9e26-569c3dd06744","frontend","25ba79aa-990f-468a-a9a9-3feab00a24d6",5,["D",1744153285607],[184],"5ae47a2c-14cd-11f0-bbde-569c3dd06744","backend","50aca1db-e744-46f9-883e-ba00e55ffc58",["D",1744153267418],[190],"pulls",1,"branches","forks","envVars",{"_202":174,"_204":174},"connections",{"_202":174,"_203":174},"count","unfilledCount","emptyCount",{"_61":189,"_34":190,"_32":191,"_157":-5,"_44":45,"_43":82,"_159":77,"_41":436,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_237":437,"_29":438},{"_61":432,"_34":427,"_32":423,"_157":191,"_44":45,"_43":82,"_159":77,"_41":433,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_237":434,"_29":435},{"_61":428,"_34":50,"_32":49,"_157":423,"_44":45,"_43":14,"_159":77,"_41":429,"_13":82,"_36":37,"_38":52,"_26":27,"_163":-5,"_237":430,"_29":431},{"_61":422,"_34":35,"_32":33,"_157":423,"_44":45,"_43":14,"_159":77,"_41":424,"_13":186,"_36":37,"_38":40,"_26":27,"_163":-5,"_237":425,"_29":426},{"_61":413,"_34":414,"_32":75,"_157":191,"_44":45,"_43":253,"_159":77,"_41":415,"_13":416,"_36":417,"_38":418,"_26":27,"_163":419,"_237":420,"_29":421},{"_61":183,"_34":184,"_32":185,"_157":-5,"_44":45,"_43":186,"_159":77,"_41":410,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_237":411,"_29":412},{"_61":406,"_34":365,"_32":360,"_157":185,"_44":45,"_43":297,"_159":77,"_41":407,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_237":408,"_29":409},{"_61":398,"_34":331,"_32":399,"_157":360,"_44":45,"_43":400,"_159":77,"_41":401,"_13":402,"_36":37,"_38":403,"_26":27,"_163":-5,"_237":404,"_29":405},{"_61":391,"_34":392,"_32":393,"_157":360,"_44":45,"_43":369,"_159":77,"_41":394,"_13":195,"_36":37,"_38":395,"_26":27,"_163":-5,"_237":396,"_29":397},{"_61":382,"_34":383,"_32":384,"_157":360,"_44":45,"_43":385,"_159":77,"_41":386,"_13":387,"_36":37,"_38":388,"_26":27,"_163":-5,"_237":389,"_29":390},{"_61":374,"_34":375,"_32":376,"_157":360,"_44":45,"_43":377,"_159":77,"_41":378,"_13":82,"_36":37,"_38":379,"_26":27,"_163":-5,"_237":380,"_29":381},{"_61":366,"_34":367,"_32":368,"_157":360,"_44":45,"_43":369,"_159":77,"_41":370,"_13":172,"_36":37,"_38":371,"_26":27,"_163":-5,"_237":372,"_29":373},{"_61":357,"_34":358,"_32":359,"_157":360,"_44":45,"_43":280,"_159":77,"_41":361,"_13":82,"_36":37,"_38":362,"_26":27,"_163":-5,"_237":363,"_29":364},{"_61":349,"_34":350,"_32":351,"_157":185,"_44":45,"_43":352,"_159":77,"_41":353,"_13":172,"_36":22,"_38":354,"_26":27,"_163":-5,"_237":355,"_29":356},{"_61":342,"_34":343,"_32":344,"_157":185,"_44":45,"_43":253,"_159":77,"_41":345,"_13":186,"_36":37,"_38":346,"_26":27,"_163":-5,"_237":347,"_29":348},{"_61":177,"_34":178,"_32":179,"_157":-5,"_44":45,"_43":180,"_159":77,"_41":339,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_237":340,"_29":341},{"_61":330,"_34":331,"_32":332,"_157":179,"_44":45,"_43":333,"_159":77,"_41":334,"_13":335,"_36":37,"_38":336,"_26":27,"_163":-5,"_237":337,"_29":338},{"_61":323,"_34":324,"_32":325,"_157":179,"_44":45,"_43":180,"_159":77,"_41":326,"_13":174,"_36":37,"_38":327,"_26":27,"_163":-5,"_237":328,"_29":329},{"_61":315,"_34":316,"_32":317,"_157":179,"_44":45,"_43":318,"_159":77,"_41":319,"_13":186,"_36":37,"_38":320,"_26":27,"_163":-5,"_237":321,"_29":322},{"_61":308,"_34":309,"_32":310,"_157":179,"_44":45,"_43":180,"_159":77,"_41":311,"_13":174,"_36":37,"_38":312,"_26":27,"_163":-5,"_237":313,"_29":314},{"_61":301,"_34":302,"_32":303,"_157":179,"_44":45,"_43":280,"_159":77,"_41":304,"_13":195,"_36":37,"_38":305,"_26":27,"_163":-5,"_237":306,"_29":307},{"_61":292,"_34":293,"_32":294,"_157":179,"_44":45,"_43":295,"_159":77,"_41":296,"_13":297,"_36":37,"_38":298,"_26":27,"_163":-5,"_237":299,"_29":300},{"_61":285,"_34":286,"_32":287,"_157":179,"_44":45,"_43":180,"_159":77,"_41":288,"_13":174,"_36":37,"_38":289,"_26":27,"_163":-5,"_237":290,"_29":291},{"_61":277,"_34":278,"_32":279,"_157":179,"_44":45,"_43":280,"_159":77,"_41":281,"_13":195,"_36":37,"_38":282,"_26":27,"_163":-5,"_237":283,"_29":284},{"_61":270,"_34":271,"_32":272,"_157":179,"_44":45,"_43":180,"_159":77,"_41":273,"_13":174,"_36":37,"_38":274,"_26":27,"_163":-5,"_237":275,"_29":276},{"_61":262,"_34":263,"_32":264,"_157":179,"_44":45,"_43":265,"_159":77,"_41":266,"_13":195,"_36":37,"_38":267,"_26":27,"_163":-5,"_237":268,"_29":269},{"_61":169,"_34":170,"_32":171,"_157":-5,"_44":45,"_43":172,"_159":77,"_41":259,"_13":174,"_36":175,"_38":-5,"_26":27,"_163":-5,"_237":260,"_29":261},{"_61":250,"_34":251,"_32":252,"_157":171,"_44":45,"_43":253,"_159":77,"_41":254,"_13":255,"_36":37,"_38":256,"_26":27,"_163":-5,"_237":257,"_29":258},{"_61":243,"_34":244,"_32":245,"_157":171,"_44":45,"_43":172,"_159":77,"_41":246,"_13":174,"_36":37,"_38":247,"_26":27,"_163":-5,"_237":248,"_29":249},{"_61":165,"_34":56,"_32":57,"_157":-5,"_44":45,"_43":14,"_159":77,"_41":240,"_13":167,"_36":22,"_38":59,"_26":27,"_163":-5,"_237":241,"_29":242},{"_61":154,"_34":155,"_32":156,"_157":-5,"_44":45,"_43":158,"_159":77,"_41":236,"_13":161,"_36":22,"_38":162,"_26":27,"_163":-5,"_237":238,"_29":239},["D",1744311108608],"children",[],[155],["D",1771761464050],[],[56],"5343bcb0-14cd-11f0-b10b-569c3dd06744","types.ts","5343bd78-14cd-11f0-b10b-569c3dd06744",["D",1744153254621],"/**\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}",[],[170,244],"b51b1732-0f84-11f1-b328-42dde27851f2","routes.ts","7639f8f6-14d2-11f0-97d5-569c3dd06744",167,["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];",[],[170,251],["D",1744153254621],[232,233],[170],"5bbd9ef2-1607-11f0-a798-569c3dd06744","Topics.action.ts","f8ffd5be-1593-11f0-9dd6-569c3dd06744",104,["D",1744288130811],"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}",[],[178,263],"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}",[],[178,271],"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}",[],[178,278],"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}",[],[178,286],"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}",[],[178,293],"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}",[],[178,302],"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}",[],[178,309],"3d47a160-163f-11f0-809e-569c3dd06744","Home.tsx","f8ffb6d8-1593-11f0-9dd6-569c3dd06744",150,["D",1744312131524],"/** @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}",[],[178,316],"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}",[],[178,324],"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}",[],[178,331],["D",1744238573020],[221,222,223,224,225,226,227,228,229,230],[178],"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);",[],[184,343],"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",[],[184,350],"56d9a406-163b-11f0-bf5f-569c3dd06744","SearchResults.tsx","90a036c4-14cd-11f0-8b75-569c3dd06744","dea96277-3d90-41f7-8b34-da954ceef6fc",["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}",[],[184,365,358],"components","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}",[],[184,365,367],"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}",[],[184,365,375],"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}",[],[184,365,383],"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}",[],[184,365,392],"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}",[],[184,365,331],"68b50b94-14cd-11f0-98df-569c3dd06744",["D",1744153290594],[212,213,214,215,216,217],[184,365],["D",1744153285607],[211,218,219],[184],"b51adf74-0f84-11f1-b328-42dde27851f2","index.ts",["D",1771719807352],45,"http","import { Hono } from \"https://esm.sh/hono@4.1.0\";\nimport { renderToString } from \"https://esm.sh/react-dom@18.2.0/server\";\nimport {\n createStaticHandler,\n createStaticRouter,\n StaticRouterProvider,\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 { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { routes } from \"../shared/routes.ts\";\nimport { initializeDatabase } from \"./database/migrations.ts\";\n\n// Initialize the database\nawait initializeDatabase();\n\n// Create the Hono app\nconst app = new Hono();\n\n// Serve static files from the frontend directory\napp.get(\"/frontend/*\", (c) => {\n const path = c.req.path;\n return serveFile(path, import.meta.url);\n});\n\n// Serve static files from the shared directory\napp.get(\"/shared/*\", (c) => {\n const path = c.req.path;\n return serveFile(path, import.meta.url);\n});\n\n// Serve static files from the routes directory\napp.get(\"/routes/*\", (c) => {\n const path = c.req.path;\n return serveFile(path, import.meta.url);\n});\n\n// Create a static handler for server-side rendering\nconst { query, dataRoutes } = createStaticHandler(routes);\n\n// Handle all other routes with React Router\napp.all(\"*\", async (c) => {\n const isDataRequest = c.req.header(\"X-Data-Request\") === \"true\";\n\n // Get the routing context by running loaders/actions\n const context = await query(c.req.raw);\n\n // If the context is a Response (e.g., redirects from actions)\n if (context instanceof Response) {\n if (isDataRequest && context.status >= 300 && context.status < 400) {\n // For data requests, convert redirects to JSON so the client can handle them\n const location = context.headers.get(\"Location\");\n console.log(\"[data-request] redirect to:\", location);\n return Response.json({ redirect: location });\n }\n return context;\n }\n\n // Data-only request: return loaderData/actionData as JSON keyed by route ID\n if (isDataRequest) {\n console.log(\"[data-request] loaderData keys:\", Object.keys(context.loaderData || {}));\n console.log(\"[data-request] actionData keys:\", Object.keys(context.actionData || {}));\n return Response.json({\n loaderData: context.loaderData,\n actionData: context.actionData,\n });\n }\n\n // Full SSR render\n const router = createStaticRouter(dataRoutes, context);\n\n // Read the HTML template\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Render the app to a string\n const appHtml = renderToString(\n React.createElement(StaticRouterProvider, {\n router,\n context,\n }),\n );\n\n // Insert the rendered app and hydration data into the HTML template\n html = html.replace(\n \"

\",\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;","react-router-7-example",[],[190,414],"b26e6cda-0fe5-11f1-bc51-42dde27851f2","4af61b55-4e6e-48ee-bb08-a35baadaf267",["D",1771761464050],[],[190,427,35],"database","b26e7f54-0fe5-11f1-bc51-42dde27851f2",["D",1771761464050],[],[190,427,50],"5ae47cc0-14cd-11f0-bbde-569c3dd06744",["D",1744153267418],[207,208],[190,427],["D",1744153267418],[206,209],[190],["D",1744152661331],["D",1789558275908],{"_118":117,"_125":121},{"_118":117,"_119":-5,"_120":121,"_18":73,"_122":123,"_124":27},{"_13":14,"_34":108,"_61":45,"_109":62,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":63,"_116":117},"ctx",{"_101":-5,"_145":477,"_478":479,"_480":481,"_482":27,"_483":27,"_484":27,"_485":77,"_486":-5,"_487":-7,"_488":-7,"_489":174,"_490":27,"_491":27,"_492":-5,"_493":27,"_494":27,"_495":27,"_496":-5},"ENV",{"_448":449,"_450":451,"_452":108,"_453":454,"_455":456,"_457":458,"_459":460,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472,"_473":474,"_475":476},"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 · v178