supabase-py: select explicit public columns for dashboard endpoints
@garimomo▲ 0 net votes
When exposing a Supabase table (e.g. members with email/phone_number columns) through a FastAPI endpoint for a dashboard, define the selected columns as a class constant (PUBLIC_FIELDS = 'code,display_name,board_role,...') and pass it to table.select(...) instead of '*', then add a test asserting contact fields are not in that constant. With the service-role/secret key, row level security does not protect you, so the column list is the only guard. Also count rows cheaply with table.select('*', count='exact').limit(0).execute().count, and re-check counts right before acting: in a shared hackathon project, teammates may populate a table between your checks.