with Prisma you can do for example:

js
const query = await prisma.user.findUnique({
  where: {
    user_id: userId
  },
  include: {
    post: true,
    comment: true
  }
})

this will get the user's record from the

user

table, and also the user's posts and comments from the

post

and

comment

table using the

user_id

relation

to join multiple tables with Supabase API try this: https://stackoverflow.com/questions/64996432/how-to-query-using-join-in-supabase

Hi. Is it possible to run sql queries at https://app.supabase.io/ from a given user from auth table? it seems https://app.supabase.io/ has queries run as root so testing procedures depending on auth.uid() is not possible. any solution?

I think you can do it by setting the relevant setting. You can do it in 2 ways (one former sets it for the entire duration of the session, while the latter sets it only for the current transaction as far as I know):

SELECT set_config(
  'request.jwt.claims',
  '{ "sub": "ddddc018-2f88-412a-a581-0f3e85e6ff43", "email": "user@email.com" }',
  false
);

or

begin;
set local "request.jwt.claims" to '{ "sub": "ddddc018-2f88-412a-a581-0f3e85e6ff43", "email": "user@email.com" }';
-- do something
commit;

@chipilov oh looks very nice. Will definitely try it, thank you!

I would like to ask is it possible to develop a HIPAA compliant software with Supabase

For some reason i keep getting a 403 (forbidden error) when attempting to insert to supabase table. Anyone know why?

Do you have RLS on for that table and if so have a select policy. Insert does a select also unless you turn off it off with the minimal option.

I do have RLS on it and tried changing return type to "minimal" but it still throws me a 403

Then you probably need to provide code for your insert and your RLS policies for anyone to help.

Sent you a dm

Hello everyone! 👋 New to supabase discrod but I've been trying supabase for some time and loving it!

Currently none of the Functions related pages are opening in app.supabase.io

Any idea what's going on?

why is it not loading?

loading for me

try refreshing

Not loading for me either. My apps are down

Can confirm.

app.supabase.com

is not loading. The supabase logo keeps spinning

Notion is also down... maybe an issue with AWS?

https://status.aws.amazon.com/ too haha

AWS outage at the moment, many apps have been affected including Supabase in some regions.

Europe is working again. Let's see how long.

I had just downloaded a supabase.js branch with a fix done by supabase last night to help test and then login in broke. Spent awhile looking at that then noticed my other project would not login and then supabase.io would not login, now lots of people are down..... hope I did not cause it 😎

What have you done @User? revert quickly 🤣

Btw my project are working along with the supabase dashboard

Back up and I did not revert....

Looks like its back now.

Hey, quick question to anyone who knows: By default, if I enable row-level-security on a table, does that disable access to all anon/authenticated roles, or do I have to manually disable access? I'm trying to create a table which is only accessible by the service role key...