[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_350":351,"_352":353},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_260":-5,"_20":261,"_22":262,"_263":264,"_265":266,"_26":267,"_24":268,"_269":-5,"_270":-5,"_271":55,"_272":273,"_274":46,"_275":-5,"_276":-5,"_277":278},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","loading","name","wondrousCyanRodent","branchName","main","version","path","shared","project",{"_34":207,"_13":14,"_47":208,"_209":-5,"_210":55,"_211":212,"_213":212,"_214":-5,"_215":-5,"_216":217,"_218":69,"_219":46,"_220":-5,"_221":70,"_222":49,"_223":224,"_225":-5,"_226":-5,"_227":-5,"_228":-5,"_229":230,"_231":230,"_232":233,"_234":233,"_235":233,"_236":230,"_237":230,"_238":239,"_240":241,"_242":243,"_244":55},"tree",[62,63,64,65,66],"file",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":59,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_18":61},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","35352cae-13c4-11f0-b5ff-569c3dd06744","types.ts","fileId","35352d80-13c4-11f0-b5ff-569c3dd06744","parentId","1e069ae4-6a24-4338-9f02-a86f3a57470b","branchId","deebde02-13c2-11f0-a341-569c3dd06744","branchVersion",4,"latest",true,"createdAt",["D",1744039387561],0,"fileType","script","content","// Link data structure\nexport interface Link {\n id: number;\n shortId: string;\n originalUrl: string;\n createdAt: number;\n clickCount: number;\n}\n\n// Request to create a new link\nexport interface CreateLinkRequest {\n originalUrl: string;\n customShortId?: string;\n}\n\n// Response for link creation\nexport interface CreateLinkResponse {\n success: boolean;\n link?: Link;\n error?: string;\n}\n\n// Response for getting all links\nexport interface GetLinksResponse {\n links: Link[];\n}","deleted",false,"label",[19,36],"3535347e-13c4-11f0-b5ff-569c3dd06744",["D",1744039387561],"directory",[19],{"_34":168,"_13":169,"_37":170,"_39":-5,"_41":42,"_43":171,"_45":46,"_47":172,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":173,"_18":174},{"_34":93,"_13":94,"_37":95,"_39":-5,"_41":42,"_43":96,"_45":46,"_47":97,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":98,"_18":99},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":86,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":87,"_18":88},{"_34":78,"_13":79,"_37":80,"_39":-5,"_41":42,"_43":81,"_45":46,"_47":82,"_17":49,"_50":24,"_52":83,"_54":55,"_56":-5,"_75":84,"_18":85},{"_34":67,"_13":68,"_37":69,"_39":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":73,"_52":74,"_54":55,"_56":-5,"_75":76,"_18":77},"e6046fa4-13c4-11f0-b1d8-569c3dd06744","index.ts","e3ca705a-13c2-11f0-9f02-569c3dd06744",20,["D",1744039684197],7,"http","// Re-export the backend app\nimport data from \"./backend/index.ts\";\n\nconsole.log(data);\n\nexport default data;","children",[],[68],"7d2821c4-13c4-11f0-a808-569c3dd06744","README.md","7d2822a0-13c4-11f0-a808-569c3dd06744",14,["D",1744039508273],"# Link Shortener\n\nA simple and fast link shortener service built with React Router 7 and Hono on Val Town.\n\n## Features\n\n- Create shortened links with custom or auto-generated IDs\n- Track click counts for each shortened link\n- Responsive design with Tailwind CSS\n- Client-side routing with React Router 7\n- SQLite database for persistent storage\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database operations\n│ └── index.ts # Hono API server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main React component with routing\n│ │ ├── CreateLink.tsx # Form to create short links\n│ │ ├── LinkList.tsx # List of created links\n│ │ └── NotFound.tsx # 404 page\n│ ├── favicon.svg # Site favicon\n│ ├── index.html # HTML template\n│ └── index.tsx # React entry point\n├── index.ts # Entry point that exports the backend\n└── shared/\n └── types.ts # Shared TypeScript interfaces\n```\n\n## Technologies Used\n\n- **Frontend**:\n - React 18.2.0\n - React Router 7\n - Tailwind CSS (via CDN)\n \n- **Backend**:\n - Hono (lightweight web framework)\n - SQLite (via Val Town's SQLite API)\n \n- **Other**:\n - TypeScript\n - nanoid for generating short IDs\n\n## How It Works\n\n1. Users enter a URL to shorten (with optional custom short ID)\n2. The backend creates a new entry in the SQLite database\n3. When someone visits the shortened URL, the backend:\n - Looks up the original URL in the database\n - Increments the click counter\n - Redirects to the original URL\n4. The frontend displays statistics for all created links\n\n## Development\n\nThis project is designed to run on Val Town. The code is organized to separate concerns between frontend and backend while sharing common types.\n\n## License\n\nMIT",[],[79],["D",1744039387561],[89],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":90,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_75":91,"_18":92},["D",1744039387561],[],[19,36],"41e3a9c6-13c4-11f0-a306-569c3dd06744","frontend","de090c94-a8d0-4cf6-ac06-706facff5a92",6,["D",1744039408833],[100,101,102,103],[94],{"_34":126,"_13":127,"_37":128,"_39":95,"_41":42,"_43":129,"_45":46,"_47":130,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":131,"_18":132},{"_34":119,"_13":120,"_37":121,"_39":95,"_41":42,"_43":72,"_45":46,"_47":122,"_17":49,"_50":24,"_52":123,"_54":55,"_56":-5,"_75":124,"_18":125},{"_34":112,"_13":113,"_37":114,"_39":95,"_41":42,"_43":96,"_45":46,"_47":115,"_17":49,"_50":24,"_52":116,"_54":55,"_56":-5,"_75":117,"_18":118},{"_34":104,"_13":105,"_37":106,"_39":95,"_41":42,"_43":107,"_45":46,"_47":108,"_17":49,"_50":51,"_52":109,"_54":55,"_56":-5,"_75":110,"_18":111},"6e17a8b2-13c4-11f0-bce8-569c3dd06744","index.tsx","6e17a97a-13c4-11f0-bce8-569c3dd06744",12,["D",1744039482995],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { StrictMode } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst rootElement = document.getElementById(\"root\");\nif (!rootElement) throw new Error(\"Root element not found\");\n\nconst root = createRoot(rootElement);\nroot.render(\n \n \n \n);",[],[94,105],"41e3a23c-13c4-11f0-a306-569c3dd06744","index.html","41e3a322-13c4-11f0-a306-569c3dd06744",["D",1744039408833],"\n\n\n \n \n Link Shortener\n \n \n \n \n\n\n

\n \n\n",[],[94,113],"44f6b78e-13c4-11f0-a419-569c3dd06744","favicon.svg","44f6b860-13c4-11f0-a419-569c3dd06744",["D",1744039413996],"",[],[94,120],"4ed588de-13c4-11f0-b944-569c3dd06744","components","03b7444d-30e6-482b-8b3e-dd6be0702b1b",8,["D",1744039430553],[133,134,135,136],[94,127],{"_34":160,"_13":161,"_37":162,"_39":128,"_41":42,"_43":163,"_45":46,"_47":164,"_17":49,"_50":51,"_52":165,"_54":55,"_56":-5,"_75":166,"_18":167},{"_34":153,"_13":154,"_37":155,"_39":128,"_41":42,"_43":129,"_45":46,"_47":156,"_17":49,"_50":51,"_52":157,"_54":55,"_56":-5,"_75":158,"_18":159},{"_34":145,"_13":146,"_37":147,"_39":128,"_41":42,"_43":148,"_45":46,"_47":149,"_17":49,"_50":51,"_52":150,"_54":55,"_56":-5,"_75":151,"_18":152},{"_34":137,"_13":138,"_37":139,"_39":128,"_41":42,"_43":140,"_45":46,"_47":141,"_17":49,"_50":51,"_52":142,"_54":55,"_56":-5,"_75":143,"_18":144},"5c2f0578-13c4-11f0-b944-569c3dd06744","NotFound.tsx","5c2f0622-13c4-11f0-b944-569c3dd06744",10,["D",1744039452949],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { Link } from \"https://esm.sh/react-router-dom@7.0.0-rc.0?deps=react@18.2.0,react-dom@18.2.0\";\n\nexport function NotFound() {\n return (\n

Link Not Found

\n The short link you're looking for doesn't exist or has been removed.\n

\n \n Go to Homepage\n \n

\n );\n}",[],[94,127,138],"57b8d442-13c4-11f0-856e-569c3dd06744","LinkList.tsx","57b8d532-13c4-11f0-856e-569c3dd06744",9,["D",1744039445464],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"../../shared/types.ts\";\n\ninterface LinkListProps {\n links: Link[];\n}\n\nexport function LinkList({ links }: LinkListProps) {\n const [copiedId, setCopiedId] = useState(null);\n \n if (links.length === 0) {\n return (\n

