3 ms·
we have a lot of work to do for migrations and testing, especially RLS. for this Launch Week we focused on generating policies (more on that in tomorrows launc
by kiwicopple 4y ago
we have a lot of work to do for migrations and testing, especially RLS.
for this Launch Week we focused on generating policies (more on that in tomorrows launch week). This is hard for a lot of our audience who aren't familiar with SQL.
In the next few months we'll work on simulating a policy - being able to choose a specific user and see what data would be returned for that user.
We also have `supabase test db`, in case you missed it. It wraps pgTAP and pgProve so that you can write database tests.
> recreated without 'WITH (security_invoker)' even though they had security_invoker turned on before
we use migra for diff'ing. Thanks for raising this - we'll file a bug report asap.
- niklasd 4y agoGreat, thank you for the reply! The simulation a policy sounds exciting. Looking forward to the news.
- kiwicopple 4y agofollow up on the "security invoker" - we've filed a bug report here which you can follow: https://github.com/djrobstep/schemainspect/issues/86 https://github.com/djrobstep/schemainspect/issues/86