November Office Hours: Building a Real-Time Leaderboard with Live Coding!

Leaderboards are essential in online video gaming, fostering healthy competition among players by publicly displaying their current rankings. Leaderboards fall into the category of operational analytics, posing us with three challenges in implementing: speed, freshness of data, and concurrency.

In this talk, we will live code a real-time leaderboard from scratch using Redpanda, Apache Flink, and ClickHouse. The simulated gameplay events are ingested into Redpanda, processed through Flink, and finally sink into ClickHouses, allowing a Streamlit dashboard to visualize.

No matter if you are a data engineer, developer, or an architect, you can benefit from this session as they learn how these technologies are composed to achieve the speed, data freshness and concurrency needed for a leaderboard.