Update a supabase table row from next.js
I'm creating a UI component to my next.js app , and it's supposed to edit the data to a supabase table row. There's 19 columns in this table.
Let's say the user only changes one of these 19, but I still insert 19 values where 18 is the same as the existing row, does it still update all rows regardless, or just the data that is changed? And, is this concidered very bad practice?
The operation to sort out on the client what values that has changed, and then make a custom insert for only those values is a bit more tricky, but maybe it's the only way?
Let's say the user only changes one of these 19, but I still insert 19 values where 18 is the same as the existing row, does it still update all rows regardless, or just the data that is changed? And, is this concidered very bad practice?
The operation to sort out on the client what values that has changed, and then make a custom insert for only those values is a bit more tricky, but maybe it's the only way?
