Val Town Code SearchReturn to Val Town

15```
16├── backend/
17│   ├── database/
18│   │   ├── migrations.ts    # Database schema setup
19│   │   └── queries.ts       # Database query functions
20│   ├── routes/
21│   │   ├── mood.ts         # Mood tracking endpoints
41- **Backend**: Hono (TypeScript API framework)
42- **Frontend**: React with TypeScript
43- **Database**: SQLite for data persistence
44- **Styling**: TailwindCSS
45- **Charts**: Chart.js for mood visualization

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getChatMessages, createChatMessage } from "../database/queries.ts";
3import type { CreateMessageRequest } from "../../shared/types.ts";
4

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllJobs, createJob } from "../database/queries.ts";
3import type { CreateJobRequest } from "../../shared/types.ts";
4

32  `);
33
34  console.log('Database migrations completed');
35}

13```
14├── backend/
15│   ├── database/
16│   │   ├── migrations.ts    # Database schema setup
17│   │   └── queries.ts       # Database query functions
18│   ├── routes/
19│   │   ├── jobs.ts         # Job posting API routes

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 api from "./routes/api.ts";
5
11});
12
13// Run database migrations on startup
14await runMigrations();
15

6  createReview,
7  getAllCompaniesWithStats
8} from "../database/queries.ts";
9
10const api = new Hono();

33  `);
34
35  console.log('Database migrations completed');
36}
37

14```
15├── backend/
16│   ├── database/
17│   │   ├── migrations.ts    # Database schema setup
18│   │   └── queries.ts       # Database query functions
19│   └── routes/
20│       └── api.ts          # API endpoints
40- `GET /api/companies/{id}` - Get company details
41
42## Database Schema
43
44### Companies Table

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 jobsRouter from "./routes/jobs.ts";
5import chatRouter from "./routes/chat.ts";
12});
13
14// Initialize database on startup
15await runMigrations();
16