Openstats
A multi-game player lookup. Search any account and see rank, match history and per-hero stats, with tier lists and builds for Deadlock and League of Legends.

What We Built & Why
Openstats is a stats site for competitive games. Type in any account and it shows the player's rank, match history and per-hero performance, next to tier lists and builds. Deadlock and League of Legends are live, and the site is built so more games can be added. We designed the interface, wrote the site and the sync worker behind it, and run the servers it lives on.
Stats sites tend to be slow, crowded with ads and split across one site per game. We wanted one fast place to look up a player, with the numbers that matter first.
Player Profile
Rank, record and win rate at the top, then most played heroes, recent matches, trends against teammates and a six-month activity map.

Match Page
Both teams side by side with every player's build, damage and souls, a map of the fight and a timeline you can play back.

Key Features
The Problem
Every ranked match adds up: storing them grows the database by about 700 MB a day
Our Approach
A separate sync worker fills a PostgreSQL store, so pages read from our own database instead of waiting on a game API
Development Challenges & Solutions
