How I built dotapro.org

Intro This post breaks down my journey building dotapro.org, an open-source Dota 2 analytics platform for professional games. I'll cover why I built it, the technical architecture behind it, and share some actionable tips that might benefit you as a dev. Why I built it Dota 2 is one of the few games I occasionally enjoy, and I love building useful software. When I couldn't easily find specific professional Dota 2 analytics, I realized other fans and pro players had the exact same problem. So, I decided to build a solution myself. Features Advanced filtering for match and series data, allowing highly optimized queries by league, team, player, and hero. A sleek, modern UI focused on the match data that actually matters to players. A real-time ETL (Extract, Transform, Load) pipeline to keep match data up to date. Optimized, near-real-time pg_trgm word similarity searches for league, player, and team names. Architecture Overview When users visit the website, the React frontend fetches JSON