I'm having problems with the database and flutter. Whenever I delete or add an entry, I don't get new data. I can see the data being added to the table editor. If I do a full reload I get the data

Hello @kevindmoore! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

Are you using streams or the realtime feature of Supabase??

kevindmoore (2022-05-23)

I've tried both

There is a good chance that you havent enable replication

I did that and was seeing some progress, however deleting still wasn't working

Do you have a primary key on the table you are monitoring? Delete needs a primary key or you need to do: ALTER TABLE your_table REPLICA IDENTITY FULL in the sql editor.

I do

Do you have a filter on the subscription?

I do have a filter

So you may need to do replica full or put the delete in it's own handler. For protection delete normally sends only the primary key as deletes get sent to all subscribers ignoring RLS. replica full sends the full record so then the filter can run on other columns.

Do you know of an article that describes all this? Very confusing that I have to add all this. Seems like it should just work

Try running the sql statement I gave you above on the table, that turns on full replica copy for delete or drop the filter and see if it starts working. One of my feedbacks to the team has been lack of full examples of using realtime. The readme here has some stuff, but still not clear on some issues. https://github.com/supabase/realtime I end up searching issues on supabase/supabase both discussion and issues and supabase/realtime. I'll be honest, I've generated 1/2 dozen issues on realtime and done lots of debugging, and parts are still a mystery to me.

I think that worked!

Which?

The SQL command on the 2 tables I have

Just realize now that all the deleted data will show even when you do RLS that might limit which user sees inserts/updates.

I don't have RLS turned on as I tried it and things didn't work (so I turned it off)

What do you plan to use realtime for?

I'm actually doing 2 things: 1. Writing my "Todo Manager" and 2. Creating a video course on how to use Supabase with Flutter

Just realize that realtime is only as good as having a constant connection. Anytime a device sleeps, in some cases when a tab goes in background, or internet connection is lost, you really have to restart everything as there is no queue on the server.

Hmm. Is there a better solution?

I'm debating it's usefullness versus polling except for chat type stuff and even then put a bunch of code around it. This is probably more than you want to get into now, but this shows what I'm doing for reliability: https://github.com/supabase/supabase/discussions/5641 (it is a work in progress) There is a "bug" on background tabs still that I think they will address which will help in the desktop case of just going to another tab for 5 minutes....

I did notice that when i came back to the app after awhile, it lost it's authentication

Could be related to this, which has a fix about 2 weeks ago, but I'm not sure it caught everything... https://github.com/supabase/supabase/issues/6464

I think I am experiencing what you were talking about. My stream gets in a "waiting" state and I get no data