Short.io

Promptfree, for everyone, and the only version there is

Open the prompt in Claude CodeOpen the prompt in CodexOpen the prompt in Cursor

Copy

Build me a link shortener on my own domain.

STACK
- A single serverless function or a small Node process, whichever my host makes cheaper
- SQLite for the links, one table
- No frontend framework — one HTML page for the dashboard

THE REDIRECT
- GET /:code looks the code up and answers 301, or 404 with a real page
- The lookup is the only thing on the hot path: no analytics write blocks it
- Cache the code-to-URL map in memory, invalidated on write

MAKING A LINK
- Paste a URL, get a code back; optionally choose the code myself
- Reject a code that already exists rather than overwriting it
- Refuse a target that is not http or https, and refuse one that points back at my own shortener

COUNTING
- One row per click: code, timestamp, referrer host, country if the host header carries it, and a coarse device bucket
- Never store the raw IP or the raw user agent
- The dashboard reads counts at query time; no aggregate tables

THE DASHBOARD
- One page, password-protected with a single shared secret in an environment variable
- Table of links with clicks, sortable, and a per-link view with clicks by day

QR
- Generate the QR as an SVG at request time from the short URL, no image library

Include the schema, a seed script and a README covering the DNS records the domain needs.