43 `);
44
45 console.log("Casino database migrations completed");
46}
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getCookie, setCookie } from "https://esm.sh/hono@3.11.7/cookie";
3import * as db from "../database/queries.ts";
4import { VEHICLE_CONFIGS, ENEMY_TYPES, VehicleType } from "../../shared/types.ts";
5
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import type { ChatMessage, ChatOption, UserProgress, BudgetBreakdown } from "../../shared/types.ts";
3import { getUserProgress, saveUserProgress, getVendorsByCategory, getTimelineTasks } from "../database/queries.ts";
4
5const chat = new Hono();
1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { readFile, serveFile } from "https://esm.town/v/std/utils@85-main/index.ts";
3import { runMigrations } from "./database/migrations.ts";
4import chat from "./routes/chat.ts";
5
11});
12
13// Initialize database
14await runMigrations();
15
16```
17โโโ backend/
18โ โโโ database/
19โ โ โโโ migrations.ts # Database schema
20โ โ โโโ queries.ts # Database operations
21โ โโโ routes/
22โ โ โโโ chat.ts # Chat API endpoints
38
39The application runs on Val Town with:
40- Backend: Hono framework with SQLite database
41- Frontend: React with TailwindCSS
42- Real-time chat interface for wedding planning assistance
68/backend/ingestion/eventIngestion.ts
69/backend/processing/streamProcessor.ts
70/backend/storage/database.ts
71/backend/monitoring/metricsCollector.ts
72/backend/monitoring/healthChecker.ts
272NODE_ENV=production
273
274# Database Configuration
275DATABASE_URL=sqlite:./data/events.db
276DATABASE_POOL_SIZE=10
277
278# Monitoring Configuration
299 "host": "0.0.0.0"
300 },
301 "database": {
302 "type": "sqlite",
303 "path": "./data/events.db",
318## Performance Tuning
319
320### Database Optimization
321
322```sql
429## Backup and Recovery
430
431### Database Backup
432
433```bash
458
4592. **High Latency**
460 - Check database query performance
461 - Monitor network connectivity
462 - Review processing instance load
113
114**Components**:
115- **Time-Series Database**: Event storage with time-based partitioning
116- **Metrics Store**: Performance and health metrics
117- **Cache Layer**: Hot data and query result caching
1642. **Validation**: Schema validation and sanitization
1653. **Enrichment**: ID generation, timestamp assignment, partition key
1664. **Storage**: Persistent storage in time-series database
1675. **Processing**: Real-time processing and aggregation
1686. **Monitoring**: Metrics collection and health checks
174
175- **Processing Instances**: Auto-scale from 1 to 100+ instances
176- **Database Sharding**: Partition data across multiple nodes
177- **Load Balancing**: Distribute load across available instances
178- **Cache Distribution**: Distributed caching for hot data
207- **Target**: 1M+ events/second
208- **Achieved**: Scales linearly with instances
209- **Bottlenecks**: Database write capacity, network bandwidth
210- **Optimization**: Batching, compression, connection pooling
211
246- **Runtime**: Deno with TypeScript
247- **Web Framework**: Hono for HTTP handling
248- **Database**: SQLite with time-series optimization
249- **WebSockets**: Native Deno WebSocket support
250
95.deno/
96
97# Database files
98*.db
99*.sqlite
298
299 try {
300 // Test database connectivity by attempting a simple query
301 const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite");
302 await sqlite.execute("SELECT 1");
1import { MetricsStorage, Metric } from "../storage/database.ts";
2
3export interface SystemMetrics {