No links created yet. Create your first link above!

\n );\n }\n\n const copyToClipboard = async (shortId: string) => {\n const shortUrl = `${window.location.origin}/${shortId}`;\n \n try {\n await navigator.clipboard.writeText(shortUrl);\n setCopiedId(shortId);\n \n // Reset the copied state after 2 seconds\n setTimeout(() => {\n setCopiedId(null);\n }, 2000);\n } catch (err) {\n console.error(\"Failed to copy:\", err);\n }\n };\n\n const formatDate = (timestamp: number) => {\n return new Date(timestamp).toLocaleString();\n };\n\n return (\n

Your Links

\n \n

\n \n \n \n \n \n \n \n \n \n \n \n {links.map((link) => (\n \n \n \n \n \n \n \n ))}\n \n

\n Short URL\n	\n Original URL\n	\n Created\n	\n Clicks\n	\n Actions\n
\n \n {window.location.origin}/{link.shortId}\n \n	\n \n \n {link.originalUrl}\n \n \n	\n {formatDate(link.createdAt)}\n	\n {link.clickCount}\n	\n copyToClipboard(link.shortId)}\n className=\"text-blue-600 hover:text-blue-800\"\n >\n {copiedId === link.shortId ? \"Copied!\" : \"Copy\"}\n \n

\n );\n}",[],[94,127,146],"4ed57a6a-13c4-11f0-b944-569c3dd06744","CreateLink.tsx","4ed57b50-13c4-11f0-b944-569c3dd06744",["D",1744039430553],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { Link } from \"../../shared/types.ts\";\n\ninterface CreateLinkProps {\n onLinkCreated: (link: Link) => void;\n}\n\nexport function CreateLink({ onLinkCreated }: CreateLinkProps) {\n const [url, setUrl] = useState(\"\");\n const [customShortId, setCustomShortId] = useState(\"\");\n const [isLoading, setIsLoading] = useState(false);\n const [error, setError] = useState(\"\");\n const [showAdvanced, setShowAdvanced] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n \n if (!url) {\n setError(\"Please enter a URL\");\n return;\n }\n \n setIsLoading(true);\n \n try {\n const response = await fetch(\"/api/links\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({\n originalUrl: url,\n customShortId: customShortId || undefined,\n }),\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || \"Failed to create short link\");\n }\n \n if (data.success && data.link) {\n onLinkCreated(data.link);\n setUrl(\"\");\n setCustomShortId(\"\");\n setShowAdvanced(false);\n } else {\n throw new Error(\"Something went wrong\");\n }\n } catch (err) {\n setError(err.message);\n } finally {\n setIsLoading(false);\n }\n };\n\n return (\n

