The latest articles on DEV Community by Cole Godfrey (@colegodfrey). https://dev.to/colegodfrey https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4148214%2F1ef5b034-c0f2-4fff-ac21-dc41988121ea.jpg https://dev.to/colegodfrey en Cole Godfrey Tue, 29 Sep 2026 00:59:23 +0000 https://dev.to/colegodfrey/clew-a-url-shortener-with-sqlite-click-counts-25an https://dev.to/colegodfrey/clew-a-url-shortener-with-sqlite-click-counts-25an <p>Clew is a small URL shortener with a JSON API. Send a destination to /api/links and it returns a short URL. Following that URL sends a 302 redirect and records the visit.</p> <p>For concurrent visits, each redirect starts a BEGIN IMMEDIATE transaction before updating the total and storing the click time. Clew keeps the total count and the newest 20 timestamps. A HEAD request checks the destination without adding a click.</p> <p>Create and stats requests need an API key; redirects are public. It runs as one app instance with a persistent SQLite file. The <a href="https://github.com/Cole-Godfrey/Clew" rel="noopener noreferrer">repo</a> has local setup and Docker instructions, and the <a href="https://colegodfrey.pythonanywhere.com/docs" rel="noopener noreferrer">API docs</a> are online.</p> showdev python fastapi sqlite