Hi everyone.
Does Supabase support inline updates to JSONB column?
I have like a very large JSON content and I need to update some of the info. Wanted to avoid having submit the entire payload every single time…
The user is asking if Supabase supports inline updates to JSONB columns to avoid submitting the entire payload. They also encounter an error 520 when trying to delete nodes. A community member suggests using an RPC call and SQL for targeted updates, and advises checking Supabase logs for more information on the error.
Inclusively if I try to delete some nodes after some time the operation abruptly errors out with the debug trace capturing HTML with error 520
The REST API is all json in the column for updates. You could use an rpc call and SQL to target exactly what you want.
On 2nd question ... no idea what nodes are and what trace you are referring to. Check the supabase logs to see if there is more info or query performance if you have a query timing out.