Where can I find a full example of testing security rules?
If I understand correctly, I should use the pgTAP extension on supabase and here are a few examples of tests that I could write: https://supabase.com/docs/guides/database/extensions/pgtap. I found an example on how I could set up pgTAP to run with my Github actions CICD https://2metz.fr/blog/use-pgtap-on-github-actions/. But what do I need the extension for then? What does this extension actually give me / how should I be using it?
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.