Then, assuming your user passes the RLS rule, it will work. If it's still giving errors then console log the error and tell us what it is

Sorry for jumping in, but I had the same issue last night about multiple relationships and @User's answer solved it. Thanks so much, saved me a lot of headache!

Sorry for the late reply. If this allows supabase to know the user cookie etc, then that's what I needed. Will try and run it soon, trying to refactor my code to be cleaner 😂

Is it possible to create a folder in a bucket via javascript (supbase.js)?

Hey all, I am wondering how to return a random row using the supabase js client. Is something Like order ('random') supported or do I have to use rpc/raw sql to do this?

When clicking a password reset link sent via email, is the user meant to be logged in automatically?

Regarding this code

Upsert boolean is not working

Error: "resource not found"

If it's not found it should insert it, but it doesn't

I can't tell what's going on and could use some help. I've disabled email confirmation on the Supabase dashboard, but when I go to log in after signing up an existing user I always get the error message:

Thanks for registering, now check your email to complete the process.

And I'm not getting any email for the accounts I'm testing with :/

Maybe disable and enable it again

yep that fixed it

lmao

thanks

You can't

Hm... when querying foreign tables, how do I do cross-schema queries? I have the

auth.users

table, as does everyone, and created a

public.user_relationships

table to hold some relationships. This query works when I use the query window

sql
select u.email, ur.employee_id from public.user_relationships ur left join auth.users u on u.id = ur.employee_id where ur.manager_id = '5995b4db-e19f-4f7c-9e55-10151b8a678a';

But how do I express that in javascript? Looking at this: https://supabase.io/docs/reference/javascript/select#query-the-same-foreign-table-multiple-times

js
const { data, error } = await supabase
  .from('products')
  .select(`
    id,
    supplier:supplier_id ( name ),
    purchaser:purchaser_id ( name )
  `)

I've tried doing

js
const {data, error} = await supabase
            .from('user_relationships')
            .select(`
        employee_id:auth.users(id),
        employee_id:auth.users(email)
        `)
            .eq('manager_id', auth.globalSession.user.id)

And getting this error:

Could not find a relationship between user_relationships and users in the schema cache

, which I think is the closest I've got The table structure is

sql
create table user_relationships (
    manager_id uuid references auth.users on delete cascade not null,
    employee_id uuid references auth.users on delete cascade not null
);

HM... It's going to be an access right thing where the anon key doesn't have permission to access the auth schema, huh?

yes it doesnt have access to

auth.users

you'd need a corresponding

users

table in the public schema to join with the

user_relationships

table

neat, thank you!

Noob question, is it better to use the sdk directly on the frontend or make an api for it on the backend? I hope I use the correct terms here

You can use it in both sides. How i would do it is the following: If i need only to interact with the db, i will use it directly from frontend. If for example, i would make a PDF generator, for let's say, send a file to the server, sign it, and then save it to storage, i would make in on backend

I see.. So it’s more like simple or more complex use case. What about from the security aspect? Is there any difference? Cause if it’s used on the backend it can sort of mask stuffs, right?

Depends. You can use RLS for securing the database from frontend. or you can make a custom logic in your api

Alright I think I get the gist of it, Thanks!

hello, is there a way to group records by specific column?

or am i supposed to do it with javascript on my side

cause i dont see anything regarding this task in documentation