[CLOSED] Reference registered details in database

i am making a schema like this:

TypeScript

        title: String,
        description: String,
        image: String,
        members: [String],

        where members is an array of user ids
    }

is there any way to reference user in this schema based on collection of registered user

TL;DR

OP is asking about how to reference registered user details in a database. They mention creating a user collection and referencing it in another collection. However, it seems that manual referencing is necessary since array operations are not supported. The suggestion is to fetch the user list, update it locally, and then update the collection with the new list. It is also recommended to consider whether using an array for members is the best approach, as it can be problematic for simultaneous updates. The proposed schema includes an array of user IDs. It is unclear if there is a solution provided in the thread.

No. When I use user details in my app, I typically create a collection of users. then, I can add any other attribute I need for the user.

Another suggestion I have is to really think about whether you want to use an array for members. Array operations are not supported so you'll need to do a full replace when adding a member. This can be problematic if you have multiple updates going on at the same time

so if i try to implement addition of members in my app, by pushing members in the array. I can't really do it right?

You'd have to fetch the list, push locally, and then update with that full updated list

ok, lets say i create user collection, can i reference it in other collection?

With the current version of cloud, it would be a manual reference. Appwrite 1.3 added support for relationships

Can you tell me about manual reference?

🥲

Its just a string attribute where you put the ID

Ah okay