
Okay Im trying to build a kind of IMDB / TMDB app where user can like, mark as seen, etc... movie. So what the best way to store these datas ? Create one collection per type of reaction. For example :
- Collection Movie_Rated
- Collection Movie_Liked
- Collection Movie_Watched
Or make only one collection like :
- User_Movie where each document is contain a user id, movie id, if liked, if watched and if rated
idk what the best way, instinctively I would say the second one to get all data in one api call

Best way: create a function to add 1 when someone likes anything and remove 1 when like is removed

So you will need to have a likes collection to prevent the same user liking it 2 times

when u say a function, u are no talking about Appwrite function right ? So its better to have one collection per type of reaction ?

Mhh but if I have juste one collection with a document for each movie and each user example :
- userId: 854d5g84dr25g54drg
- movieId: 597
- like: true
- watched: true
- rated: 8
How its possible to havbe an user liking 2 times ?

Yes, I'm talking about appwrite function

Respect to collection, yes, probably

The user creates 2 documents for the same film, so you get 2 likes

Instead, use a function that checks if it exists or not a document for the same film from the same user
Recommended threads
- can't send emails
i explored the docs and it says Messaging.CreateEmail() but this function does not exist , i installed appwrite on next js env everything works fine except thi...
- Messaging via Resend: "to": "\"undisclos...
I'm using the node-appwrite@18.0.0 SDK. ``` await messaging.createEmail({ messageId: ID.unique(), subject: "Subject", content: `htmlCont...
- unexpected row_invalid_structure error
In images you can see both my code,error, column schema I do have timezone in table schema but still while creating a row i am receving row_invalid_structure e...
