okay, i get it.

containedBy means the provided array must contain the full array of the record queried

not exactly what I'm looking for

What I need is a filter that will return all records whose tags array contains one or more of the tags in the array provided in the query. .contains is close to this, except it will only return records that contain all of the provided tags. [apples, oranges] in the query will not return a post that has [oranges] as it’s tags

that sounds like

.overlaps()

return record as long as any element overlaps

Hey fellas, I'm struggling with the setup of Google Auth consent screen It keeps warning me about validating the Supabase callback domain https://cnpxxxxxxxxxxxxxxvss.supabase.co/auth/v1/callback How do you verify this authorised redirect url?

The only info i was able to gather is: > Note: If you are using a third party service provider and your domain is owned by them, then you need to provide a detailed justification for us to validate it.

Does Supabase support Discord Auth?

I believe so. there's a discord toggle in the auth settings of the dashboard

Yup https://supabase.io/docs/guides/auth/auth-discord

Hi guys, I'm having a problem with inconsistent ways to access user's id after signup. I have 2 supabase project and they access user id as such: Using supabase Python: res = db.auth.sign_up(email=email, password=password) Project 1 access user Id using user_id = res["user]["id"] Project 2 access user Id using user_id = res["id"] Anyone knows why this is happening?

hey everyone, i am running subscriptions to changes to a few tables to refetch data. The subscriptions work and they notify me, but the side effect function of fetching the data does not work ( supabase select). also a second question, when should i unsubscribe? Does not say much in the docs, right now im subscribing on mount of the component

thanks you. a lot of the doc links are weirdly hard to find @_@

Hi m trying to use the reset password feature. l receive the email, and when i click it it redirects me to my 'update-password' page successfully. but l am not sure how to capture the token from that URL before it gets redirected to my app is there way to fetch the URL being sent to the user so that i can capture the token from it?

Is there a way to limit the total amount (in bytes) a user can upload? I understand that we can't add policies that limit the size of a single upload since metadata isn't calculated until after the upload is complete. But once it has successfully uploaded, I am able to get a sum of the total bytes used. What would stop me from writing a policy based on that sum?

fixed

I am unable to disable email confirmation for a new user when creating the account. The save button does not work when attempting to save email authentication settings.

same here! the save button doesn't seem to work

Good to know it’s not just me. I have tried several browsers and none of them worked.

Hey there! I can't find a solution for this, hoping that somebody has already gotten this error. I'm building an app that has to update multiple rows at once. I used the following function like so: const { data, error } = await supabase .from('projects') .upsert([{"id": 1, "name": "updated-project-1"}, {"id": 2, "name": "updated-project-2"}]) But this gives me an error with RLS: { "hint": null, "details": null, "code": "42501", "message": "new row violates row-level security policy for table \"notes\"" } But in fact, it doesn't violates it. Since when I update the items in the array one by one (send multiple await supabase.from().update().eq()), it works perfectly. I couldn't find a reason why upsert should not work.

Okay, I've found the solution 😄 Sometimes, it's best to write the problem down. I've used the upsert function to update multiple items once. Every item in there is already created. So I thought I wouldn't need to add the row to the data, which indentifies the user. Now it works, like this: const { data, error } = await supabase .from('projects') .upsert([{"id": 1, "name": "updated-project-1", "user_id": 123 }, {"id": 2, "name": "updated-project-2", "user_id": 123 }])

Check if you have RLS policy for

select

because after the insert or update the api will try to fetch you back the record so it does also a select query

Good catch

Ah, makes sense. Yes, it's also enabled for select. Haven't thought about that!

If anyone can help with this issue, that'd be great! https://discord.com/channels/839993398554656828/869406062036529193/880984159487664159

is there a simple way to use the

refreshAccessToken

function over api? I have a native client sending the apikey, Authorization & and refresh_token via a POST request but i returns

message: 'Invalid Refresh Token'

How do I continue local development while my application is live. Asking for auth. I have set the base url and also additional urls in the settings but the redirect always happen to the base url set. In my case I want the redirect to happen to localhost now without breaking the live application.

The same thing happened to me, I have realized that the supabase api takes care of this automatically. However, when checking the headers sent in the request, I see that it has sent an invalid refresh_token, and not the one I have stored in local storage. Why is this happening? And how to avoid it?

Is there a way to handle 401 errors from the Supabase JS client? I am overriding the JWT token and need to handle when the token expires. I dont want to wrap every single query in a wrapper which try catches unless I absolutely need to