Supabase Realtime: subscription works, but there are no changes in the table
The realtime channel shows the status of SUBSCRIBED, but INSERT and UPDATE do not refresh the list. The channel subscription does not guarantee that the table changes are published or accessed by RLS.
How to determine the source of the error
Check whether the table is added to the correct Postgres changes publication and whether the client subscribes to the correct schedule and event.
Verify whether token and SELECT policies allow the user to see the changed records.
What to do step by step
1. Include the required publication of changes to the correct table and limit the subscription scope to the actual required data.
2 . Add the re-download mechanism after reconnect and update the list after the record identifier.
How to check the score
The changes appear in two authorized users, and the unauthorized does not get information about other people's records.
What to do
Do not view Realtime as a permanent queue guaranteeing the delivery of any offline event.