Hi! Does

supabase-js

support queries with a different schema than

public

? I have created tables with a diferent schema but i see no way to specify it in the queries

created_at | timestamp with time zone | timestamptz    
id | uuid | uuid    
receiver_id | uuid | uuid    
sender_id | uuid | uuid    
status | integer | int4    
updated_at | timestamp with time zone | timestamptz

Both receiver_id and sender_id are foreign keys to user.id and both primary keys. I am trying to query this relationship table by user id, get back the relationship and the user for both receiver and sender for each relationship. I have tried a ton of combinations but this is currently what I have which seems to get me the closest so far.

const { data, error } = await supabase
        .from('users')
        .select(
            `
                id,
                sender:relationships.sender_id ( * ),
                receiver:relationships.receiver_id ( * )
            `,
        )
        .eq('id', `${user.id}`);

Any advice or help would be greatly appreciated. Edit (Self answer) - for those who need this type of query in the future, I was going about it backwards. While it breaks from other relationship querys you do actually want to query from relationships then use the foreign keys to get the users data.

const { data, error } = await supabase
        .from('relationships')
        .select(
            '*, sender:users.sender_id (*), receiver:users.receiver_id (*)',
        );

@User Make sure to update your syntax to:

const { data, error } = await supabase
        .from('relationships')
        .select(
            '*, sender:users!sender_id (*), receiver:users!receiver_id (*)',
        );

Using a dot

.

on the embedded resource is deprecated, use

!

instead.

o/ I have the code below (JS) and I need to somehow use .eq() to check if the authenticated user's id (string) matches the userid column (UUID)... does anybody know how i can do that?

js
let { data, error, status } = await supabase
                .from('venues')
                .select(`name`)
                .eq('userid', user!.id)
                .single();

Apologies if this is blatantly obvious but I couldn’t seem to find the answer anywhere on the internet so I thought you all might be able to help

are you getting an error from that snippet?

or are you asking about how to get the authenticated user's id?

I’m just getting 406

Which I understand to be nothing was found

eq uuid

Does Supabase auto-fill the id (uuid) field when a row is inserted or do I need to manually fill it (and if so, how do I generate one with js/ts?)

it depends on the table - if you've set it to have it generated by default, then you wont have to manually fill it

this part when you try to create a new column

for user sign ups that go into

auth.users

, supabase creates a uuid for them, but for other tables you'll have to set it up

oh ok

How to check if the connection to supabase api is OK (with ssl and security stuff)? Sorry, I don't understand much about the web protocol... But I having issues about having an Invalid Certificate

does a user still need to validate their phone number if they sign up with a email too?

Also - whenever I pass an email and phonenumber to the auth signup, it doesnt save the user email - it just goes through the phone number otp process and says the user needs to verify their phone number on the supabase auth dashboard

Can I Add data to two table at once ?

Re: Password reset. We are implementing a password reset feature, but it looks like the API calls leak data on if the account exists or not in the console, which is a bad security practice (see the OWASP guidelines). After running

const { data, error } = supabase.auth.api.resetPasswordForEmail('user@email.com')

a 404 is returned for non-existant emails. Is there a way to not expose if the account exists or not?

Reset password for email

Bump! I would like to know.

Hi folks, I have a problem with my RLS... I have Supabase running on local environment with Docker, I enable RLS but not working when test it with Postman, but if I do the same with the online database everything goes well. Can someone help me?

Hey there, a quick question: Does supabase already support realtime subscriptions with RLS?

Hi guys, im using supabase locally with docker, yesterday was working fine but today suddenly I lost all my database

RLS and realtime

Not too sure of this, but would I be able to use the Spotify api with supabase and make requests to the api? Thank you !

Ok so I am trying to convert an

int8

column to

uuid

but I get this error when doing so (the table is empty)

nvm, dropped that column and made a new column 😄

Hi, I think I found a bug in the UI if you have a jsonb column with lots of data inside.

I'm on pro tier, and on settings, the DB instance is on constant 100% usage