CODEWITHSUNDEEP
firebasedatabase-designnosqlgoogle-cloud-firestore
kellycup8
kellycup8

Reputation: 1

Best way to model friend relationships for querying a user's friends with firestore

I want to query all users that a user (user1) is friends with, in one query with firestore.

Currently, I have a "friends" field in each user object, so to get the users who are friends w user1, I call:

friendsOfUser1 = db.collection('users').where('friends', 'array-contains', user1).stream().

This works well when users only have < 100 friends, but after that the user objects get very large since the user.friends array has many values. This makes receiving user objects expensive.

Is there a way to store the friends array outside of the user documents while still being able to query a user's friends in one query? This is what the structure is now:

user1: {friends: ["user2", "user3", "user7", "user9"], name: "John Sci"}

user2: {friends: ["user1", "user4", "user8", "user12"], name: "Elmo Square"}

user3: {friends: ["user1", "user7", "user9"]}

so db.collection('users').where('friends', 'array-contains', user1).stream() will give [user2, user3].

Upvotes: 0

Views: 1566

Answers (1)

Doug Stevenson
Doug Stevenson

Reputation: 317720

The scalable alternative to storing strings in an array is to store the same strings in separate documents, typically as a subcollection of the main document.

/users
    /{uid}
        /friends
            /{friendId1}
            /{friendId2}
            /{friendId3}

In order to find out if user1 has user2 as a friend, all you have to do here is get the document using the IDs of the two users: /users/user1/friends/user2. If the document exists, there is a relationship.

Upvotes: 4

Related Questions