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",[],[98,107],"571b5334-13c9-11f0-bbdb-569c3dd06744","index.html","571b53fc-13c9-11f0-bbdb-569c3dd06744",["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",[],[98,115],["D",1744041545741],[124,125],[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":129,"_17":50,"_51":64,"_53":-5,"_55":56,"_57":-5,"_79":130,"_18":131},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":126,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_79":127,"_18":128},["D",1744041545741],[],[19,37],["D",1744041565818],[132],[19,60],{"_35":133,"_13":134,"_38":135,"_40":61,"_42":43,"_44":62,"_46":47,"_48":136,"_17":50,"_51":52,"_53":137,"_55":56,"_57":-5,"_79":138,"_18":139},"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}",[],[19,60,134],"aa487f32-13b5-11f0-85ee-569c3dd06744",["D",1744033141535],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","c7d91915-4070-4350-8e28-6c792ff73b1c","pinnedFileId","pinPreview","pinMigrated","screenshotVersion",61,"likeCount","orgId","9ee5b56c-6e87-47cb-98e4-c31219468b31","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_193":189},"org",{"_11":12,"_187":-5,"_188":189,"_149":150,"_190":191,"_192":56},"branch",{"_17":109,"_13":16,"_35":43,"_179":140,"_180":-5,"_181":-5,"_182":-5,"_183":-5,"_184":-5,"_185":14,"_186":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTFCT2UzVDJHbzF6RjhPTnpBd3p6VEJHZEQifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":140,"_13":14,"_48":258,"_142":-5,"_143":56,"_144":145,"_146":145,"_147":-5,"_148":-5,"_149":150,"_151":-5,"_152":47,"_153":-5,"_154":155,"_156":50,"_157":158,"_159":-5,"_160":-5,"_161":-5,"_162":-5,"_163":164,"_165":164,"_166":167,"_168":167,"_169":167,"_170":164,"_171":164,"_172":259,"_174":260,"_176":261,"_178":56},[228,232,235,237],"files",[228,229,230,231,232,233,234,235,236,237],"counts",{"_218":50,"_219":220,"_221":50,"_32":222,"_223":224},[214,215],{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":45,"_46":47,"_48":67,"_17":50,"_51":64,"_53":-5,"_55":56,"_57":-5,"_18":213},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":63,"_17":50,"_51":64,"_53":-5,"_55":56,"_57":-5,"_18":217},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":216},[19,37],[19,60],"pulls","branches",1,"forks",{"_225":50,"_227":50},"connections",{"_225":50,"_226":50},"count","unfilledCount","emptyCount",{"_35":66,"_13":19,"_38":41,"_40":-5,"_42":43,"_44":45,"_46":47,"_48":121,"_17":50,"_51":64,"_53":-5,"_55":56,"_57":-5,"_79":256,"_18":257},{"_35":59,"_13":60,"_38":61,"_40":41,"_42":43,"_44":62,"_46":47,"_48":129,"_17":50,"_51":64,"_53":-5,"_55":56,"_57":-5,"_79":254,"_18":255},{"_35":133,"_13":134,"_38":135,"_40":61,"_42":43,"_44":62,"_46":47,"_48":136,"_17":50,"_51":52,"_53":137,"_55":56,"_57":-5,"_79":252,"_18":253},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":126,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_79":250,"_18":251},{"_35":97,"_13":98,"_38":99,"_40":-5,"_42":43,"_44":100,"_46":47,"_48":101,"_17":50,"_51":64,"_53":-5,"_55":56,"_57":-5,"_79":248,"_18":249},{"_35":114,"_13":115,"_38":116,"_40":99,"_42":43,"_44":100,"_46":47,"_48":117,"_17":50,"_51":24,"_53":118,"_55":56,"_57":-5,"_79":246,"_18":247},{"_35":106,"_13":107,"_38":108,"_40":99,"_42":43,"_44":109,"_46":47,"_48":110,"_17":50,"_51":24,"_53":111,"_55":56,"_57":-5,"_79":244,"_18":245},{"_35":82,"_13":83,"_38":84,"_40":-5,"_42":43,"_44":85,"_46":47,"_48":86,"_17":50,"_51":64,"_53":-5,"_55":56,"_57":-5,"_79":242,"_18":243},{"_35":90,"_13":91,"_38":92,"_40":84,"_42":43,"_44":85,"_46":47,"_48":93,"_17":50,"_51":52,"_53":94,"_55":56,"_57":-5,"_79":240,"_18":241},{"_35":73,"_13":74,"_38":75,"_40":-5,"_42":43,"_44":76,"_46":47,"_48":77,"_17":50,"_51":24,"_53":78,"_55":56,"_57":-5,"_79":238,"_18":239},[],[74],[],[83,91],[236],[83],[],[98,107],[],[98,115],[233,234],[98],[],[19,37],[],[19,60,134],[230],[19,60],[229,231],[19],["D",1744033141535],{"_11":12,"_193":189},{"_11":12,"_187":-5,"_188":189,"_149":150,"_190":191,"_192":56},{"_17":109,"_13":16,"_35":43,"_179":140,"_180":-5,"_181":-5,"_182":-5,"_183":-5,"_184":-5,"_185":14,"_186":12},"ctx",{"_172":-5,"_210":295,"_296":297,"_298":299,"_300":56,"_301":56,"_302":56,"_303":47,"_304":-5,"_305":-7,"_306":-7,"_307":50,"_308":56,"_309":56,"_310":-5,"_311":56,"_312":56,"_313":56,"_314":-5},"ENV",{"_266":267,"_268":269,"_270":16,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294},"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"]