Need help with websockets/supabase in my online game
I am trying to create a poker game using sveltekit as frontend and fastify + supabase as backend, this game should allow users to play with their friends.
The room table is structured this way:
- there is an esadecimal code of 6 chars to enter
- every player is identified by their auth.users.id, provided by the supabase auth system
- All players and game stats are stored inside this table
The problem starts when I have to implement the websocket connection.
Supabase realtime is too expensive to let him handle all the connections, so I have decided to use just socket io, and in case use supabase realtime, but only in the fastify backend which doesn't have row level security activated.
Every user should have max 10 seconds to make a move, if they don't they should fold (or quit, for non-poker players), I am struggling to figure out how could I implement this, I have came up with three possible solution:
- Use supabase realtime to listen to the room tables where the last move was more than 10 seconds ago and then emit to all users in that room using socket.io that the player has folded.
- Same logic as the first option, but with redis
- Use bull to schedule timers
Do you think this is doable? Do you have any other idea in mind?
The room table is structured this way:
- there is an esadecimal code of 6 chars to enter
- every player is identified by their auth.users.id, provided by the supabase auth system
- All players and game stats are stored inside this table
The problem starts when I have to implement the websocket connection.
Supabase realtime is too expensive to let him handle all the connections, so I have decided to use just socket io, and in case use supabase realtime, but only in the fastify backend which doesn't have row level security activated.
Every user should have max 10 seconds to make a move, if they don't they should fold (or quit, for non-poker players), I am struggling to figure out how could I implement this, I have came up with three possible solution:
- Use supabase realtime to listen to the room tables where the last move was more than 10 seconds ago and then emit to all users in that room using socket.io that the player has folded.
- Same logic as the first option, but with redis
- Use bull to schedule timers
Do you think this is doable? Do you have any other idea in mind?
