S

Supabase•13mo ago•

149 replies

Light

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

event_attendees

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

event_stages

that has an

{ event_id, timestamp, current_stage, created_at }

{ event_id, timestamp, current_stage, created_at }

This way each attendee can listen to changes on this table and if something new comes, sort by

created_at

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

timestamp

) so I can calulate the clock on the client side.

Any thoughts on this approach?