Vatra
Sole developer — backend and frontend
Geospatial event discovery platform with bounding box, radius, and city-polygon filtering. Built solo from scratch — my own product idea.
The core challenge was geospatial querying at scale. Events are queryable by bounding box, radius, or city polygon using PostGIS on Postgres 17, with spatial indexes keeping query times flat as data grows.
Event moderation runs asynchronously through BullMQ: submissions drop into a queue and moderators work through them in a purpose-built admin panel, with a Telegram bot pushing notifications when something needs attention. The pipeline was async from the first commit, before anything needed queueing, so that AI pre-screening can be added later without rearchitecting the publication path — this is a public map, and unmoderated public maps attract exactly the content you would expect. Logto handles OIDC for end users; Redis backs caching and the queue. Everything runs in Docker and deploys via GitHub Actions.
Built solo, backend and frontend in parallel, from an empty repo. The product idea was mine; v1 ran an open beta, v2 is in progress.