Firebase Database index : information and effects

Question

I m using firebase Database .Planning to have quite a large data collection , I'm trying to use indexes . Making some tests, i don t know if rules i implement are correct let alone improve the queries .Is there a way to have a feedback on those indexations (correct or not, improve or not)

right now i have one class as described in the picture and i have the created the following rule

{
  "rules": {
    ".read": true,
    ".write": true,
      "users": {
       "$user_id": {
         ".indexOn": ["user_id", "username"]
          }
       },
 }

Since i get no feedback from firebase, i don t know if this is correct and improves anything .

Frank van Puffelen · Accepted Answer · 2021-05-22 03:48:28Z

1

Firebase's server-side rules are meaningless without seeing the code that exercises them.

But at a first glance it seems you're defining your indexes too low in the tree: indexes need to be defined at the location where you run the query. So if you want to run a query on /users, you need to define the indexes on /users:

{
  "rules": {
    ".read": true,
    ".write": true,
    "users": {
      ".indexOn": ["user_id", "username"]
    }
  }
}

answered May 22, 2021 at 3:48

Frank van Puffelen

603k85 gold badges895 silver badges868 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

it75 Over a year ago

Queries are numerous. Thanx for the information Frank. I was also looking for a way to figure out the efficiency of the indexation but i guess there is no easy way to find out

Collectives™ on Stack Overflow

Firebase Database index : information and effects

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related