Home / Companies / ScyllaDB / Blog / Post Details
Content Deep Dive

How to Model Leaderboards for 1M Player Game with ScyllaDB

Blog post from ScyllaDB

Post Details
Company
Date Published
Author
Daniel Reis
Word Count
1,876
Language
English
Hacker News Points
-
Summary

Daniel Reis explores the process of creating a high-performance leaderboard for the open-source rhythm game YARG using ScyllaDB, a fast NoSQL database. The project focuses on query-driven data modeling, employing key-value and wide-column paradigms to efficiently store and retrieve player scores and game metrics. Reis demonstrates how to structure tables for both storing match data and ranking players on song-specific leaderboards, emphasizing the importance of partition and clustering keys to handle large-scale data queries efficiently. He also discusses the potential for contributors to engage with the YARG community through Discord and other platforms, highlighting the involvement of notable figures in game development. The article concludes with insights into the challenges of data modeling and resources for further learning about ScyllaDB.