Hey there! 👋 I just started with Supabase as a Frontend Dev and I really like it as BaaS. I try to get a big picture over all the authentication methods and got questions. Currently, I'm building an app where users should sign up & sign up only via email and password. I've a

posts

table where RLS is enabled without policies. I'd like to handle all the authorization logic in my servless backend with NextJS. Now, I have an endpoint

/create-post

. Only administrators should be able to create a post. Therefore I implemented the following logic. Let's assume a user with the role

administrator

is logged in. As far as I realized, the session is stored in local storage. 1. Question: to make a

POST

request to the endpoint, I need to send the JWT with the request, because on my server, I do not have access to it via cookies right?

ts
      await axios.post('/api/create-post', {
        headers: {
          authorization: session?.access_token || '',
        },
        body: ...
      })

2. Question: the

session

object comes from

supabase.auth.session()

where I can take the access token. Is this a good practice to call that function or is it redundant to

supabase.auth.user()

? 3. Question: In my serverless function, I want to fetch the user from Supabase via

const { user } = await supabase.auth.api.getUser(req.headers.authorization)

. I saw in a video that this step is necessary to establish a session:

supabase.auth.session = () => ({ access_token: req.headers.authorization })

but it is hacky and not TS conform. Is the alternative and better solution to use the

service_role

key due to the fact that this is not exposed to the public anyways? I'm very grateful for answers, thanks guys!

I'm trying to do a very simple workflow with magic links: 1) User requests a magic link: let { user, error } = await supabaseClient.auth.signIn({ email: email }) 2) User receives email and clicks link. After authentication user is redirected to our site. 3) Try to get user on the client using: supabaseClient.auth.user() But no user is returned (it's null). What am I doing wrong?

magic link redirect, no user

can I use this server side? https://supabase.com/docs/reference/javascript/storage-from-upload#upload-file I'm getting a constraint error in the

owner

column.

upload from server

getting data from two tables that are not directly linked by a foreign key

I have data from an API being mapped in my frontend. These objects have individual keys/ids. On my database, I have data that needs to be mapped and shown next to the relevant objects. How would I do that? Feel free to answer in the thread.

Hi Guys! Question....let's say I am trying to do an insert, and I want to also insert a new foreign key row at the same time....is that common/possible/desirable? Example: Add a new restaurant name, and a category for that restaurant, that doesn't yet exist. I'm trying to do it this way, and it fails:

const { data, error } = await supabase
      .from('restaurants')
      .insert([
        { name: val,
          restaurant_categories: {
            category: newCategory
          }
        },
      ],
      { upsert: true })

I'm probably going about it the wrong way, so I'm looking for whatever the correct/best practice is.

How can I insert a new restaurant, belonging to a new category, in one insert? Or should I expect to be able to do that?

You will need to run two inserts or use an rpc call and function with two sql inserts. The call will be run as a transaction so both inserts need to succeed for success which is usually what you want.

Ok, cool, thanks!

Appreciate the quick reply.

Man, that can get pretty intense if there is data being added to like 5 or 6 tables at one time.

update mutliple tables

ping!

Anyone know any good React components/libraries that for editors (Markdown)? I'm looking for an editor similar to that of Stackoverflow.com or Github.com.

Did some digging and found this in case anyone else finds it useful, found this https://github.com/JefMari/awesome-wysiwyg/blob/master/readme.md#for-react

Looking for some advice. I'm using Google Signin. At the moment of signin I require users to provide one piece of information. Once signin is complete I want to have access to the information to save to a database with the user_id. But there is a page refresh in between. So my question is how to pass it through this chain. I thought about the redirect url as a query param, and that works with the

Site URL

but I can't work out how to use it with the

Additional Redirect URLs

in the auth settings

in other words, a redirect to

https://abc.netlify.app/?x=y

works, but https://localhost:3000/?x=y does not

with signUpByEmail the SDK provides ways of doing this for you, but signUp does not exist, as such, got oauth methods

How do I implement "Remember Me" functionality? My thought was to use sessionStorage instead of localStorage but how do I point supabase there? (Using nextjs/react if that matters)

Implementing Remember Me

i am getting error for subscribing for android 10 in react-native any idea .subscribe((status, e) => console.log(status, e)) i got: status= RETRYING_AFTER_TIMEOUT ,error= undefined and then status= SUBSCRIPTION_ERROR ,error= undefined

Subscription error

hey since 2 days my upload function doesn't work anymore. i can upload but the data is broken. I didn't change my code just did minor supabase upgrade. I use blob format to upload do you have same issue ? if i save the blob in my computer just before send the format is correct.

the weird part is there on supabase admin

image/png - 2 bytes

when i check before send i have

image/png

my upload is pretty simple

await supabase
      .storage
      .from('images')
      .upload(`${userId.value}/${file.name}`, blob, {
        contentType: file.mimeType,
      })

it's seems if i remove custom fetch it fix the issue. maybe relate to the last change in supabase storage