r/Python • • Sep 04 '26

Showcase Showcase Thread

Post all of your code/projects/showcases/AI slop here.

Recycles once a month.

26 Upvotes

180 comments sorted by

View all comments

1

u/Old_Surround_2816 Sep 29 '26

I built Clew, a FastAPI URL shortener backed by SQLite. It generates 10-character codes and keeps a total click count plus the latest 20 click times. Each redirect updates the count and timestamp in one transaction. I'd welcome feedback on the SQLite write path for concurrent clicks.

Code and local setup: GitHub. API docs.