Shorten a URL

\n \n

\n \n URL to shorten\n \n setUrl(e.target.value)}\n placeholder=\"https://example.com/very/long/url\"\n className=\"w-full px-4 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n required\n />\n

\n \n

\n setShowAdvanced(!showAdvanced)}\n className=\"text-sm text-blue-600 hover:text-blue-800\"\n >\n {showAdvanced ? \"Hide advanced options\" : \"Show advanced options\"}\n \n

\n \n {showAdvanced && (\n

\n \n Custom short ID (optional)\n \n setCustomShortId(e.target.value)}\n placeholder=\"custom-name\"\n className=\"w-full px-4 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Leave empty to generate a random ID\n

\n )}\n \n {error && (\n

\n {error}\n

\n )}\n \n \n {isLoading ? \"Creating...\" : \"Create Short Link\"}\n \n \n

\n );\n}",[],[94,127,154],"6a8bb918-13c4-11f0-886f-569c3dd06744","App.tsx","6a8bb9c2-13c4-11f0-886f-569c3dd06744",11,["D",1744039477049],"// @jsxImportSource https://esm.sh/react@18.2.0\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { \n createBrowserRouter, \n RouterProvider, \n Route, \n createRoutesFromElements,\n Outlet,\n Link as RouterLink,\n useParams,\n useNavigate\n} from \"https://esm.sh/react-router-dom@7.0.0-rc.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport { CreateLink } from \"./CreateLink.tsx\";\nimport { LinkList } from \"./LinkList.tsx\";\nimport { NotFound } from \"./NotFound.tsx\";\nimport { Link } from \"../../shared/types.ts\";\n\n// Layout component with header and footer\nfunction Layout() {\n return (\n

