Supabase
Dumb question about inserts and keeping the front end updated #26536
-
|
I'm new to web app development so sorry in advance if I am unable to describe things properly, I'm still at the stage of "I don't know what I don't know". I have been stumped by a problem that I can't seem to understand how to resolve. I am testing a python script in collab (separate from my web app) to generate row data that I insert into several tables in Supabase. My webapp should then be reading from these tables, for example I have a metric that presents the number of rows from one of my tables or you can query values from a specific column to return values from the row. I've verified that the new rows are found in Supabase but oddly they aren't reflected in my front end. Is there a step that I'm missing? I've tried deleting a table and reuploading an updated one with the Supabase website as a test and that seems to update everything, so I'm kinda clueless how to solve this. I'm building the app in python/flask if that gives any clues. I'm also using the service role api key to interact with my tables since I've enabled RLS. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 9 replies
-
|
How does your front end get the data? If you insert to the table from one method, then the next time your app selects the data from that table it should be reflected unless you have RLS coming into play or some sort of client caching. |
Beta Was this translation helpful? Give feedback.
-
|
If you reload the table (call .select()) after your inserts the inserted data should show up. If you have RLS enabled then you could have issues where RLS is not met, but you have not mentioned RLS or policies. |
Beta Was this translation helpful? Give feedback.
-
|
I have RLS set up but no policies, I thought using the service role API key would have let me avoid any of the restrictions when using a table with RLS. |
Beta Was this translation helpful? Give feedback.
-
|
Yeah, if you have service_role from the client then RLS is not involved. |
Beta Was this translation helpful? Give feedback.
-
|
I just wanted to say thanks again for attempting to troubleshoot my issue. I just wanted to update you and admit that I'm actually just dumb AF - turns out the default max rows to be returned by supabase is set to 1000 so I was actually missing a bunch of rows + my insert. I expanded it which solved everything but I am a bit suspicious about doing that since there is recommendation not to do so. |
Beta Was this translation helpful? Give feedback.
I just wanted to say thanks again for attempting to troubleshoot my issue. I just wanted to update you and admit that I'm actually just dumb AF - turns out the default max rows to be returned by supabase is set to 1000 so I was actually missing a bunch of rows + my insert. I expanded it which solved everything but I am a bit suspicious about doing that since there is recommendation not to do so.