Is there a good naming pattern for the policies? I have like 70+ tables and Somehow I write "users can read" "users can select", "users can see" … I ended up to copy select / update / ... so that is it at least a bit unified
Yeah, can get a little out of hand! I would recommend using the name to describe the policy to make it easier to parse later - “authenticated users can select their own todos” rather than “select todos policy”
When I have a 1:1 relationship between an user and its DB objects: Is it suitable to use "ALL" RLS with "(auth.jwt() ->> 'sub'::text) = (user_id)::text"?
Can you do a video showing RBAC in Supabase with a permissions table for multiple roles where RLS policies grab the current user's role from a JWT, for instance Clerk's supabase JWT with the role embedded in public metadata?
I created schemas to organize my tables in Supabase, but I am unable to load them in FlutterFlow. On the schema screen in FlutterFlow, only the tables in the 'public' schema appear. What configuration should I make in Supabase so that these schemas I created appear in the API?
Please do a video on including additional data from the public schema in the session
That’s a good one! Will add it to the list! 💯
superb videos, content and delivery, hope supabase will continue to rock!!!
It definitely will! Glad you enjoyed the video! 🙌
You know it’s a hard core classical engineer when they’re also deep into music.
Great! Love the content ! Thanks
Thanks! Glad you enjoyed it! 🙌
Thanks! Glad you enjoyed it! 🙌
That's why I use Prisma
Is there a good naming pattern for the policies? I have like 70+ tables and Somehow I write "users can read" "users can select", "users can see" … I ended up to copy select / update / ... so that is it at least a bit unified
Yeah, can get a little out of hand! I would recommend using the name to describe the policy to make it easier to parse later - “authenticated users can select their own todos” rather than “select todos policy”
God bless u
you should be using select with auth.uid()... need a video on policies and speed
Yep, good call! This would be more efficient!
When I have a 1:1 relationship between an user and its DB objects: Is it suitable to use "ALL" RLS with "(auth.jwt() ->> 'sub'::text) = (user_id)::text"?
Can you do a video showing RBAC in Supabase with a permissions table for multiple roles where RLS policies grab the current user's role from a JWT, for instance Clerk's supabase JWT with the role embedded in public metadata?
also need that content, need to create an admin and member kind of permissions table ...
Strange, I don't have the "definition" button on the view in the table editor section. Have you the same issue ?
Oh weird! I thought this was rolled out to all projects. If you submit a support ticket to supabase.com/support someone can take a look 👍
I created schemas to organize my tables in Supabase, but I am unable to load them in FlutterFlow. On the schema screen in FlutterFlow, only the tables in the 'public' schema appear. What configuration should I make in Supabase so that these schemas I created appear in the API?
@dshukertjr any ideas?
Supabase getting overcomplicated..... Let me give surrealDB a shot
It’s not Supabase being complicated, it’s Postgres being powerful 😂
@@BenjaminMichottenailed it!
Yes@@BenjaminMichotte