Hi all
I have an e-learning app. It has several series that have stories in them to be read. I would like to have the stories marked as done/complete once a user reads a story without updating the entire database for all users. So their progress updates(in a progress bar) and is only visible to each user. The database collection is same/has the same series with stories for all users in the app
I have two main collections, One has all the series. One collection has all the stories.
Help!
Option 1: have a separate collection where you store the progress for each story/user. Collection has relationships to Users M:1 (a progress record belongs to one user) and to Stories M:1 (a progress record belongs to one story). You create a record when a user starts or finishes the story. You can also store additional information in the record (e.g. start time, finish time, comments, etc.).
A very similar logic is described in this video (https://youtu.be/_HS9WkDJbRk) - the idea of a separate collection is the same.
Option 2: create M:M relationship between Users and Stories, and add this relationship when User finishes the Story. Here you will be able to count nb of Stories for each user and have the progress as a result.