\n \n \n Link Shortener\n \n \n

\n \n

\n \n \n

\n );\n}\n\n// Home page component\nfunction HomePage() {\n const [links, setLinks] = useState([]);\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(\"\");\n\n const fetchLinks = async () => {\n try {\n setIsLoading(true);\n const response = await fetch(\"/api/links\");\n \n if (!response.ok) {\n throw new Error(\"Failed to fetch links\");\n }\n \n const data = await response.json();\n setLinks(data.links || []);\n } catch (err) {\n setError(\"Failed to load links. Please try again later.\");\n console.error(err);\n } finally {\n setIsLoading(false);\n }\n };\n\n useEffect(() => {\n fetchLinks();\n }, []);\n\n const handleLinkCreated = (newLink: Link) => {\n setLinks([newLink, ...links]);\n };\n\n return (\n

\n \n \n {isLoading ? (\n

Loading links...

\n ) : error ? (\n

\n {error}\n

\n ) : (\n \n )}\n

\n );\n}\n\n// Redirect component\nfunction RedirectPage() {\n const { shortId } = useParams<{ shortId: string }>();\n const navigate = useNavigate();\n const [isLoading, setIsLoading] = useState(true);\n const [error, setError] = useState(\"\");\n\n useEffect(() => {\n const checkLink = async () => {\n try {\n if (!shortId) {\n navigate(\"/not-found\");\n return;\n }\n\n const response = await fetch(`/api/links/${shortId}`);\n \n if (!response.ok) {\n navigate(\"/not-found\");\n return;\n }\n \n // If we get here, the backend should have already redirected us\n // This is just a fallback\n setError(\"Redirect failed. Please try again.\");\n } catch (err) {\n setError(\"Something went wrong. Please try again.\");\n } finally {\n setIsLoading(false);\n }\n };\n\n checkLink();\n }, [shortId, navigate]);\n\n if (isLoading) {\n return (\n

Redirecting...

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

\n {error}\n

\n \n Go to Homepage\n \n

