-
-
Notifications
You must be signed in to change notification settings - Fork 193
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Update does not reflect changes in supabase table #845
Comments
My first thought is that you aren't meeting your row level security (RLS) policy requirements. I would suggest turning off RLS and then testing this again to see if it works. |
What are the repercussions of that to the privacy of my user database...? The python client attempting to make these changes is always the same with the table owner's API key. |
It does appear at first glance that the Python client would adopt the authenticated role which respects RLS... Although this doesn't explain why I am able to read from the table but I am not able to update the table...? Is there a way from the Python client init to specify the postgres role? Or to otherwise somehow keep RLS enabled for the sake of my data's privacy, while still allowing the Python client to make updates? |
@silentworks Any chance you could update here regarding RLS and best practices? Would it make more sense to create a separate table for my user chat information that is linked to the auth profiles? |
@mrbende I think the Supabase docs does a better job at explaining RLS than I can. You should check out the docs and create policies that fits your needs for your project. The python library only uses |
Closing this out as it might have been due to RLS not configured correctly. |
Bug report
I am unable to return data, or see the updated content reflected in my Supabase console, when working with a public database... This is in the context of a chatbot application where I am trying to save conversation history alongside user profiles as a json field.
Describe the bug
Egress from the table works with no problem -- I am able to authenticate with the python client, connect to my table, and read the appropriate data from the table.
When trying to update a user profile to update the field, however, no ingress is ever executed. I can validate that the proper json is being passed to the supabase client, but the resulting data is empty and no update is reflected in supabase.
To Reproduce
These are my python functions to interface with supabase within my application:
Expected behavior
In the attached screenshot, the data that is returned on ingress should reflect that data has been added to supabase but nothing is updated.
Supabase table
chat_history
json information can be seen here:Any help would be appreciated. Thank you!
~ Reed
The text was updated successfully, but these errors were encountered: