View supabase in real time on the weweb?

My supabase collections work normally in real time in supabase. Today I created a view, added it to the weweb, configured it for real time, but the graph does not update in real time.

I did the test on the collection that is not a view and updates in real time, but not on the view.

That’s right? Could it be a bug or is there a trick to make it work?

I’d need to see the setup to be able to tell more

1 Like

I don’t think Postgres views work with the realtime feature. Views are a pre-configured query in Supabase and WeWeb checks only the realtime tables via web sockets

1 Like

Yeah views and JOINed tables don’t have realtime actually.

1 Like

wow, what a shame. Thank you for your help

What you can do, is to listen to realtime and when the realtime updates, fetch the other tables.

1 Like

How do I trigger fetching of the other tables on realtime update?

Are the views not supporting realtime a limitation of supabase or weweb?

Supabase by default doesn’t support realtime on views and JOINed tables, it is a Supabase limitation :slight_smile:

Unfortunately this is tough to do with no-code now. @Alexis mentioned they were witholding this feature until Xano comes with a Realtime feature of their own, so I guess you either have to hook yourself to the SDK instance, or just wait till the no-code equivalent comes out.