208```
209โโโ backend/
210โ โโโ database/
211โ โ โโโ migrations.ts # Schema definitions
212โ โ โโโ queries.ts # DB query functions
270- Handle API calls properly with proper error catching
271
272### Database Patterns
273- Run migrations on startup or comment out for performance
274- Change table names when modifying schemas rather than altering
1import { generateCode } from "./backend/generate-code";
2import { createTables } from "./database/migrations";
3import { createProject, getCode, getNextVersionNumber, insertVersion } from "./database/queries";
4
5async function servePublicFile(path: string): Promise<Response> {
34
35/**
36 * Store a chat message in the database
37 */
38export async function storeChatMessage(
6const TABLE_NAME = `${KEY}_summaries_v4`;
7
8async function initDatabase() {
9 await sqlite.execute(`
10 CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
63 }
64
65 await initDatabase();
66
67 const { description, long = false } = await req.json();
9- The **client-side entrypoint** is `/frontend/index.html`, which in turn imports `/frontend/index.tsx`, which in turn imports the React app from `/frontend/components/App.tsx`.
10
11[React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a fuller featured example project, with a SQLite database table, queries, client-side CSS and a favicon, and some shared code that runs on both client and server.
1/**
2 * Database constants used throughout the application
3 */
4
374];
375
376// Insert memories into the database
377async function insertDemoMemories() {
378 try {
415 await insertDemoMemories();
416
417 console.log("Demo database successfully populated!");
418 return "Demo database successfully populated!";
419 } catch (error) {
420 console.error("Error populating demo database:", error);
421 throw error;
422 }
1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2import { type Memory } from "../../shared/types.ts";
3import { MEMORIES_TABLE } from "../../shared/databaseConstants.ts";
4
5// Using the centralized table name constant
1import { DateTime } from "https://esm.sh/luxon@3.4.4";
2import { MEMORIES_TABLE } from "./shared/databaseConstants.ts";
3
4/**
5 * Retrieves all memories from the database
6 * @param includeDate Whether to include date-specific memories or not
7 * @param startDate Optional start date to filter memories from (ISO format)
1// Script to set up the telegram_chats table in SQLite
2// Run this script manually to create the database table
3
4export default async function setupTelegramChatDb() {
25 `);
26
27 return "Telegram chat database table created successfully.";
28 } catch (error) {
29 console.error("Error setting up telegram_chats table:", error);