Yeah, that's one of the things I've been looking at. I'm able to do everything via CURL, but in JS, it's just not working. I'm sure it's some very simple minor thing that I'm doing wrong, but I can't figure it out.

Hello ! If I want to create a query function from the SQL menu, they should be only written in SQL ? Are there any methods to write in python/javascript and execute it directly on the database (heard of it in a podcast, not sure if they were procedures or queries) ?

Hey! I am using Supabase's subscription feature to listen for INSERT changes to my database and update the frontend accordingly. This works perfectly when I make INSERTS from elsewhere in the frontend. However, when I make an equivalent cURL request (external to the browser/frontend, e.g. from another machine) to INSERT a row into the table that I'm subscribing to, the change is not picked up by the subscriber. Does anyone have any idea if this is supported behaviour? My goal is for IoT devices to be able to INSERT to the database, and have UIs that reactively update themselves following these INSERTs. If it helps, the cURL request is:

curl -X POST '${SUPABASE_DB_URL}/rest/v1/<db-name>' \
    -H "apikey: ${SUPABASE_ANON_KEY}" \
    -H "Authorization: Bearer ${SUPABASE_ANON_KEY}" \
    -H "Content-Type: application/json" \
    -H "Prefer: return=representation" \
    -d '{ "user_id": "<id>", ... }'

Other relevant info: Replication is enabled in the table in question. The cURL request works (a row is INSERTed).

Hi, is there any way to handle user already exist error in supabase?

I am getting proper error messages for invalid credentials and things like that, but I am not able to get error regarding user already exists 😦

Hello. When I am using

supabase.auth.setAuth(userToken.access_token)

Why the user is null? Everything looks good cause I can call table after that. Also the access_token retrieve should I update header with it everytime ? How the refresh token is working if we are using something custom? For me netlify function as proxy. Right now I am login set the token with the session on login. And i use the access token with setAuth

If I sign in with github as provider. How can I handle getting user info like username, avatar profile picture, etc, based on the user that signed in. On my authentication dashboard, I only see the email, and a supabase generated UID from that user, so confused how I would at least be able to use that info to do a separate fetch to github api

I am glad there is help in this channel 😒

@sockenguy Did you ever figure out what's wrong in those startup videos? I'm getting the 404 in the console, too. But I'm trying to follow a bunch of other videos and posts, too, some of which offer compete code examples, and I'm still getting the error.

Hi; Does anyone know how to set a users password with a service key; without logging in as that user?

I am aware of this:

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

But this sends a reset password mail

This is great for the user to update their own password

const { user, error } = await supabase.auth.update({password: 'new password'})

Setting a users password with a service key

Additional information from third party sign in provider

Handling user already exists error

Is there a way to delete a row and automatically delete any associated rows from other tables? Or must the associations be deleted separately in an api call before deleting the whole row

How i change the behaviour of saving token in local storage?

Different storage destination for tokens

do free databases pause if no request is sent?

Database pauses

hey, I cannot log into supabase right now, anyone else experiencing those problems?

I'm also experiencing problems with this, on oauth. @User

hi..we are fixing this now

thanks for reporting

Thank you. Is it a quick fix or should I go do something else?

fix should go out in a minute

nothing needs to be done on your side

Alright, thanks!

fixed, thanks. @User