How to get number of children in Firebase Database without downloading all the node on the client?

Question

Is there any way in year 2020 to get the number of children of a node in Firebase Database without downloading the entire payload on the client? I have about 20 000 users in db and I want to get a count of them.

Users
   userUID_1
       - 300 properties
   userUID_2
        - 700 properties
     .
     .
     .

See https://stackoverflow.com/questions/38443421/how-to-get-size-of-an-element-list-in-firebase-without-get-it-all/38444523#38444523 — Frank van Puffelen, Apr 27 '20 at 15:00

score 1 · Answer 1 · answered Apr 27 '20 at 13:14

1

I will give you a better idea:

create a new node called UsersCount:

UsersCount
|
|--------------number : "..."

When you save users to Users at the same time update the number in the UsersCount, now when you want to get the users count you don't have to read the whole Users node, instead you just read the UsersCount

answered Apr 27 '20 at 13:14

Hasan Bou Taam

4,017
2
12
22

It is too late. The database already has thousands of users registered. – bibscy Apr 28 '20 at 14:41
If you know how much users there are, add the node manually. And update the app to do so. – Hasan Bou Taam Apr 28 '20 at 14:42
What about the client app? That's where the logic comes from. I cannot release. a hot release... – bibscy Apr 28 '20 at 15:08

score 0 · Answer 2 · answered Apr 27 '20 at 13:18

0

I guess that you could implement a function to retrive this count within the server.

answered Apr 27 '20 at 13:18

Juanje

1,235
2
11
28

Can you elaborate. There is no count for users in the db. I don't want to download all the users every time I need the count of users. There are already thousands of users in the database. – bibscy Apr 28 '20 at 14:41

How to get number of children in Firebase Database without downloading all the node on the client?

2 Answers2