Hi Guys! 👋 I need your help with the real-time database feature. I'm trying to make it work and I did every step suggested by the documentation and it is not working as intended. According to the supabase dashboard, it seems like it works because I've got some Realtime Connection Requests, but I'm not getting any events from DB in the app. Steps that I took so far: 1. I enabled replications for the tables I want to subscribe. 2. Wrote logic for getting changes from the todos table:

useEffect(() => {
    const todosSubscription = supabase
      .from('todos')
      .on('*', payload => console.log(payload))
      .subscribe()

    return () => {
      supabase.removeSubscription(todosSubscription)
    }
  }, [])

Hello @sambor! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

Here are some pictures that could be helpful with debugging

Do you have RLS on for todos?

sambor (2022-04-12)

Yes, I've got some rules

Your user must meat the select rules

Nope, unfortunately, it didn't help

Did you set up the tables with the UI or use Prisma?

With the UI and then I tried SQL apporach with

/**
 * REALTIME SUBSCRIPTIONS
 * Only allow realtime listening on public tables.
 */

begin;
  -- remove the realtime publication
  drop publication if exists supabase_realtime;

  -- re-create the publication but don't enable it for any tables
  create publication supabase_realtime;
commit;

-- add tables to the publication
alter publication supabase_realtime add table public.profiles;
alter publication supabase_realtime add table public.todos;

Is this hosted or your own server?

The application is in the development phase so it is currently served only via localhost

OK the realtime server is Supabase's hosted service (I'm just a user so yours does not apply)

It returns

status SUBSCRIBED

Acting like issue on the server with replication/publication not working.

so what should I do?

contact support with the help tab at top right of your instance. Another thought, if you ran your sql code after you set up replication in the UI is to toggle everything off and on and also restart the server under settings.

Ok, I will try it 🙂 I want to thank you very much for your help! 🙂

I'm out of ideas and hate to keep wasting both our time if something is messed up on the server. I've seen a few of these only resolved by contacting them.

@User Were you ever able to fix the issue? Having same/similar issue with getting realtime working