Question 119777 in Firebase Question posted in
An extensive official documentation can be found here.

Firebase – How to properly construct a Leaderboard for 10-50K records in noSQL?

In my app upcoming project, I plan to use the google ecosystem – that means firebase auth, firestore (noSQL), cloud functions. I want to stick to noSQL as it fits better for this project. While scoping the project, the client asked for a leaderboard of all users (application has some kind of xp system), which is not a problem, but then I remembered I’m working in noSQL.

What is the best approach for this problem? This is a duplicate of this question, but I don’t feel satisfied with the approaches that were presented. Is there any better way to do this? I expect rapidly scaling user base in 10’s of thousands of users.

I did a quick math considering this answer. The max size of document in Google Firestore is 1MiB, which amounts to maximum of 62,500 users that can fit into the document, considering they have userID that spans to 8 digits and XP that spans to 6 digits. This solution felt like the most peaceful amongst any others.

The problem is, that sorting would have be executed on the client, in Flutter app.

Would this solution be somehow good?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Answering my own question and locking this thread.

    User Dharmaraj pointed out, that while using .limit(100), Firestore does not charge for the whole collection, but only for amount of the limited results. This was unknown for me and now I am presented with a great solution that doesn't screw up your data structure.

    Thank you again, mr. Dharmaraj for your help.


  2. 0

    The first link that you’ve shared mentions that you’ll need a query that looks like:

    SELECT count(id) FROM players WHERE score > {playerScore}

    Firestore now supports aggregation queries and has a new count() function that returns number of documents matching your query. You can try running the following query:

    db.collection("users").where("score", isGreaterThanOrEqualTo: userScore).count().then(
      (res) => print(res), // <-- user rank 
      onError: (e) => print("Error completing: $e"),
    );

    This was added recently so make sure you are using latest version of the Firebase SDK.

    Additionally, for the query related to billing in the comments, orderBy() does not incur additional charge. You are only charged for the number of documents returned by the query i.e. limit(100) will return a maximum of 100 documents and hence 100 read at most.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search