Just wondering what's the best approach for multi-...
# off-topicc
carlomigueldy.eth
07/29/2021, 3:25 AMJust wondering what's the best approach for multi-tenancy? @User @User
e
everconfusedguy
07/29/2021, 3:37 AMCheck out this discussion - https://github.com/supabase/supabase/discussions/1615#discussioncomment-759752
I personally prefer option 3 there
c
carlomigueldy.eth
07/29/2021, 3:37 AMHey thanks I'm going to check it out
carlomigueldy.eth
07/29/2021, 3:38 AMOh. Awesome I think this is great
carlomigueldy.eth
07/29/2021, 4:18 AM@User Got a question, I don't know the reference of
current_usere
everconfusedguy
07/29/2021, 4:19 AMin our RLS policies, you can get the currnet user id by auth.uid()
c
carlomigueldy.eth
07/29/2021, 4:20 AMAhh I see..
I also want to learn how you guys come up with that, is it taking the user from auth schema?
e
everconfusedguy
07/29/2021, 4:25 AMHere is the actual definition of the function - https://github.com/supabase/supabase/blob/080f1e05bd620f91df636319f976ea1996850189/docker/dockerfiles/postgres/auth-schema.sql#L77-L79
everconfusedguy
07/29/2021, 4:26 AMPostgrest exposes the request JWT claims - https://postgrest.org/en/v7.0.0/api.html#http-logic and we make use of that
everconfusedguy
07/29/2021, 4:26 AMthe JWT itself is generated via Gotrue (our Auth server)
c
carlomigueldy.eth
07/29/2021, 4:26 AMOhhh wow thanks for sharing!!
e
everconfusedguy
07/29/2021, 4:27 AMhttps://github.com/supabase/supabase/tree/master/examples/nextjs-slack-clone#postgres-row-level-security
here are some sample RLS policies
everconfusedguy
07/29/2021, 4:27 AM(search for "create policy")
c
carlomigueldy.eth
07/29/2021, 4:28 AMThank you so much man 🙏 🙏 💪 I'll definitely be checking these out, I'm going to build a SaaS
e
everconfusedguy
07/29/2021, 4:29 AM🚀 🚀