Something went wrong

We're experiencing technical difficulties. Please try again later.

\n ${error instanceof Error ? error.message : String(error)}\n

\n Return to homepage\n

\n \n \n `, {\n status: 500,\n headers: { \"Content-Type\": \"text/html\" }\n });\n }\n}","children",[],[87],"18f9c5c8-13f0-11f0-ab6b-569c3dd06744","entry.server.tsx","5c2615dc-13ef-11f0-b44b-569c3dd06744",27,["D",1744058238050],1,"/** @jsxImportSource npm:react */\nimport { renderToString } from \"npm:react-dom/server\";\nimport { createStaticHandler, createStaticRouter, StaticRouterProvider } from \"npm:react-router\";\n\nimport routes from \"./routes/index.ts\";\n\nlet { query, dataRoutes } = createStaticHandler(routes);\n\nexport async function handler(request: Request) {\n // 1. run actions/loaders to get the routing context with `query`\n let context = await query(request);\n\n // If `query` returns a Response, send it raw (a route probably a redirected)\n if (context instanceof Response) {\n return context;\n }\n\n // 2. Create a static router for SSR\n let router = createStaticRouter(dataRoutes, context);\n\n // 3. Render everything with StaticRouterProvider\n let html = renderToString(\n ,\n );\n\n // Setup headers from action and loaders from deepest match\n let leaf = context.matches[context.matches.length - 1];\n let actionHeaders = context.actionHeaders[leaf.route.id];\n let loaderHeaders = context.loaderHeaders[leaf.route.id];\n let headers = new Headers(actionHeaders);\n if (loaderHeaders) {\n for (let [key, value] of loaderHeaders.entries()) {\n headers.append(key, value);\n }\n }\n\n headers.set(\"Content-Type\", \"text/html; charset=utf-8\");\n\n // 4. send a response\n return new Response(`${html}`, {\n status: context.statusCode,\n headers,\n });\n}",[],[98],"142db0ea-13f0-11f0-9e72-569c3dd06744","entry.client.tsx","52fd858a-13ef-11f0-aa91-569c3dd06744",26,["D",1744058230001],2,"import { createElement, StrictMode } from \"npm:react\";\nimport { hydrateRoot } from \"npm:react-dom/client\";\nimport { createBrowserRouter } from \"npm:react-router\";\nimport { RouterProvider } from \"npm:react-router/dom\";\nimport routes from \"./routes/index.ts\";\n\nlet router = createBrowserRouter(routes, {\n // @ts-expect-error It's fine\n hydrationData: window.__staticRouterHydrationData,\n});\n\nhydrateRoot(document, createElement(RouterProvider, { router: router }));",[],[107],"ab628cb0-13f0-11f0-a41a-569c3dd06744","ab628d46-13f0-11f0-a41a-569c3dd06744",31,["D",1744058483684],"# URL Shortener\n\nA simple URL shortener application built on Val Town.\n\n## Features\n\n- Create short URLs for long links\n- View recently created short URLs\n- Automatic redirection from short URLs to original destinations\n\n## Project Structure\n\n- `/backend` - Server-side code and database operations\n- `/frontend` - React components and UI\n- `/shared` - Shared utilities and types\n\n## Technologies\n\n- React for the frontend\n- SQLite for data storage\n- TailwindCSS for styling",[],[61],"adc7632c-13f0-11f0-a145-569c3dd06744","shared","87ff1306-5163-42a1-8b25-91bf861c9ca1",32,["D",1744058487699],[129,130],[123],{"_36":138,"_13":61,"_39":139,"_41":124,"_43":44,"_45":140,"_47":48,"_49":141,"_17":65,"_52":24,"_54":142,"_56":57,"_58":-5,"_94":143,"_18":144},{"_36":131,"_13":132,"_39":133,"_41":124,"_43":44,"_45":125,"_47":48,"_49":134,"_17":65,"_52":53,"_54":135,"_56":57,"_58":-5,"_94":136,"_18":137},"adc75dbe-13f0-11f0-a145-569c3dd06744","utils.ts","adc75e9a-13f0-11f0-a145-569c3dd06744",["D",1744058487699],"/**\n * Generates a random short code for URL shortening\n * @returns A 6-character alphanumeric code\n */\nexport const generateShortCode = (): string => {\n const characters = \"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789\";\n let result = \"\";\n for (let i = 0; i < 6; i++) {\n result += characters.charAt(Math.floor(Math.random() * characters.length));\n }\n return result;\n};\n\n/**\n * URL-related types\n */\nexport interface ShortUrl {\n id?: number;\n shortCode: string;\n longUrl: string;\n createdAt?: string;\n}",[],[123,132],"d4292f46-13f0-11f0-803c-569c3dd06744","d4292ffa-13f0-11f0-803c-569c3dd06744",40,["D",1744058552096],"# Shared\n\nThis directory contains code that is shared between the frontend and backend.\n\n- `utils.ts` - Utility functions and shared types",[],[123,61],"7cb25536-13ef-11f0-8ae5-569c3dd06744","routes","7cb2561c-13ef-11f0-8ae5-569c3dd06744",6,["D",1744057975860],[152,153,154,155,156,157,158,159],[146],{"_36":217,"_13":218,"_39":219,"_41":147,"_43":44,"_45":220,"_47":48,"_49":221,"_17":102,"_52":53,"_54":222,"_56":57,"_58":-5,"_94":223,"_18":224},{"_36":209,"_13":210,"_39":211,"_41":147,"_43":44,"_45":212,"_47":48,"_49":213,"_17":111,"_52":53,"_54":214,"_56":57,"_58":-5,"_94":215,"_18":216},{"_36":201,"_13":202,"_39":203,"_41":147,"_43":44,"_45":204,"_47":48,"_49":205,"_17":111,"_52":53,"_54":206,"_56":57,"_58":-5,"_94":207,"_18":208},{"_36":193,"_13":194,"_39":195,"_41":147,"_43":44,"_45":196,"_47":48,"_49":197,"_17":181,"_52":53,"_54":198,"_56":57,"_58":-5,"_94":199,"_18":200},{"_36":185,"_13":38,"_39":186,"_41":147,"_43":44,"_45":187,"_47":48,"_49":188,"_17":189,"_52":53,"_54":190,"_56":57,"_58":-5,"_94":191,"_18":192},{"_36":176,"_13":177,"_39":178,"_41":147,"_43":44,"_45":179,"_47":48,"_49":180,"_17":181,"_52":53,"_54":182,"_56":57,"_58":-5,"_94":183,"_18":184},{"_36":168,"_13":169,"_39":170,"_41":147,"_43":44,"_45":171,"_47":48,"_49":172,"_17":111,"_52":53,"_54":173,"_56":57,"_58":-5,"_94":174,"_18":175},{"_36":160,"_13":161,"_39":162,"_41":147,"_43":44,"_45":163,"_47":48,"_49":164,"_17":91,"_52":53,"_54":165,"_56":57,"_58":-5,"_94":166,"_18":167},"9afc2a00-13f2-11f0-9f50-569c3dd06744","layout.tsx","ad875850-13ef-11f0-aaff-569c3dd06744",73,["D",1744059315159],"/** @jsxImportSource npm:react */\nimport { Form, Link, Outlet, useLoaderData } from \"npm:react-router\";\nimport { type loader } from \"./layout.server.ts\";\n\nexport default function Layout() {\n let data = useLoaderData();\n \n // Safe way to get the URL for view source\n const getViewSourceUrl = () => {\n if (typeof import.meta.url === \"string\") {\n return import.meta.url.replace(\"esm.town\", \"val.town\");\n }\n return \"#\";\n };\n \n return (\n \n \n \n \n URL Shortener\n {/* TailwindCSS */}\n \n {/* Error catching for debugging */}\n \n {/* Favicon */}\n \n \n \n

URL Shortener

\n \n

\n\n \n \n \n );\n}",[],[146,161],"e9780792-13ef-11f0-a18c-569c3dd06744","layout.server.ts","bac1e01c-13ef-11f0-8aea-569c3dd06744",19,["D",1744058158345],"import { ActionFunctionArgs, type LoaderFunctionArgs } from \"npm:react-router\";\n\nlet db = { message: \"Hello world!\" };\n\nexport async function loader(args: LoaderFunctionArgs) {\n await new Promise(resolve => setTimeout(resolve, 200));\n return { message: db.message };\n}\n\nexport async function action({ request }: ActionFunctionArgs) {\n let formData = await request.formData();\n db.message = String(formData.get(\"message\"));\n return { ok: true };\n}",[],[146,169],"e7538cfc-13ef-11f0-bfb0-569c3dd06744","layout.client.ts","beba5f00-13ef-11f0-a220-569c3dd06744",18,["D",1744058154751],4,"import { type LoaderFunctionArgs } from \"npm:react-router\";\n\nexport async function loader({ request }: LoaderFunctionArgs) {\n let url = new URL(request.url);\n let res = await fetch(url, {\n headers: {\n Accept: \"application/json\",\n \"X-Route-Id\": \"layout\",\n },\n });\n return res.json();\n}\n\nexport async function action({ request }: LoaderFunctionArgs) {\n let url = new URL(request.url);\n // call the server action\n let res = await fetch(url, {\n method: \"POST\",\n body: new URLSearchParams(await request.formData()),\n headers: {\n \"Content-Type\": \"application/x-www-form-urlencoded\",\n Accept: \"application/json\",\n \"X-Route-Id\": \"layout\",\n },\n });\n return res.json();\n}",[],[146,177],"56790858-13f2-11f0-a522-569c3dd06744","7f420d0a-13ef-11f0-ac6f-569c3dd06744",70,["D",1744059200210],8,"import { ActionFunctionArgs, LoaderFunctionArgs } from \"npm:react-router\";\nimport Layout from \"./layout.tsx\";\nimport Home from \"./home.tsx\";\nimport CreateShortUrl from \"./create.tsx\";\nimport About from \"./about.tsx\";\n\nlet isServer = typeof document === \"undefined\";\n\nexport default [\n {\n id: \"layout\",\n path: \"/\",\n Component: Layout,\n // up to you where your loaders run (client or server), this one dynamically\n // imports the correct one to avoid putting the server code in client\n // bundles\n async loader(args: LoaderFunctionArgs) {\n let mod = await (isServer\n ? import(\"./layout.server.ts\")\n : import(\"./layout.client.ts\"));\n return mod.loader(args);\n },\n // same with the action, you'll probably want to abstract this kind of stuff\n // in a createRoute() kind of thing\n async action(args: ActionFunctionArgs) {\n let mod = await (isServer\n ? import(\"./layout.server.ts\")\n : import(\"./layout.client.ts\"));\n return mod.action(args);\n },\n children: [\n {\n id: \"home\",\n index: true,\n Component: Home,\n ErrorBoundary: Home.ErrorBoundary,\n async loader(args: LoaderFunctionArgs) {\n // Fetch recent URLs\n const response = await fetch(new URL(\"/api/recent\", args.request.url));\n if (!response.ok) {\n throw new Error(\"Failed to fetch recent URLs\");\n }\n return response.json();\n },\n },\n {\n id: \"create\",\n path: \"create\",\n Component: CreateShortUrl,\n ErrorBoundary: CreateShortUrl.ErrorBoundary,\n async action(args: ActionFunctionArgs) {\n const formData = await args.request.formData();\n const longUrl = formData.get(\"longUrl\");\n \n // Create short URL\n const response = await fetch(new URL(\"/api/shorten\", args.request.url), {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ longUrl }),\n });\n \n if (!response.ok) {\n throw new Error(\"Failed to create short URL\");\n }\n \n return response.json();\n },\n },\n {\n id: \"about\",\n path: \"about\",\n Component: About,\n async loader() {\n return { message: \"About URL Shortener\" };\n },\n },\n ],\n },\n];",[],[146,38],"8e5fdd1e-13f2-11f0-a7ca-569c3dd06744","home.tsx","f674faf4-13ef-11f0-9a50-569c3dd06744",72,["D",1744059294002],"/** @jsxImportSource npm:react */\nimport { useLoaderData, useRouteError, isRouteErrorResponse } from \"npm:react-router\";\nimport { useState, useEffect } from \"npm:react\";\nimport { ShortUrl } from \"../shared/utils.ts\";\n\n// Error boundary component\nfunction ErrorBoundary() {\n const error = useRouteError();\n \n let errorMessage = \"An unexpected error occurred\";\n if (isRouteErrorResponse(error)) {\n errorMessage = `${error.status} ${error.statusText}`;\n } else if (error instanceof Error) {\n errorMessage = error.message;\n }\n \n return (\n

Error loading recent URLs

{errorMessage}

\n \n

\n );\n}\n\nexport default function Home() {\n const recentUrls = useLoaderData() as ShortUrl[];\n const [origin, setOrigin] = useState(\"\");\n\n // Set origin on client-side only\n useEffect(() => {\n if (typeof window !== \"undefined\") {\n setOrigin(window.location.origin);\n }\n }, []);\n\n return (\n

Recent Short URLs

\n {recentUrls.length === 0 ? (\n

No URLs have been shortened yet. Be the first!

\n ) : (\n

\n \n {origin ? `${origin}/${url.shortCode}` : `/${url.shortCode}`}\n \n
\n {url.longUrl}\n
\n

\n )}\n

\n );\n}\n\n// Export the error boundary\nHome.ErrorBoundary = ErrorBoundary;",[],[146,194],"844f7dd4-13f2-11f0-96fc-569c3dd06744","create.tsx","e715b9b6-13f1-11f0-939c-569c3dd06744",71,["D",1744059277118],"/** @jsxImportSource npm:react */\nimport { Form, useActionData, useNavigation, useRouteError, isRouteErrorResponse } from \"npm:react-router\";\nimport { useState, useEffect } from \"npm:react\";\nimport { ShortUrl } from \"../shared/utils.ts\";\n\n// Error boundary component\nfunction ErrorBoundary() {\n const error = useRouteError();\n \n let errorMessage = \"An unexpected error occurred\";\n if (isRouteErrorResponse(error)) {\n errorMessage = `${error.status} ${error.statusText}`;\n } else if (error instanceof Error) {\n errorMessage = error.message;\n }\n \n return (\n

Error creating short URL

{errorMessage}

\n \n

\n );\n}\n\nexport default function CreateShortUrl() {\n const actionData = useActionData() as ShortUrl | undefined;\n const navigation = useNavigation();\n const isSubmitting = navigation.state === \"submitting\";\n const [shortUrl, setShortUrl] = useState(null);\n const [origin, setOrigin] = useState(\"\");\n\n // Set origin on client-side only\n useEffect(() => {\n if (typeof window !== \"undefined\") {\n setOrigin(window.location.origin);\n }\n }, []);\n\n // Update shortUrl when actionData changes (client-side only)\n useEffect(() => {\n if (actionData?.shortCode && origin) {\n setShortUrl(`${origin}/${actionData.shortCode}`);\n }\n }, [actionData, origin]);\n\n return (\n

Create Short URL

\n \n \n {shortUrl && (\n

Short URL created:

\n \n {shortUrl}\n \n

\n )}\n

\n );\n}\n\n// Export the error boundary\nCreateShortUrl.ErrorBoundary = ErrorBoundary;",[],[146,202],"ec2d3802-13f1-11f0-87d8-569c3dd06744","about.tsx","ff60d7e6-13ef-11f0-b525-569c3dd06744",61,["D",1744059021880],"/** @jsxImportSource npm:react */\nimport { useLoaderData } from \"npm:react-router\";\n\nexport default function About() {\n const data = useLoaderData() as { message: string };\n \n return (\n

{data.message}

\n This is a simple URL shortener application built with React Router and Val Town.\n

\n Create short, easy-to-share links that redirect to your long URLs.\n

How it works:

Enter a long URL in the \"Shorten URL\" page
Get a short URL that you can share
When someone visits the short URL, they'll be redirected to your original URL

\n );\n}",[],[146,210],"0bdbe420-13f0-11f0-b91e-569c3dd06744","about.loader.ts","09aa151e-13f0-11f0-a218-569c3dd06744",25,["D",1744058216043],"import { data } from \"npm:react-router\";\n\nexport default async function load() {\n await new Promise(resolve => setTimeout(resolve, 200));\n\n let isServer = typeof document === \"undefined\";\n let env = isServer ? \"server\" : \"client\";\n\n return data(\n { message: `About loader from ${env} loader` },\n {\n headers: { \"X-Custom\": \"Hello\" },\n },\n );\n}",[],[146,218],"c02e83ec-13f0-11f0-ab97-569c3dd06744","frontend","e982ed55-985b-4f41-99b8-1fe4ebf462ba",35,["D",1744058518575],[232,233,234],[226],{"_36":250,"_13":251,"_39":252,"_41":227,"_43":44,"_45":228,"_47":48,"_49":253,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_94":254,"_18":255},{"_36":243,"_13":61,"_39":244,"_41":227,"_43":44,"_45":245,"_47":48,"_49":246,"_17":65,"_52":24,"_54":247,"_56":57,"_58":-5,"_94":248,"_18":249},{"_36":235,"_13":236,"_39":237,"_41":227,"_43":44,"_45":238,"_47":48,"_49":239,"_17":65,"_52":24,"_54":240,"_56":57,"_58":-5,"_94":241,"_18":242},"3b11a76a-13f1-11f0-9a33-569c3dd06744","favicon.svg","3b11a81e-13f1-11f0-9a33-569c3dd06744",47,["D",1744058724746],"",[],[226,236],"d598800c-13f0-11f0-bbb9-569c3dd06744","d59880c0-13f0-11f0-bbb9-569c3dd06744",41,["D",1744058554503],"# Frontend\n\nThis directory contains the React frontend for the URL shortener application.\n\n- `index.html` - Main HTML template\n- `index.tsx` - Entry point for the React application\n- `components/` - React components",[],[226,61],"c02e866c-13f0-11f0-ab97-569c3dd06744","components","090d1353-aaa7-4229-be8c-ef5b2efad21d",["D",1744058518575],[256,257,258],[226,251],{"_36":275,"_13":276,"_39":277,"_41":252,"_43":44,"_45":228,"_47":48,"_49":278,"_17":65,"_52":53,"_54":279,"_56":57,"_58":-5,"_94":280,"_18":281},{"_36":267,"_13":268,"_39":269,"_41":252,"_43":44,"_45":270,"_47":48,"_49":271,"_17":65,"_52":53,"_54":272,"_56":57,"_58":-5,"_94":273,"_18":274},{"_36":259,"_13":260,"_39":261,"_41":252,"_43":44,"_45":262,"_47":48,"_49":263,"_17":65,"_52":53,"_54":264,"_56":57,"_58":-5,"_94":265,"_18":266},"c56ff6f6-13f0-11f0-a439-569c3dd06744","Home.tsx","c56ff7a0-13f0-11f0-a439-569c3dd06744",36,["D",1744058527393],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { ShortUrl } from \"../../shared/utils.ts\";\n\nexport function Home() {\n const [recentUrls, setRecentUrls] = useState([]);\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(null);\n\n useEffect(() => {\n setIsLoading(true);\n fetch(\"/api/recent\")\n .then(response => {\n if (!response.ok) {\n throw new Error(\"Failed to fetch recent URLs\");\n }\n return response.json();\n })\n .then(data => {\n setRecentUrls(data);\n setIsLoading(false);\n })\n .catch(error => {\n console.error(\"Error fetching recent URLs:\", error);\n setError(\"Failed to load recent URLs. Please try again later.\");\n setIsLoading(false);\n });\n }, []);\n\n if (isLoading) {\n return

Loading recent URLs...

;\n }\n\n if (error) {\n return

{error}

;\n }\n\n return (\n

Recent Short URLs

\n {recentUrls.length === 0\n ?

No URLs have been shortened yet. Be the first!

\n : (\n

\n \n {`${window.location.origin}/${url.shortCode}`}\n \n
\n {url.longUrl}\n
\n

\n )}\n

\n );\n}",[],[226,251,260],"cd19049c-13f0-11f0-824b-569c3dd06744","CreateShortUrl.tsx","cd190596-13f0-11f0-824b-569c3dd06744",37,["D",1744058540230],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function CreateShortUrl() {\n const [longUrl, setLongUrl] = useState(\"\");\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(null);\n const [shortUrl, setShortUrl] = useState(null);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n setError(null);\n setShortUrl(null);\n\n try {\n const response = await fetch(\"/api/shorten\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ longUrl }),\n });\n\n if (!response.ok) {\n throw new Error(\"Failed to create short URL\");\n }\n\n const data = await response.json();\n setShortUrl(`${window.location.origin}/${data.shortCode}`);\n setLongUrl(\"\");\n } catch (err) {\n setError(\"An error occurred while creating the short URL. Please try again.\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n return (\n

Create Short URL

\n \n {error &&

{error}

}\n {shortUrl && (\n

Short URL created:

\n \n {shortUrl}\n \n

\n )}\n

\n );\n}",[],[226,251,268],"c02e72a8-13f0-11f0-ab97-569c3dd06744","App.tsx","c02e7384-13f0-11f0-ab97-569c3dd06744",["D",1744058518575],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { Home } from \"./Home.tsx\";\nimport { CreateShortUrl } from \"./CreateShortUrl.tsx\";\n\nexport function App() {\n const [currentRoute, setCurrentRoute] = useState(\"/\");\n\n useEffect(() => {\n const handleHashChange = () => {\n setCurrentRoute(window.location.hash.slice(1) || \"/\");\n };\n window.addEventListener(\"hashchange\", handleHashChange);\n handleHashChange();\n return () => window.removeEventListener(\"hashchange\", handleHashChange);\n }, []);\n\n return (\n

URL Shortener

\n \n

\n {currentRoute === \"/\" && }\n {currentRoute === \"/create\" && }\n

\n \n

\n );\n}",[],[226,251,276],["D",1744058497486],[285,286,287],[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":294,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_94":295,"_18":296},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":291,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_94":292,"_18":293},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":288,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_94":289,"_18":290},["D",1744058924775],[],[19,38],["D",1744058558120],[],[19,61],["D",1744058497486],[297,298],[19,69],{"_36":307,"_13":61,"_39":308,"_41":70,"_43":44,"_45":309,"_47":48,"_49":310,"_17":65,"_52":24,"_54":311,"_56":57,"_58":-5,"_94":312,"_18":313},{"_36":299,"_13":300,"_39":301,"_41":70,"_43":44,"_45":302,"_47":48,"_49":303,"_17":102,"_52":53,"_54":304,"_56":57,"_58":-5,"_94":305,"_18":306},"1cc50508-13f2-11f0-a69f-569c3dd06744","queries.ts","b39d0bc6-13f0-11f0-a1c3-569c3dd06744",65,["D",1744059103405],"import { ShortUrl } from \"../../shared/utils.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table name for URL shortener - use a fixed name with version\nconst TABLE_NAME = \"url_shortener_v1\";\n\n/**\n * Initialize the database schema\n */\nexport const initializeDatabase = async (metaUrl: string): Promise => {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n shortCode TEXT UNIQUE NOT NULL,\n longUrl TEXT NOT NULL,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n};\n\n/**\n * Create a new short URL\n */\nexport const createShortUrl = async (\n shortCode: string, \n longUrl: string, \n metaUrl: string\n): Promise => {\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (shortCode, longUrl) VALUES (?, ?)`, \n [shortCode, longUrl]\n );\n \n return { shortCode, longUrl };\n};\n\n/**\n * Get recent short URLs\n */\nexport const getRecentUrls = async (metaUrl: string, limit = 5): Promise => {\n const result = await sqlite.execute(\n `SELECT shortCode, longUrl FROM ${TABLE_NAME} \n ORDER BY createdAt DESC LIMIT ?`,\n [limit]\n );\n \n return result.rows as ShortUrl[];\n};\n\n/**\n * Find a URL by its short code\n */\nexport const findUrlByShortCode = async (shortCode: string, metaUrl: string): Promise => {\n const result = await sqlite.execute(\n `SELECT shortCode, longUrl FROM ${TABLE_NAME} WHERE shortCode = ?`, \n [shortCode]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as ShortUrl;\n};",[],[19,69,300],"d96e4dce-13f0-11f0-8775-569c3dd06744","d96e4e82-13f0-11f0-8775-569c3dd06744",43,["D",1744058560939],"# Database\n\nThis directory contains database-related code.\n\n- `queries.ts` - Database operations for the URL shortener",[],[19,69,61],"3846fd0c-13ef-11f0-bfb0-569c3dd06744",["D",1744057861075],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","c7d91915-4070-4350-8e28-6c792ff73b1c","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","9ee5b56c-6e87-47cb-98e4-c31219468b31","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_366":362},"org",{"_11":12,"_360":-5,"_361":362,"_323":324,"_363":364,"_365":57},"branch",{"_17":163,"_13":16,"_36":44,"_352":314,"_353":-5,"_354":-5,"_355":-5,"_356":-5,"_357":-5,"_358":14,"_359":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTFCT2UzVDJHbzF6RjhPTnpBd3p6VEJHZEQifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":314,"_13":14,"_49":489,"_316":-5,"_317":57,"_318":319,"_320":319,"_321":-5,"_322":-5,"_323":324,"_325":88,"_326":48,"_327":-5,"_328":89,"_329":91,"_330":331,"_332":-5,"_333":-5,"_334":-5,"_335":-5,"_336":337,"_338":337,"_339":340,"_341":340,"_342":340,"_343":337,"_344":337,"_345":490,"_347":491,"_349":492,"_351":57},[402,408,415,424,427,428,429,430],"files",[402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430],"counts",{"_393":65,"_394":102,"_395":181,"_32":396,"_397":398},[387,388,389],{"_36":75,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":71,"_47":48,"_49":76,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":386},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":72,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":392},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_18":391},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":390},[19,38],[19,61],[19,69],"pulls","branches","forks",{"_399":65,"_401":65},"connections",{"_399":65,"_400":65},"count","unfilledCount","emptyCount",{"_36":75,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":71,"_47":48,"_49":282,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_94":487,"_18":488},{"_36":68,"_13":69,"_39":70,"_41":42,"_43":44,"_45":71,"_47":48,"_49":294,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_94":485,"_18":486},{"_36":307,"_13":61,"_39":308,"_41":70,"_43":44,"_45":309,"_47":48,"_49":310,"_17":65,"_52":24,"_54":311,"_56":57,"_58":-5,"_94":483,"_18":484},{"_36":299,"_13":300,"_39":301,"_41":70,"_43":44,"_45":302,"_47":48,"_49":303,"_17":102,"_52":53,"_54":304,"_56":57,"_58":-5,"_94":481,"_18":482},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":291,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_94":479,"_18":480},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":288,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_94":477,"_18":478},{"_36":225,"_13":226,"_39":227,"_41":-5,"_43":44,"_45":228,"_47":48,"_49":229,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_94":475,"_18":476},{"_36":250,"_13":251,"_39":252,"_41":227,"_43":44,"_45":228,"_47":48,"_49":253,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_94":473,"_18":474},{"_36":275,"_13":276,"_39":277,"_41":252,"_43":44,"_45":228,"_47":48,"_49":278,"_17":65,"_52":53,"_54":279,"_56":57,"_58":-5,"_94":471,"_18":472},{"_36":267,"_13":268,"_39":269,"_41":252,"_43":44,"_45":270,"_47":48,"_49":271,"_17":65,"_52":53,"_54":272,"_56":57,"_58":-5,"_94":469,"_18":470},{"_36":259,"_13":260,"_39":261,"_41":252,"_43":44,"_45":262,"_47":48,"_49":263,"_17":65,"_52":53,"_54":264,"_56":57,"_58":-5,"_94":467,"_18":468},{"_36":243,"_13":61,"_39":244,"_41":227,"_43":44,"_45":245,"_47":48,"_49":246,"_17":65,"_52":24,"_54":247,"_56":57,"_58":-5,"_94":465,"_18":466},{"_36":235,"_13":236,"_39":237,"_41":227,"_43":44,"_45":238,"_47":48,"_49":239,"_17":65,"_52":24,"_54":240,"_56":57,"_58":-5,"_94":463,"_18":464},{"_36":145,"_13":146,"_39":147,"_41":-5,"_43":44,"_45":148,"_47":48,"_49":149,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_94":461,"_18":462},{"_36":217,"_13":218,"_39":219,"_41":147,"_43":44,"_45":220,"_47":48,"_49":221,"_17":102,"_52":53,"_54":222,"_56":57,"_58":-5,"_94":459,"_18":460},{"_36":209,"_13":210,"_39":211,"_41":147,"_43":44,"_45":212,"_47":48,"_49":213,"_17":111,"_52":53,"_54":214,"_56":57,"_58":-5,"_94":457,"_18":458},{"_36":201,"_13":202,"_39":203,"_41":147,"_43":44,"_45":204,"_47":48,"_49":205,"_17":111,"_52":53,"_54":206,"_56":57,"_58":-5,"_94":455,"_18":456},{"_36":193,"_13":194,"_39":195,"_41":147,"_43":44,"_45":196,"_47":48,"_49":197,"_17":181,"_52":53,"_54":198,"_56":57,"_58":-5,"_94":453,"_18":454},{"_36":185,"_13":38,"_39":186,"_41":147,"_43":44,"_45":187,"_47":48,"_49":188,"_17":189,"_52":53,"_54":190,"_56":57,"_58":-5,"_94":451,"_18":452},{"_36":176,"_13":177,"_39":178,"_41":147,"_43":44,"_45":179,"_47":48,"_49":180,"_17":181,"_52":53,"_54":182,"_56":57,"_58":-5,"_94":449,"_18":450},{"_36":168,"_13":169,"_39":170,"_41":147,"_43":44,"_45":171,"_47":48,"_49":172,"_17":111,"_52":53,"_54":173,"_56":57,"_58":-5,"_94":447,"_18":448},{"_36":160,"_13":161,"_39":162,"_41":147,"_43":44,"_45":163,"_47":48,"_49":164,"_17":91,"_52":53,"_54":165,"_56":57,"_58":-5,"_94":445,"_18":446},{"_36":122,"_13":123,"_39":124,"_41":-5,"_43":44,"_45":125,"_47":48,"_49":126,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_94":443,"_18":444},{"_36":138,"_13":61,"_39":139,"_41":124,"_43":44,"_45":140,"_47":48,"_49":141,"_17":65,"_52":24,"_54":142,"_56":57,"_58":-5,"_94":441,"_18":442},{"_36":131,"_13":132,"_39":133,"_41":124,"_43":44,"_45":125,"_47":48,"_49":134,"_17":65,"_52":53,"_54":135,"_56":57,"_58":-5,"_94":439,"_18":440},{"_36":115,"_13":61,"_39":116,"_41":-5,"_43":44,"_45":117,"_47":48,"_49":118,"_17":65,"_52":24,"_54":119,"_56":57,"_58":-5,"_94":437,"_18":438},{"_36":106,"_13":107,"_39":108,"_41":-5,"_43":44,"_45":109,"_47":48,"_49":110,"_17":111,"_52":53,"_54":112,"_56":57,"_58":-5,"_94":435,"_18":436},{"_36":97,"_13":98,"_39":99,"_41":-5,"_43":44,"_45":100,"_47":48,"_49":101,"_17":102,"_52":53,"_54":103,"_56":57,"_58":-5,"_94":433,"_18":434},{"_36":86,"_13":87,"_39":88,"_41":-5,"_43":44,"_45":89,"_47":48,"_49":90,"_17":91,"_52":92,"_54":93,"_56":57,"_58":-5,"_94":431,"_18":432},[],[87],[],[98],[],[107],[],[61],[],[123,132],[],[123,61],[425,426],[123],[],[146,161],[],[146,169],[],[146,177],[],[146,38],[],[146,194],[],[146,202],[],[146,210],[],[146,218],[416,417,418,419,420,421,422,423],[146],[],[226,236],[],[226,61],[],[226,251,260],[],[226,251,268],[],[226,251,276],[410,411,412],[226,251],[409,413,414],[226],[],[19,38],[],[19,61],[],[19,69,300],[],[19,69,61],[404,405],[19,69],[403,406,407],[19],["D",1744057861075],{"_11":12,"_366":362},{"_11":12,"_360":-5,"_361":362,"_323":324,"_363":364,"_365":57},{"_17":163,"_13":16,"_36":44,"_352":314,"_353":-5,"_354":-5,"_355":-5,"_356":-5,"_357":-5,"_358":14,"_359":12},"ctx",{"_345":-5,"_383":526,"_527":528,"_529":530,"_531":57,"_532":57,"_533":57,"_534":48,"_535":-5,"_536":-7,"_537":-7,"_538":65,"_539":57,"_540":57,"_541":-5,"_542":57,"_543":57,"_544":57,"_545":-5},"ENV",{"_497":498,"_499":500,"_501":16,"_502":503,"_504":505,"_506":507,"_508":509,"_510":511,"_512":513,"_514":515,"_516":517,"_518":519,"_520":521,"_522":523,"_524":525},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]