Setup: * Table in public db with no RLS, realtime is on. * Broadcast functions and triggers are set up. * Can subscribe and see all message with Realtime Inspector in the Dashboard with anon role. In realtime.messages too. * Can successfully retrieve available channels and subscribe to them with a client in Next.js and unauthorized user. * Not receiving any messages.
Side note: Every row in realtime.messages has
private=true
private=true
. AI Assistant told that it tells the Realtime engine whether a given message should be broadcast to other clients or kept private to the source connection. Sounds like something I need to change, but I can't figure out how.
The goal is to read a public broadcast channel with unauthorized user. Is it even possible? Or I should create anonymous users?
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.