I want my User record to track a list of favorites. From my research I think I've found two viable solutions :
- Attach a relationship of the favorited item to the user.
- Have an array of Strings that holds all favorited items IDs, that I can parse later.
Note : The favorited items are all the same type, and therefore from the same collection.
Which would be the proper/best way to handle this?
- and - What are the pros and cons of both methods?
TL;DR
Developers want to track a list of favorites for user records. The two viable solutions are: 1. attach a relationship of the favorited item to the user or 2. have an array of strings storing favorited item IDs.
Pros and cons:
1. Attaching relationship: Pros - easier to query, maintain referential integrity. Cons - can be more complex, potentially slower.
2. Array of Strings: Pros - simpler setup, quicker access to all favorites. Cons - parsing may be required, can be less efficient for large datasets.
Solution: Consider using solution 1 for scalability and better performance, unless dealing withRecommended threads
- TOO_MANY_REDIRECTS after temporarily ena...
I am losing my mind over this, I enabled this setting because I was having issues with sites not making links with https. I enabled it, ran into issues, so I di...
- listRows result parsing issue
I'm using Appwrite Dart SDK "24.2.0". When I perform a listRows call in dart, I have this reponse in JSON: in " Future<models.RowList> listRows()" { "total" :...
- Index for combination of columns
How am i suppposed to apply index so that combination of two columns alwasy remain unique in appwrite table though console