Val Town Code SearchReturn to Val Town

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { addGoal, getGoals, updateGoalProgress, deleteGoal, getTravelDestinations } from "../database/queries.ts";
3
4const goals = new Hono();

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { addExpense, getExpenses, getExpensesByMonth, deleteExpense } from "../database/queries.ts";
3import { getMonthYear } from "../../shared/utils.ts";
4

1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3// Database schema for the expense tracker
4export async function runMigrations() {
5  console.log("Running database migrations...");
6
7  // Users table
158  }
159
160  console.log("Database migrations completed!");
161}

33```
34├── backend/
35│   ├── database/
36│   │   ├── migrations.ts    # Database schema
37│   │   └── queries.ts       # Database operations
38│   ├── routes/
39│   │   ├── expenses.ts      # Expense CRUD operations

8- 📝 User registration
9- 🍪 Session management with cookies
10- 💾 SQLite database for user storage
11- 🎨 Beautiful UI with TailwindCSS
12- 📱 Responsive design
41- `GET /api/auth` - Check authentication status
42
43## Database Schema
44
45The app uses SQLite with a simple users table:

11});
12
13// Database setup
14const TABLE_NAME = 'login_users_1';
15
16// Initialize database
17async function initDatabase() {
18  await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
19    id INTEGER PRIMARY KEY AUTOINCREMENT,
34}
35
36// Initialize database on startup
37await initDatabase();
38
39// Serve static files

1import { serveFile } from "https://esm.town/v/std/utils/index.ts";
2import { generateCode } from "./backend/generate-code.ts";
3import { createTables } from "./database/migrations.ts";
4import { createProject, getCode, getNextVersionNumber, insertVersion } from "./database/queries.ts";
5
6await createTables();

21## Further resources
22
23- [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a bigger example project, with a SQLite database table, queries, client-side CSS, a favicon, and shared code that runs on both client and server.

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// Initialize database
14await runMigrations();
15

1import { Hono } from "https://esm.sh/hono@3.11.7";
2import { getAllProducts, getProductById, createTransaction } from "../database/queries.ts";
3import type { PurchaseRequest, PurchaseResponse } from "../../shared/types.ts";
4