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",[],[105],"8a33dc34-6a11-11f0-848c-0224a6c84d84","entry.server.tsx","0198466f-fdf2-776a-8f28-a406961fbdf6",["D",1753528401323],"/** @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}",[],[114],"8a33cfbe-6a11-11f0-848c-0224a6c84d84","entry.client.tsx","0198466f-fdf2-776a-8f28-a3512ba50058",["D",1753528401323],"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 }));",[],[121],"8a33cec4-6a11-11f0-848c-0224a6c84d84","0198466f-fdf2-776a-8f28-9f29b99e342c",["D",1753528401323],"# 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",[],[82],"8a33cdd4-6a11-11f0-848c-0224a6c84d84","shared","0198466f-fdf2-776a-8f28-9a6d976ea219",["D",1753528401323],[139,140],[134],{"_35":148,"_13":82,"_63":149,"_65":135,"_67":68,"_69":70,"_71":72,"_37":150,"_17":32,"_74":24,"_76":151,"_78":50,"_79":-5,"_110":152,"_18":153},{"_35":141,"_13":142,"_63":143,"_65":135,"_67":68,"_69":70,"_71":72,"_37":144,"_17":32,"_74":75,"_76":145,"_78":50,"_79":-5,"_110":146,"_18":147},"8a33cc30-6a11-11f0-848c-0224a6c84d84","utils.ts","0198466f-fdf2-776a-8f28-9780359c92f0",["D",1753528401323],"/**\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}",[],[134,142],"8a33c97e-6a11-11f0-848c-0224a6c84d84","0198466f-fdf2-776a-8f28-905d0ff009b3",["D",1753528401323],"# Shared\n\nThis directory contains code that is shared between the frontend and backend.\n\n- `utils.ts` - Utility functions and shared types",[],[134,82],"8a33c6f4-6a11-11f0-848c-0224a6c84d84","routes","0198466f-fdf2-776a-8f28-8eb31b4ee130",["D",1753528401323],[160,161,162,163,164,165,166,167],[155],{"_35":216,"_13":217,"_63":218,"_65":156,"_67":68,"_69":70,"_71":72,"_37":219,"_17":32,"_74":75,"_76":220,"_78":50,"_79":-5,"_110":221,"_18":222},{"_35":209,"_13":210,"_63":211,"_65":156,"_67":68,"_69":70,"_71":72,"_37":212,"_17":32,"_74":75,"_76":213,"_78":50,"_79":-5,"_110":214,"_18":215},{"_35":202,"_13":203,"_63":204,"_65":156,"_67":68,"_69":70,"_71":72,"_37":205,"_17":32,"_74":75,"_76":206,"_78":50,"_79":-5,"_110":207,"_18":208},{"_35":195,"_13":196,"_63":197,"_65":156,"_67":68,"_69":70,"_71":72,"_37":198,"_17":32,"_74":75,"_76":199,"_78":50,"_79":-5,"_110":200,"_18":201},{"_35":189,"_13":62,"_63":190,"_65":156,"_67":68,"_69":70,"_71":72,"_37":191,"_17":32,"_74":75,"_76":192,"_78":50,"_79":-5,"_110":193,"_18":194},{"_35":182,"_13":183,"_63":184,"_65":156,"_67":68,"_69":70,"_71":72,"_37":185,"_17":32,"_74":75,"_76":186,"_78":50,"_79":-5,"_110":187,"_18":188},{"_35":175,"_13":176,"_63":177,"_65":156,"_67":68,"_69":70,"_71":72,"_37":178,"_17":32,"_74":75,"_76":179,"_78":50,"_79":-5,"_110":180,"_18":181},{"_35":168,"_13":169,"_63":170,"_65":156,"_67":68,"_69":70,"_71":72,"_37":171,"_17":32,"_74":75,"_76":172,"_78":50,"_79":-5,"_110":173,"_18":174},"8a33c492-6a11-11f0-848c-0224a6c84d84","layout.tsx","0198466f-fdf2-776a-8f28-8aaa5c9b45fa",["D",1753528401323],"/** @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}",[],[155,169],"8a33c398-6a11-11f0-848c-0224a6c84d84","layout.server.ts","0198466f-fdf2-776a-8f28-8501db373ad6",["D",1753528401323],"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}",[],[155,176],"8a33c276-6a11-11f0-848c-0224a6c84d84","layout.client.ts","0198466f-fdf2-776a-8f28-82d6b2820a8c",["D",1753528401323],"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}",[],[155,183],"8a33c064-6a11-11f0-848c-0224a6c84d84","0198466f-fdf2-776a-8f28-7ffb2ab25bd2",["D",1753528401323],"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];",[],[155,62],"8a33be20-6a11-11f0-848c-0224a6c84d84","home.tsx","0198466f-fdf2-776a-8f28-7ab57e6ba467",["D",1753528401323],"/** @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;",[],[155,196],"8a33b9fc-6a11-11f0-848c-0224a6c84d84","create.tsx","0198466f-fdf2-776a-8f28-75c531312f2e",["D",1753528401323],"/** @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;",[],[155,203],"8a33b90c-6a11-11f0-848c-0224a6c84d84","about.tsx","0198466f-fdf2-776a-8f28-71caf50c12df",["D",1753528401323],"/** @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}",[],[155,210],"8a33b79a-6a11-11f0-848c-0224a6c84d84","about.loader.ts","0198466f-fdf2-776a-8f28-6d05e0145b9a",["D",1753528401323],"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}",[],[155,217],"8a33b6a0-6a11-11f0-848c-0224a6c84d84","frontend","0198466f-fdf2-776a-8f28-6be9fca375d5",["D",1753528401323],[229,230,231],[224],{"_35":245,"_13":246,"_63":247,"_65":225,"_67":68,"_69":70,"_71":72,"_37":248,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_110":249,"_18":250},{"_35":239,"_13":82,"_63":240,"_65":225,"_67":68,"_69":70,"_71":72,"_37":241,"_17":32,"_74":24,"_76":242,"_78":50,"_79":-5,"_110":243,"_18":244},{"_35":232,"_13":233,"_63":234,"_65":225,"_67":68,"_69":70,"_71":72,"_37":235,"_17":32,"_74":24,"_76":236,"_78":50,"_79":-5,"_110":237,"_18":238},"8a33b45c-6a11-11f0-848c-0224a6c84d84","favicon.svg","0198466f-fdf2-776a-8f28-64d71d413658",["D",1753528401323],"",[],[224,233],"8a33af48-6a11-11f0-848c-0224a6c84d84","0198466f-fdf2-776a-8f28-603c20a07c19",["D",1753528401323],"# 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",[],[224,82],"8a33ae58-6a11-11f0-848c-0224a6c84d84","components","0198466f-fdf2-776a-8f28-5eb0a64f39fd",["D",1753528401323],[251,252,253],[224,246],{"_35":268,"_13":269,"_63":270,"_65":247,"_67":68,"_69":70,"_71":72,"_37":271,"_17":32,"_74":75,"_76":272,"_78":50,"_79":-5,"_110":273,"_18":274},{"_35":261,"_13":262,"_63":263,"_65":247,"_67":68,"_69":70,"_71":72,"_37":264,"_17":32,"_74":75,"_76":265,"_78":50,"_79":-5,"_110":266,"_18":267},{"_35":254,"_13":255,"_63":256,"_65":247,"_67":68,"_69":70,"_71":72,"_37":257,"_17":32,"_74":75,"_76":258,"_78":50,"_79":-5,"_110":259,"_18":260},"8a33ac0a-6a11-11f0-848c-0224a6c84d84","Home.tsx","0198466f-fdf2-776a-8f28-593aa9daca84",["D",1753528401323],"/** @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}",[],[224,246,255],"8a33a85e-6a11-11f0-848c-0224a6c84d84","CreateShortUrl.tsx","0198466f-fdf2-776a-8f28-56d4136844f9",["D",1753528401323],"/** @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}",[],[224,246,262],"8a33a62e-6a11-11f0-848c-0224a6c84d84","App.tsx","0198466f-fdf2-776a-8f28-5122b55c6ea1",["D",1753528401323],"/** @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}",[],[224,246,269],["D",1753528401323],[278,279,280],[19],{"_35":87,"_13":88,"_63":89,"_65":66,"_67":68,"_69":70,"_71":72,"_37":287,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_110":288,"_18":289},{"_35":81,"_13":82,"_63":83,"_65":66,"_67":68,"_69":70,"_71":72,"_37":284,"_17":32,"_74":24,"_76":85,"_78":50,"_79":-5,"_110":285,"_18":286},{"_35":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_37":281,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_110":282,"_18":283},["D",1753528401323],[],[19,62],["D",1753528401323],[],[19,82],["D",1753528401323],[290,291],[19,88],{"_35":299,"_13":82,"_63":300,"_65":89,"_67":68,"_69":70,"_71":72,"_37":301,"_17":32,"_74":24,"_76":302,"_78":50,"_79":-5,"_110":303,"_18":304},{"_35":292,"_13":293,"_63":294,"_65":89,"_67":68,"_69":70,"_71":72,"_37":295,"_17":32,"_74":75,"_76":296,"_78":50,"_79":-5,"_110":297,"_18":298},"8a3394d6-6a11-11f0-848c-0224a6c84d84","queries.ts","0198466f-fdf2-776a-8f28-3eceb9726601",["D",1753528401323],"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,88,293],"8a338806-6a11-11f0-848c-0224a6c84d84","0198466f-fdf2-776a-8f28-3ab864d78ff3",["D",1753528401323],"# Database\n\nThis directory contains database-related code.\n\n- `queries.ts` - Database operations for the URL shortener",[],[19,88,82],"8a2b7af8-6a11-11f0-848c-0224a6c84d84",["D",1753528401323],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","f2200a7e-17a7-4960-8b5f-db038d939a4a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","65803414-f145-46ee-bb85-fe0888ce30ea","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_347":343},"org",{"_11":12,"_341":-5,"_342":343,"_311":312,"_344":345,"_346":50},"branch",{"_17":70,"_13":16,"_35":68,"_41":305,"_44":36,"_45":43,"_338":52,"_339":42,"_340":56,"_57":14,"_53":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJyYzFDNkhQSDFFRVVzZ3Z4b1lNRjZVTzdHVyJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":305,"_13":14,"_37":477,"_48":-5,"_307":50,"_51":52,"_308":52,"_309":-5,"_310":-5,"_311":312,"_313":106,"_314":72,"_315":72,"_316":-5,"_317":32,"_55":318,"_319":-5,"_320":-5,"_321":-5,"_322":-5,"_323":324,"_325":324,"_326":327,"_328":327,"_329":327,"_330":324,"_331":324,"_332":478,"_334":479,"_336":480,"_49":50},[390,396,403,412,415,416,417,418],"files",[390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418],"counts",{"_381":32,"_382":70,"_383":32,"_34":384,"_385":386},[375,376,377],{"_35":93,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":373,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_18":374},"upstreamProject",{"_35":42,"_13":14,"_309":-5,"_310":-5,"_51":52,"_332":371},"upstreamBranch",{"_35":36,"_37":369,"_39":370,"_13":16,"_41":42,"_17":43,"_44":-5,"_45":-5,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":54,"_55":56,"_57":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1744057861075],["D",1744059315159],{"_11":54,"_347":372},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTFCT2UzVDJHbzF6RjhPTnpBd3p6VEJHZEQifQ",["D",1753528401323],[19],{"_35":87,"_13":88,"_63":89,"_65":66,"_67":68,"_69":70,"_71":72,"_37":90,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_18":380},{"_35":81,"_13":82,"_63":83,"_65":66,"_67":68,"_69":70,"_71":72,"_37":84,"_17":32,"_74":24,"_76":85,"_78":50,"_79":-5,"_18":379},{"_35":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_37":73,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_18":378},[19,62],[19,82],[19,88],"pulls","branches","forks",{"_387":32,"_389":32},"connections",{"_387":32,"_388":32},"count","unfilledCount","emptyCount",{"_35":93,"_13":19,"_63":66,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":275,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_110":475,"_18":476},{"_35":87,"_13":88,"_63":89,"_65":66,"_67":68,"_69":70,"_71":72,"_37":287,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_110":473,"_18":474},{"_35":299,"_13":82,"_63":300,"_65":89,"_67":68,"_69":70,"_71":72,"_37":301,"_17":32,"_74":24,"_76":302,"_78":50,"_79":-5,"_110":471,"_18":472},{"_35":292,"_13":293,"_63":294,"_65":89,"_67":68,"_69":70,"_71":72,"_37":295,"_17":32,"_74":75,"_76":296,"_78":50,"_79":-5,"_110":469,"_18":470},{"_35":81,"_13":82,"_63":83,"_65":66,"_67":68,"_69":70,"_71":72,"_37":284,"_17":32,"_74":24,"_76":85,"_78":50,"_79":-5,"_110":467,"_18":468},{"_35":61,"_13":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_37":281,"_17":32,"_74":75,"_76":77,"_78":50,"_79":-5,"_110":465,"_18":466},{"_35":223,"_13":224,"_63":225,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":226,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_110":463,"_18":464},{"_35":245,"_13":246,"_63":247,"_65":225,"_67":68,"_69":70,"_71":72,"_37":248,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_110":461,"_18":462},{"_35":268,"_13":269,"_63":270,"_65":247,"_67":68,"_69":70,"_71":72,"_37":271,"_17":32,"_74":75,"_76":272,"_78":50,"_79":-5,"_110":459,"_18":460},{"_35":261,"_13":262,"_63":263,"_65":247,"_67":68,"_69":70,"_71":72,"_37":264,"_17":32,"_74":75,"_76":265,"_78":50,"_79":-5,"_110":457,"_18":458},{"_35":254,"_13":255,"_63":256,"_65":247,"_67":68,"_69":70,"_71":72,"_37":257,"_17":32,"_74":75,"_76":258,"_78":50,"_79":-5,"_110":455,"_18":456},{"_35":239,"_13":82,"_63":240,"_65":225,"_67":68,"_69":70,"_71":72,"_37":241,"_17":32,"_74":24,"_76":242,"_78":50,"_79":-5,"_110":453,"_18":454},{"_35":232,"_13":233,"_63":234,"_65":225,"_67":68,"_69":70,"_71":72,"_37":235,"_17":32,"_74":24,"_76":236,"_78":50,"_79":-5,"_110":451,"_18":452},{"_35":154,"_13":155,"_63":156,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":157,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_110":449,"_18":450},{"_35":216,"_13":217,"_63":218,"_65":156,"_67":68,"_69":70,"_71":72,"_37":219,"_17":32,"_74":75,"_76":220,"_78":50,"_79":-5,"_110":447,"_18":448},{"_35":209,"_13":210,"_63":211,"_65":156,"_67":68,"_69":70,"_71":72,"_37":212,"_17":32,"_74":75,"_76":213,"_78":50,"_79":-5,"_110":445,"_18":446},{"_35":202,"_13":203,"_63":204,"_65":156,"_67":68,"_69":70,"_71":72,"_37":205,"_17":32,"_74":75,"_76":206,"_78":50,"_79":-5,"_110":443,"_18":444},{"_35":195,"_13":196,"_63":197,"_65":156,"_67":68,"_69":70,"_71":72,"_37":198,"_17":32,"_74":75,"_76":199,"_78":50,"_79":-5,"_110":441,"_18":442},{"_35":189,"_13":62,"_63":190,"_65":156,"_67":68,"_69":70,"_71":72,"_37":191,"_17":32,"_74":75,"_76":192,"_78":50,"_79":-5,"_110":439,"_18":440},{"_35":182,"_13":183,"_63":184,"_65":156,"_67":68,"_69":70,"_71":72,"_37":185,"_17":32,"_74":75,"_76":186,"_78":50,"_79":-5,"_110":437,"_18":438},{"_35":175,"_13":176,"_63":177,"_65":156,"_67":68,"_69":70,"_71":72,"_37":178,"_17":32,"_74":75,"_76":179,"_78":50,"_79":-5,"_110":435,"_18":436},{"_35":168,"_13":169,"_63":170,"_65":156,"_67":68,"_69":70,"_71":72,"_37":171,"_17":32,"_74":75,"_76":172,"_78":50,"_79":-5,"_110":433,"_18":434},{"_35":133,"_13":134,"_63":135,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":136,"_17":32,"_74":91,"_76":-5,"_78":50,"_79":-5,"_110":431,"_18":432},{"_35":148,"_13":82,"_63":149,"_65":135,"_67":68,"_69":70,"_71":72,"_37":150,"_17":32,"_74":24,"_76":151,"_78":50,"_79":-5,"_110":429,"_18":430},{"_35":141,"_13":142,"_63":143,"_65":135,"_67":68,"_69":70,"_71":72,"_37":144,"_17":32,"_74":75,"_76":145,"_78":50,"_79":-5,"_110":427,"_18":428},{"_35":127,"_13":82,"_63":128,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":129,"_17":32,"_74":24,"_76":130,"_78":50,"_79":-5,"_110":425,"_18":426},{"_35":120,"_13":121,"_63":122,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":123,"_17":32,"_74":75,"_76":124,"_78":50,"_79":-5,"_110":423,"_18":424},{"_35":113,"_13":114,"_63":115,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":116,"_17":32,"_74":75,"_76":117,"_78":50,"_79":-5,"_110":421,"_18":422},{"_35":104,"_13":105,"_63":106,"_65":-5,"_67":68,"_69":70,"_71":72,"_37":107,"_17":32,"_74":108,"_76":109,"_78":50,"_79":-5,"_110":419,"_18":420},[],[105],[],[114],[],[121],[],[82],[],[134,142],[],[134,82],[413,414],[134],[],[155,169],[],[155,176],[],[155,183],[],[155,62],[],[155,196],[],[155,203],[],[155,210],[],[155,217],[404,405,406,407,408,409,410,411],[155],[],[224,233],[],[224,82],[],[224,246,255],[],[224,246,262],[],[224,246,269],[398,399,400],[224,246],[397,401,402],[224],[],[19,62],[],[19,82],[],[19,88,293],[],[19,88,82],[392,393],[19,88],[391,394,395],[19],["D",1753528401323],{"_11":12,"_347":343},{"_11":12,"_341":-5,"_342":343,"_311":312,"_344":345,"_346":50},{"_17":70,"_13":16,"_35":68,"_41":305,"_44":36,"_45":43,"_338":52,"_339":42,"_340":56,"_57":14,"_53":12},"ctx",{"_332":-5,"_366":514,"_515":516,"_517":518,"_519":50,"_520":50,"_521":50,"_522":72,"_523":-5,"_524":-7,"_525":-7,"_526":32,"_527":50,"_528":50,"_529":-5,"_530":50,"_531":50,"_532":50,"_533":-5},"ENV",{"_485":486,"_487":488,"_489":16,"_490":491,"_492":493,"_494":495,"_496":497,"_498":499,"_500":501,"_502":503,"_504":505,"_506":507,"_508":509,"_510":511,"_512":513},"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"]