Hello everyone, I have a question, I'm using Supabase with Nextjs plus one of these (Netlify or Vercel) and I'm having a hard time to make the deploy-previews to work with Supabase auth, I mean if I put my public/production url on the Site URL box, all my deploy-previews or branch-previews redirect to the production site, so that doesn't work for testing, if I change my Site URL to match a deploy/branch preview, obviously the production site doesn't work, what's the approach everyone is following for this or there is no solution? Thanks in advance

Hi All, I have a quick question, what's the best way to query a jsonb field which is an array of objects?

the jsonb array of objects has an object which always has the field name and I want to make a query that selects based on the name provided

so I want to return each record with the name "John Doe" for example

Hey! After successfully authenticating with Discord, session data are automatically set in localstorage. But after the token expires, the user needs to authenticate with Discord again. Am I suppose to refresh the token on the client side? Is there any tutorial about this?

It should auto-refresh itself

it refreshes, but if the user doesn't interact with the website for more than 1 hour, he needs to authenticate again.

what is strange is that localstorage is empty when I reopen the website after one hour. I'm on localhost, but it shouldn't matter, right?

Yes this is correct behaviour.

ah okay I see. yes, it makes sense. But after signing in back with an auth provider, the user should be automatically logged in and shouldn't have to go through the oauth flow again. (maybe this is specific to the Discord oauth flow)

I haven't tried the discord auth flow, but yes they shouldn't go through the entire oauth flow again

even though the app I created is listed under the authorised in my Discord account I still need to authorise it every time I sign in with Discord. @User do you have the same problem?

after doing some research, I think that supbase-js is using the implicit grant flow (https://discordjs.guide/oauth2/#implicit-grant-flow) which requires the user to "to explicitly re-authorize when the access token has expired".

Hey, I've been trying to insert few details into supabase, but it gives me an error stating "invalid type for uuid" can anyone let me know what am I missing (edit) : removed the error message, since it contained some personal infomation

id ad user_id are uuid in supabase

Invalid type for uuid error

Hello, receiving an empty array with js. How to fix? let { data: categories, error } = await supabase .from('categories') .select('*')

Is there anything in your categories table?

Do you have RLS on? If so and you have not set up a select policy, you will get back an empty array.

If you just turn RLS on the default is no access at all - just a reminder. If you flip that RLS switch you’re shutting down all access to that table. Which could be exactly what you want - just be aware.

Is possible to batch update with a filter with Supabase JS package? One request with 1000 rows to update with own match() filters. MongoDB alternative is

.bulkWrite(array)

Hello I am relatively new to supabase and was wondering what is the supabase alternative of signInWithPopup method of firebase auth

Can anyone pls help me with this ?

Google Auth docs: https://supabase.io/docs/guides/auth/auth-google

I got basic auth part What i want is to sign in using a popup so i dont lose the state of my page

Popup like a modal?

No

Check the 5th point