\n );\n }\n\n return null;\n}\n\n// Create the router\nconst router = createBrowserRouter(\n createRoutesFromElements(\n }>\n } />\n } />\n } />\n } />\n \n )\n);\n\n// Main App component\nexport function App() {\n return ;\n}",[],[94,127,161],"2cd51dbc-13c4-11f0-a750-569c3dd06744","backend","0b20952e-e790-4707-a773-e8c979d5f61c",2,["D",1744039373508],[175,176],[169],{"_34":184,"_13":185,"_37":186,"_39":170,"_41":42,"_43":171,"_45":46,"_47":187,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":188,"_18":189},{"_34":177,"_13":68,"_37":178,"_39":170,"_41":42,"_43":179,"_45":46,"_47":180,"_17":49,"_50":51,"_52":181,"_54":55,"_56":-5,"_75":182,"_18":183},"3ea4ecd4-13c4-11f0-bc34-569c3dd06744","3ea4ed92-13c4-11f0-bc34-569c3dd06744",5,["D",1744039403395],"import { Hono } from \"https://esm.sh/hono@3.12.0\";\nimport { cors } from \"https://esm.sh/hono@3.12.0/cors\";\nimport { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { setupDatabase } from \"./database/migrations.ts\";\nimport { \n createLink, \n getLinkByShortId, \n incrementClickCount, \n getAllLinks \n} from \"./database/queries.ts\";\nimport { CreateLinkRequest } from \"../shared/types.ts\";\n\n// Initialize the app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Error:\", err);\n throw err;\n});\n\n// Add CORS middleware\napp.use(\"/*\", cors());\n\n// Setup the database on startup\napp.use(\"*\", async (c, next) => {\n try {\n await setupDatabase();\n } catch (error) {\n console.error(\"Database setup error:\", error);\n }\n return next();\n});\n\n// API routes\napp.post(\"/api/links\", async (c) => {\n try {\n const body = await c.req.json() as CreateLinkRequest;\n \n if (!body.originalUrl) {\n return c.json({ success: false, error: \"Original URL is required\" }, 400);\n }\n \n // Validate URL format\n try {\n new URL(body.originalUrl);\n } catch (error) {\n return c.json({ success: false, error: \"Invalid URL format\" }, 400);\n }\n \n const link = await createLink(body.originalUrl, body.customShortId);\n return c.json({ success: true, link });\n } catch (error) {\n return c.json({ success: false, error: error.message }, 400);\n }\n});\n\napp.get(\"/api/links\", async (c) => {\n try {\n const links = await getAllLinks();\n return c.json({ links });\n } catch (error) {\n return c.json({ success: false, error: error.message }, 500);\n }\n});\n\n// Redirect route\napp.get(\"/:shortId\", async (c) => {\n const shortId = c.req.param(\"shortId\");\n \n // Skip API routes and static files\n if (shortId.startsWith(\"api\") || shortId.startsWith(\"public\")) {\n return c.next();\n }\n \n try {\n const link = await getLinkByShortId(shortId);\n \n if (!link) {\n // If no link found, serve the frontend with the 404 state\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n }\n \n // Increment click count asynchronously\n incrementClickCount(shortId).catch(console.error);\n \n // Redirect to the original URL\n return new Response(null, {\n status: 302,\n headers: { Location: link.originalUrl }\n });\n } catch (error) {\n console.error(\"Redirect error:\", error);\n return c.text(\"Server error\", 500);\n }\n});\n\n// Serve static files\napp.get(\"/public/*\", (c) => {\n return serveFile(c.req.path.replace(\"/public\", \"/frontend\"), import.meta.url);\n});\n\n// Serve the frontend for all other routes\napp.get(\"*\", async (c) => {\n try {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving frontend:\", error);\n return c.text(\"Server error\", 500);\n }\n});\n\n// Export the app for Val Town\nexport default app.fetch;",[],[169,68],"2cd51f9c-13c4-11f0-a750-569c3dd06744","database","c0945900-7eed-4789-b775-8f502181b48b",["D",1744039373508],[190,191],[169,185],{"_34":200,"_13":201,"_37":202,"_39":186,"_41":42,"_43":171,"_45":46,"_47":203,"_17":49,"_50":51,"_52":204,"_54":55,"_56":-5,"_75":205,"_18":206},{"_34":192,"_13":193,"_37":194,"_39":186,"_41":42,"_43":195,"_45":46,"_47":196,"_17":49,"_50":51,"_52":197,"_54":55,"_56":-5,"_75":198,"_18":199},"3310d11c-13c4-11f0-a7db-569c3dd06744","queries.ts","3310d1a8-13c4-11f0-a7db-569c3dd06744",3,["D",1744039383966],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { LINKS_TABLE } from \"./migrations.ts\";\nimport { Link } from \"../../shared/types.ts\";\nimport { nanoid } from \"https://esm.sh/nanoid@4.0.2\";\n\n// Generate a short ID for the URL\nexport function generateShortId(length = 6): string {\n return nanoid(length);\n}\n\n// Create a new shortened link\nexport async function createLink(originalUrl: string, customShortId?: string): Promise {\n const shortId = customShortId || generateShortId();\n const createdAt = Date.now();\n \n try {\n await sqlite.execute(\n `INSERT INTO ${LINKS_TABLE} (short_id, original_url, created_at) VALUES (?, ?, ?)`,\n [shortId, originalUrl, createdAt]\n );\n \n return {\n id: 0, // SQLite will assign the actual ID\n shortId,\n originalUrl,\n createdAt,\n clickCount: 0\n };\n } catch (error) {\n // Handle duplicate short_id error\n if (error.message.includes('UNIQUE constraint failed')) {\n throw new Error('This short ID is already in use. Please try another one.');\n }\n throw error;\n }\n}\n\n// Get a link by its short ID\nexport async function getLinkByShortId(shortId: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, short_id, original_url, created_at, click_count FROM ${LINKS_TABLE} WHERE short_id = ?`,\n [shortId]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n return {\n id: row[0] as number,\n shortId: row[1] as string,\n originalUrl: row[2] as string,\n createdAt: row[3] as number,\n clickCount: row[4] as number\n };\n}\n\n// Increment the click count for a link\nexport async function incrementClickCount(shortId: string): Promise {\n await sqlite.execute(\n `UPDATE ${LINKS_TABLE} SET click_count = click_count + 1 WHERE short_id = ?`,\n [shortId]\n );\n}\n\n// Get all links\nexport async function getAllLinks(): Promise {\n const result = await sqlite.execute(\n `SELECT id, short_id, original_url, created_at, click_count FROM ${LINKS_TABLE} ORDER BY created_at DESC`\n );\n \n return result.rows.map(row => ({\n id: row[0] as number,\n shortId: row[1] as string,\n originalUrl: row[2] as string,\n createdAt: row[3] as number,\n clickCount: row[4] as number\n }));\n}",[],[169,185,193],"2cd51498-13c4-11f0-a750-569c3dd06744","migrations.ts","2cd5156a-13c4-11f0-a750-569c3dd06744",["D",1744039373508],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table name with version to allow for schema changes\nexport const LINKS_TABLE = 'link_shortener_links_v1';\n\nexport async function setupDatabase() {\n // Create the links table if it doesn't exist\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${LINKS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n short_id TEXT NOT NULL UNIQUE,\n original_url TEXT NOT NULL,\n created_at INTEGER NOT NULL,\n click_count INTEGER DEFAULT 0\n )\n `);\n \n // Create an index on short_id for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${LINKS_TABLE}_short_id ON ${LINKS_TABLE} (short_id)\n `);\n}",[],[169,185,201],"deeb460e-13c2-11f0-a341-569c3dd06744",["D",1744038813299],"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,"_259":255},"org",{"_11":12,"_253":-5,"_254":255,"_216":217,"_256":257,"_258":55},"branch",{"_17":70,"_13":16,"_34":42,"_245":207,"_246":-5,"_247":-5,"_248":-5,"_249":-5,"_250":-5,"_251":14,"_252":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTFCT2UzVDJHbzF6RjhPTnpBd3p6VEJHZEQifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":207,"_13":14,"_47":346,"_209":-5,"_210":55,"_211":212,"_213":212,"_214":-5,"_215":-5,"_216":217,"_218":69,"_219":46,"_220":-5,"_221":70,"_222":49,"_223":224,"_225":-5,"_226":-5,"_227":-5,"_228":-5,"_229":230,"_231":230,"_232":233,"_234":233,"_235":233,"_236":230,"_237":230,"_238":347,"_240":348,"_242":349,"_244":55},[292,297,306,308,309],"files",[292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309],"counts",{"_282":49,"_283":284,"_285":49,"_32":286,"_287":288},[280],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":59,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_18":279},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":281},[19,36],"pulls","branches",1,"forks",{"_289":49,"_291":49},"connections",{"_289":49,"_290":49},"count","unfilledCount","emptyCount",{"_34":168,"_13":169,"_37":170,"_39":-5,"_41":42,"_43":171,"_45":46,"_47":172,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":344,"_18":345},{"_34":184,"_13":185,"_37":186,"_39":170,"_41":42,"_43":171,"_45":46,"_47":187,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":342,"_18":343},{"_34":200,"_13":201,"_37":202,"_39":186,"_41":42,"_43":171,"_45":46,"_47":203,"_17":49,"_50":51,"_52":204,"_54":55,"_56":-5,"_75":340,"_18":341},{"_34":192,"_13":193,"_37":194,"_39":186,"_41":42,"_43":195,"_45":46,"_47":196,"_17":49,"_50":51,"_52":197,"_54":55,"_56":-5,"_75":338,"_18":339},{"_34":177,"_13":68,"_37":178,"_39":170,"_41":42,"_43":179,"_45":46,"_47":180,"_17":49,"_50":51,"_52":181,"_54":55,"_56":-5,"_75":336,"_18":337},{"_34":93,"_13":94,"_37":95,"_39":-5,"_41":42,"_43":96,"_45":46,"_47":97,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":334,"_18":335},{"_34":126,"_13":127,"_37":128,"_39":95,"_41":42,"_43":129,"_45":46,"_47":130,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":332,"_18":333},{"_34":160,"_13":161,"_37":162,"_39":128,"_41":42,"_43":163,"_45":46,"_47":164,"_17":49,"_50":51,"_52":165,"_54":55,"_56":-5,"_75":330,"_18":331},{"_34":153,"_13":154,"_37":155,"_39":128,"_41":42,"_43":129,"_45":46,"_47":156,"_17":49,"_50":51,"_52":157,"_54":55,"_56":-5,"_75":328,"_18":329},{"_34":145,"_13":146,"_37":147,"_39":128,"_41":42,"_43":148,"_45":46,"_47":149,"_17":49,"_50":51,"_52":150,"_54":55,"_56":-5,"_75":326,"_18":327},{"_34":137,"_13":138,"_37":139,"_39":128,"_41":42,"_43":140,"_45":46,"_47":141,"_17":49,"_50":51,"_52":142,"_54":55,"_56":-5,"_75":324,"_18":325},{"_34":119,"_13":120,"_37":121,"_39":95,"_41":42,"_43":72,"_45":46,"_47":122,"_17":49,"_50":24,"_52":123,"_54":55,"_56":-5,"_75":322,"_18":323},{"_34":112,"_13":113,"_37":114,"_39":95,"_41":42,"_43":96,"_45":46,"_47":115,"_17":49,"_50":24,"_52":116,"_54":55,"_56":-5,"_75":320,"_18":321},{"_34":104,"_13":105,"_37":106,"_39":95,"_41":42,"_43":107,"_45":46,"_47":108,"_17":49,"_50":51,"_52":109,"_54":55,"_56":-5,"_75":318,"_18":319},{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":44,"_45":46,"_47":86,"_17":49,"_50":60,"_52":-5,"_54":55,"_56":-5,"_75":316,"_18":317},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":90,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_75":314,"_18":315},{"_34":78,"_13":79,"_37":80,"_39":-5,"_41":42,"_43":81,"_45":46,"_47":82,"_17":49,"_50":24,"_52":83,"_54":55,"_56":-5,"_75":312,"_18":313},{"_34":67,"_13":68,"_37":69,"_39":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":73,"_52":74,"_54":55,"_56":-5,"_75":310,"_18":311},[],[68],[],[79],[],[19,36],[307],[19],[],[94,105],[],[94,113],[],[94,120],[],[94,127,138],[],[94,127,146],[],[94,127,154],[],[94,127,161],[299,300,301,302],[94,127],[298,303,304,305],[94],[],[169,68],[],[169,185,193],[],[169,185,201],[294,295],[169,185],[293,296],[169],["D",1744038813299],{"_11":12,"_259":255},{"_11":12,"_253":-5,"_254":255,"_216":217,"_256":257,"_258":55},{"_17":70,"_13":16,"_34":42,"_245":207,"_246":-5,"_247":-5,"_248":-5,"_249":-5,"_250":-5,"_251":14,"_252":12},"ctx",{"_238":-5,"_276":383,"_384":385,"_386":387,"_388":55,"_389":55,"_390":55,"_391":46,"_392":-5,"_393":-7,"_394":-7,"_395":49,"_396":55,"_397":55,"_398":-5,"_399":55,"_400":55,"_401":55,"_402":-5},"ENV",{"_354":355,"_356":357,"_358":16,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380,"_381":382},"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"]