Best Way to Manage User Favorites in a Video App
TLDR Jesse asked about effectively managing user favorite videos in an app. Kishore Nallan suggested using collection joins set to be supported in their next version.
Jul 28, 2023 (4 months ago)
Jesse
03:01 AMI am wanting to know if storing a large number of strings in an array is bad for an application like this?
Let’s say that I have a video app, and I want the users to be able to favorite videos, then to later be able to search their favorites, would this be the best option?
I was thinking of creating a separate collection for each user with their favorites, but this could be bad as evetime the video is updated (or even deleted), I would have to update it in every user’s collection (if I have 1,000,000 users favorite a video, and the title changes, I would have to update 1,000,000 times - once for each collection).
Kishore Nallan
11:53 AMSee here: https://github.com/typesense/typesense/issues/229#issuecomment-1645573572
Jesse
09:05 PMTypesense
Indexed 3015 threads (79% resolved)
Similar Threads
Debating Collection Limitations in Typesense
Bill inquires about creating unique collections for each movie title. Kishore Nallan suggests limiting collections but agrees joined profiles in the next Typesense version will enhance this capability.
Ranking Favorite Food Records in Database Search Results
Julian asked for best practices to rank favorite food records in search results. John suggested using `_eval`. Jason recommended adding a `favorited_by_user_ids` array field to each record.
Nested Objects and Arrays in Typesense
Robert seeks advice on managing nested objects in Typesense. Kishore Nallan informs of upcoming support for nested objects and provides a current workaround. Robert indicates interest in tracking this feature. Kishore Nallan provides a link to follow the issue.