🔗 Short URL Generator

\n setLongUrl(e.target.value)}\n placeholder=\"Enter long URL here\"\n style={{\n width: '100%', \n padding: '10px', \n marginBottom: '10px'\n }}\n />\n \n {error && (\n

{error}

\n )}\n {shortUrl && (\n

\n \n \n

\n )}\n {copyStatus && (\n

\n {copyStatus}\n

\n )}\n

\n \n View Source\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"shorturl\";\n const SCHEMA_VERSION = 2;\n\n // Create URLs table if not exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_urls_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n short_code TEXT UNIQUE NOT NULL,\n long_url TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Handle URL generation\n if (request.method === 'POST') {\n const { longUrl } = await request.json();\n \n // Validate URL\n try {\n new URL(longUrl);\n } catch {\n return new Response(JSON.stringify({ error: 'Invalid URL' }), {\n status: 400,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n const shortCode = generateShortCode();\n const baseUrl = new URL(request.url).origin;\n const shortUrl = `${baseUrl}/${shortCode}`;\n\n await sqlite.execute(\n `INSERT INTO ${KEY}_urls_${SCHEMA_VERSION} (short_code, long_url) VALUES (?, ?)`, \n [shortCode, longUrl]\n );\n\n return new Response(JSON.stringify({ shortUrl }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Handle redirection\n if (request.method === 'GET') {\n const shortCode = new URL(request.url).pathname.slice(1);\n \n if (shortCode) {\n const result = await sqlite.execute(\n `SELECT long_url FROM ${KEY}_urls_${SCHEMA_VERSION} WHERE short_code = ?`, \n [shortCode]\n );\n\n if (result.rows.length > 0) {\n const longUrl = result.rows[0].long_url;\n return new Response(null, { \n status: 302, \n headers: { 'Location': longUrl } \n });\n }\n }\n }\n\n // Serve HTML for the main page\n return new Response(`\n \n \n Short URL Generator\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}","deleted","label",[100],"permalink","https://www.val.town/x/cocodrilette/shorturl/code/main.tsx","extension","actionData","errors"]