Firebase Realtime Database - Structuring with relationships

Question

Guys need some input creating a data structure that can be scaled for my use case.

I as a user can have many followers & can follow others too. So when I create a post my followers should get it. The Typical use case similar to Twitter or FB, but not so complex.

So for Instance I(Joseph) follow 2 users, hence my feed should be populated with the posts from the users I follow.

How can I fetch the posts of persons I follow. Or please guide on how to achieve the same using Firebase Realtime DB (NoSQL)

Peter Haddad · Accepted Answer · 2017-10-26 12:38:30Z

1

{
 "following":{
    "josephid":{ 
       "name"  : "joseph"
       "naber" : true
       "roger" : true
 }
}
 "followposts":{
        "pushid":{
          "foriegnid": "pushid1"
          "foriegnfollowid": "josephid"
       }
       "anotherpushid":{
         "foriegnid": "pushid2"
         "foriegnfollowid": "josephid"
       }

 }
}

Create another node that will take the ids in the node post and the id of the current user. That way the people that person is following and the posts are connected with each other. The Foriegnid and foriegnfollowid is just a name not an id but the value is the pushids of the posts and the userid

edited Oct 26, 2017 at 12:38

answered Oct 26, 2017 at 12:07

Peter Haddad

81.2k26 gold badges148 silver badges149 bronze badges

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

5 Comments

Sharan Mohandas Over a year ago

Okay so now we have the id's. But doesn't require this querying each and every posts to get the data.

Peter Haddad Over a year ago

check this link firebase.com/docs/android/guide/… @SharanMohandas

Peter Haddad Over a year ago

You can nest it, but this is a better option. The link above actually have doc for all three platform on how to join @SharanMohandas

Sharan Mohandas Over a year ago

Yeah, I was apprehensive about having multiple requests for each posts. But Firebase itself encourages it. Shall look at how this approach performs

Peter Haddad Over a year ago

@SharanMohandas yes i think this approach will work out, since its logical

Collectives™ on Stack Overflow

Firebase Realtime Database - Structuring with relationships

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related