No way to do it without a foreign key?

I’m thinking of switching to postgrest at this point

Is there a way to connect directly to postgres?

with pgadmin 4 and the credentials the give to you

Thank you, I'll try to do that and see

I've been following the project for ~1 year, and wanted to try it out. Would be glad if the client allowed me to use joins

Not sure if this is in the scope though

Another feedback: I was looking for an "and()" function in the API to complement the "or()". it wasn't obvious that "match()" was what I was looking for

I was instinctively looking for an SQLAlchemy like experience

Is it possible to create a policy that allows select from some columns to all users and other columns only to specific users?

It is possible, but you will need to combine RLS with column level security (i.e. RLS only is NOT enough). Search for a thread called "Column Level Security", there is info there how you can achieve this

Would it be fairly simple to migrate my data from my supabase database to a self-hosted one? Specifically, the auth user table that supabase provides with their auth. I will want to build my own auth out eventually without losing the current user data but I want to do it safely.

Maybe this can help you https://www.postgresqltutorial.com/postgresql-copy-database/

COPY

won't work against the

auth

schema, as the

postgres

user that's able to login to the database directly doesn't have the required permissions

Has anyone used PL/Python with Supabase?

Thanks 👍🏼

Returns

null

which i can't understand, anyone have a idea?

export async function getServerSideProps({ req }) {
  const { user } = await supabase.auth.api.getUserByCookie(req)

  console.log(user)

  return {
    props: {
      user,
    },
  }
}

Maybe the cookie just isn't there. You can check your cookies by checking in the Application tab in Dev tools. My best suggestion to understand how authentication works in supabase is to check their example app here: https://github.com/supabase/supabase/tree/master/examples/nextjs-with-supabase-auth

Hey everyone, I just signed up for Supabase from Firebase and loving it so far. HOWEVER, I seem to be having an issue with sending magic link emails. My Auth log shows the error below.

Message rejected: Sending paused for this account. For more information, please check the inbox of the email address associated with your AWS account.

I searched the repo issues and found one however, it looked like it was resolved a while ago so maybe not related to my issue. Any suggestions? TY in advance.

Thanks, i look into code a little bit why setting cookie from API? Is there any special reason for it?

I created a support ticket and got emails working again by using Sendgrid and the Custom SMTP option.

The cookie is created by passing the session to the

/api/auth

endpoint. A supabase function (setAuthCookie) is creating the cookie at the client side. This allows you to perform server-side actions (Eg. loading authentication profile information before the client loads)

Oh, that's nice. Thanks for the repo and help. I was concerned about

auth

before your help.

You can also check this supabase authentication guide, it might be helpful: https://ruanmartinelli.com/posts/supabase-authentication-react

just created a new supabase app and tried to add a user.... is there something i am missing here or are emails currently not working? thanks

i can't send out magic links either. I think theres a problem with supabase

do i need to enable my own custom smtp to use?

ah ok glad to know i am not alone. i was sweating bullets thinking i had misconfigured something

in the flutter channel another dude had the same thing. It's been down for a bit now