1# Database
2
3This directory contains database-related code.
4
5- `queries.ts` - Database operations for the URL shortener
4
5- `index.ts` - Main server entry point
6- `database/` - Database operations and queries
11## Project Structure
12
13- `/backend` - Server-side code and database operations
14- `/frontend` - React components and UI
15- `/shared` - Shared utilities and types
16- [ ] Rebuild as React Router?
17- [ ] opentownie as a pr bot
18- [ ] give it the ability to see its own client-side and server-side logs by building a middleware that shoves them into a SQL light database date and then give it a tool to access them
19- [ ] do a browser use or screenshot thing to give it access to its own visual output
20- [ ] Have it default to creating a new branch off main and then embedding and iframe to the resulting http val and give you a link to a pr opening url
7export const thinkTool = tool({
8 description:
9 "Use the tool to think about something. It will not obtain new information or change the database, but just append the thought to the log. Use it when complex reasoning or some cache memory is needed.",
10 parameters: z.object({
11 thought: z.string().describe("A thought to think about."),
166```
167โโโ backend/
168โ โโโ database/
169โ โ โโโ migrations.ts # Schema definitions
170โ โ โโโ queries.ts # DB query functions
228- Handle API calls properly with proper error catching
229
230### Database Patterns
231- Run migrations on startup or comment out for performance
232- Change table names when modifying schemas rather than altering
30 role: "Contributor",
31 joinDate: "June 10, 2023",
32 bio: "Backend developer with expertise in Node.js and database optimization."
33 }
34};
16}
17
18// Create the database table
19export async function createTable(): Promise<void> {
20 await sqlite.execute(`
2import { cors } from "https://esm.sh/hono@3.12.6/cors";
3import { serveFile, readFile } from "https://esm.town/v/std/utils@71-main/index.ts";
4import { createTable, saveUrl, getOriginalUrl, getUrlStats, listUrls } from "./database/queries.ts";
5import { generateShortCode } from "../shared/utils.ts";
6
11app.use("/*", cors());
12
13// Initialize database on startup
14createTable().catch(console.error);
15
42 const shortCode = generateShortCode();
43
44 // Save to database
45 await saveUrl(shortCode, url);
46
91 const code = c.req.param("code");
92
93 // Get the original URL from the database
94 const originalUrl = await getOriginalUrl(code);
95
9- Responsive design with Tailwind CSS
10- Client-side routing with React Router 7
11- SQLite database for persistent storage
12
13## Project Structure
15```
16โโโ backend/
17โ โโโ database/
18โ โ โโโ migrations.ts # Database schema setup
19โ โ โโโ queries.ts # Database operations
20โ โโโ index.ts # Hono API server
21โโโ frontend/
51
521. Users enter a URL to shorten (with optional custom short ID)
532. The backend creates a new entry in the SQLite database
543. When someone visits the shortened URL, the backend:
55 - Looks up the original URL in the database
56 - Increments the click counter
57 - Redirects to the original URL