Link Not Found

The shortened URL you're looking for doesn't exist or has been removed.

\n \n Go to Homepage\n \n

\n\n",[],[221,214],"frontend","571b5334-13c9-11f0-bbdb-569c3dd06744","index.html","571b53fc-13c9-11f0-bbdb-569c3dd06744",66,["D",1744041591916],"\n\n\n \n \n Link Shortener\n \n \n \n \n\n\n

Link Shortener

Create short, memorable links for your long URLs

\n\n

\n \n

\n \n\n \n

Your shortened URL:

\n \n \n

\n\n \n

Recent Links

Loading recent links...

\n \n

\n\n \n

\n\n",[],[221,223],"571b5e74-13c9-11f0-bbdb-569c3dd06744",["D",1744041591916],[185,186],[221],["D",1744041545741],[],[18,65],"478cbff2-13c9-11f0-8b5b-569c3dd06744","queries.ts","478cc1c8-13c9-11f0-8b5b-569c3dd06744",["D",1744041565818],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { parseProject } from \"https://esm.town/v/std/utils@71-main/index.ts\";\n\n// Get project info to create a unique table name\nconst projectInfo = parseProject(import.meta.url);\nconst TABLE_NAME = `url_shortener_${projectInfo.username}_${projectInfo.name}`.replace(/[^a-zA-Z0-9_]/g, \"_\");\n\n// URL record type\nexport interface UrlRecord {\n id: number;\n shortCode: string;\n originalUrl: string;\n createdAt: string;\n visits: number;\n lastVisit: string | null;\n}\n\n// Create the database table\nexport async function createTable(): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n short_code TEXT NOT NULL UNIQUE,\n original_url TEXT NOT NULL,\n created_at TEXT NOT NULL,\n visits INTEGER DEFAULT 0,\n last_visit TEXT\n )\n `);\n \n // Create an index on short_code for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_${TABLE_NAME}_short_code \n ON ${TABLE_NAME} (short_code)\n `);\n}\n\n// Save a new URL\nexport async function saveUrl(shortCode: string, originalUrl: string): Promise {\n const now = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (short_code, original_url, created_at) \n VALUES (?, ?, ?)`,\n [shortCode, originalUrl, now]\n );\n}\n\n// Get the original URL for a short code and increment visit count\nexport async function getOriginalUrl(shortCode: string): Promise {\n // First, get the original URL\n const result = await sqlite.execute(\n `SELECT original_url FROM ${TABLE_NAME} WHERE short_code = ?`,\n [shortCode]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n // Update visit count and last visit timestamp\n const now = new Date().toISOString();\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} \n SET visits = visits + 1, last_visit = ? \n WHERE short_code = ?`,\n [now, shortCode]\n );\n \n return result.rows[0].original_url;\n}\n\n// Get stats for a URL\nexport async function getUrlStats(shortCode: string): Promise {\n const result = await sqlite.execute(\n `SELECT \n id,\n short_code as shortCode,\n original_url as originalUrl,\n created_at as createdAt,\n visits,\n last_visit as lastVisit\n FROM ${TABLE_NAME} \n WHERE short_code = ?`,\n [shortCode]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n return result.rows[0] as UrlRecord;\n}\n\n// List all URLs with pagination\nexport async function listUrls(limit: number = 10, offset: number = 0): Promise {\n const result = await sqlite.execute(\n `SELECT \n id,\n short_code as shortCode,\n original_url as originalUrl,\n created_at as createdAt,\n visits,\n last_visit as lastVisit\n FROM ${TABLE_NAME} \n ORDER BY created_at DESC\n LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n \n return result.rows as UrlRecord[];\n}",[],[18,80,238],["D",1744041565818],[182],[18,80],["D",1744041545741],[181,183],[18],["D",1744033141535],{"_11":12,"_131":71},{"_11":12,"_127":-5,"_70":71,"_31":69,"_128":129,"_130":30},{"_40":118,"_13":16,"_34":37,"_119":84,"_120":-5,"_121":-5,"_122":-5,"_123":-5,"_124":-5,"_125":14,"_126":12},"ctx",{"_53":-5,"_150":287,"_288":289,"_290":291,"_292":30,"_293":30,"_294":30,"_295":24,"_296":-5,"_297":-7,"_298":-7,"_299":26,"_300":30,"_301":30,"_302":-5,"_303":30,"_304":30,"_305":30,"_306":-5},"ENV",{"_258":259,"_260":261,"_262":16,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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"]

History · backend