Val Town Code SearchReturn to Val Town

1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3// Database schema for the health platform
4export async function runMigrations() {
5  console.log("Running database migrations...");
6
7  // Users table
182  `);
183
184  console.log("Database migrations completed successfully!");
185}
186

6  getAppointmentById,
7  updateAppointmentStatus
8} from "../database/queries.ts";
9
10const appointments = new Hono();

8  getBMIHistoryByUser,
9  getDashboardData
10} from "../database/queries.ts";
11
12const health = new Hono();

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.

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { runMigrations } from "./database/migrations.ts";
3import boardsRouter from "./routes/boards.ts";
4import staticRouter from "./routes/static.ts";
11});
12
13// Initialize database
14await runMigrations();
15

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils/index.ts";
3import * as db from "../database/queries.ts";
4
5const app = new Hono();

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import * as db from "../database/queries.ts";
3import type { 
4  CreateColumnRequest, 

15```
16├── backend/
17│   ├── database/
18│   │   ├── migrations.ts    # Database schema setup
19│   │   └── queries.ts       # Database query functions
20│   ├── routes/
21│   │   ├── boards.ts        # Board management endpoints
51## Getting Started
52
531. The backend will automatically create the necessary database tables on startup
542. Navigate to the root URL to access the kanban board interface
553. Create columns and start adding items to organize your work

19  - **Temporary Sessions (Default)**: No data saved anywhere - maximum privacy
20  - **Local Storage**: Sessions saved only in your browser - private and secure
21  - **Server Storage**: Full AI analysis with persistent sessions saved to database
22- **Data Management**: Clear saved data with one click
23  - Delete individual sessions
55│   │   ├── power-abuse-analyzer.ts # Text analysis API
56│   │   └── static-file-server.ts # Static file server
57│   ├── database/           # Database operations
58│   │   └── index.ts        # SQLite database operations
59│   ├── utils/              # Utility functions
60│   │   ├── error-handler.ts # Error handling and response formatting
65│   ├── analyzer.test.ts    # Tests for text analysis
66│   ├── chat-api.test.ts    # Tests for chat API
67│   ├── database.test.ts    # Tests for database operations
68│   └── README.md           # Test documentation
69├── frontend/               # Frontend files
73```
74
75## Database Schema
76
77The application uses SQLite with the following tables:
82- **Examples**: Stores examples of patterns, including user-provided examples
83
84The database uses recursive common table expressions (CTEs) to handle threaded conversations about specific patterns.
85
86## Usage
99   - **🔒 Temporary (Default)**: No data saved anywhere - maximum privacy
100   - **💾 Local Storage**: Sessions saved only in your browser - private and secure  
101   - **☁️ Server Storage**: Full AI-powered analysis with sessions saved to the database
1024. Create a new analysis session
1035. Enter text to analyze or ask a question about power abuse patterns
117- **💾 Local Storage**: Sessions are saved only in your browser's local storage. This provides privacy as data never leaves your device, but with limited analysis capabilities (no AI processing). Sessions are only available on the device where they were created.
118
119- **☁️ Server Storage**: Sessions are saved to the SQLite database on the server. This provides full AI-powered analysis using Cerebras Qwen-3 32B model, persistent sessions that can be accessed from any device, and complete pattern recognition capabilities.
120
121## Prompts Used

1import * as db from "../database/index.ts";
2import { analyzeText } from "../analyzer/index.ts";
3import { handlePatternFollowUp } from "../analyzer/index.ts";
8const log = logger.createLogger('API:ChatAPI');
9
10// Initialize database
11await db.initDatabase();
12
13// Types for our API
58    const analysisResult = await analyzeText(message);
59    
60    // Store identified patterns in the database
61    const messageId = await db.addMessage(session_id, message, "user", parent_id);
62    const storedPatterns: db.Pattern[] = [];