Given an event app, how would you keep attendees synced up?
Current DB layout is the first image
I have an event, that allows users to join by creating a new row in the
Once the event starts, it'll have 3 stages. Each stage has a timer. I'm trying to figure out what the best way to make sure all attendees know an event started, what stage we are on, and how much time is left.
My original idea was to make a new table called
This way each attendee can listen to changes on this table and if something new comes, sort by
Any thoughts on this approach?
I have an event, that allows users to join by creating a new row in the
event_attendees table. The dashboard for the event, listens to changes in this table, and displays any new attendees, as they join (second image).Once the event starts, it'll have 3 stages. Each stage has a timer. I'm trying to figure out what the best way to make sure all attendees know an event started, what stage we are on, and how much time is left.
My original idea was to make a new table called
event_stages that has an This way each attendee can listen to changes on this table and if something new comes, sort by
created_at and get the last one (most recent). This will tell me what stage I'm on (what screen I need to be on), and when it ends (timestamp) so I can calulate the clock on the client side.Any thoughts on this approach?
