I can maybe trigger that edge functions via wenhook on before insert to encrypt the data.
And when decrypt and how encrypt and where store that encryption key and when to rotate? There are a lot of stuff that preferred if supabase did it. Anyway if someone can give general directions it will be super helpful 👑
Then how to do it? Just store it encrypted in Public.secrets table that I will create with RLS?
I will use it for storing users secrets as well. Why do the encryption and all of that logic in my code when supabase already does that
Should change it to regular JSON or keep it JSONB?
Got it, I have RLS, must use postgREST, cant control JSONB size, doing one by one cant change it, I guess only way is to not put indexes on JSONB which I already don't have