At a guess, from the examples, selects/updates/deletes all

countries

which have both

computers

and

minerals

specified in their

main_exports

column

oh, that makes plenty of sense

i was thinking it was a match on an array as a field

So I have a tags array field on my posts table, i.e,. "food", "recipe", etc. And I need a way to select posts that match a provided array of tags. Anyone know of the api to do that? I'm not seeing anything similar in the docs.

when you mean 'match', do you mean an exact match, or just having one array a subset of the other?

i think

.contains

or

.containedBy

might be what you need, depending on which direction the subsetting should be

I'll be looking for a subset So ["apples", "oranges"] Would return anything that contained both or one of those.

if

['apples', 'oranges']

is your provided array, then https://supabase.io/docs/reference/javascript/containedby might do it?

const { data, error } = await supabase
  .from('posts')
  .select()
  .containedBy('post_tags', ['apples', 'oranges'])

which gives posts that only have 'apples' and/or 'oranges' as a tag

I tried that and it was throwing an error but I’ll try again

Thanks for the insight

it works, you saved the whole week @User

I can enter data in the database but when a new user wants to register I get a 403. What can be the reason?

Does it make sense to add a GraphQL layer on top of Supabase? I mean, it seems deep relationships are handled pretty well:

js
const { data, error } = await supabase
  .from('countries')
  .select(`
    name,
    cities (
      name
    )
  `)

could be because u didnt enable email-signup

anyone deploy supabase in aws???

this one aws issue? about my env. secret

right. i am a idiot. thx

I would deeply appreciate if someone helps me setting up the Twitter API with my supabase application (see https://github.com/supabase/supabase/discussions/2961). Would also pay for the time!

How do I add list of uuid to supabase sql column?

[{uuid_1}, {uuid2}, ...] doesn't work for me

@Azura, the column type is uuid[] ?

Hey guys, was wondering if anyone has had any luck with pushing data to an array using the supabase library on a node server, does anyone know how this would work?

Yeah

hi im trying to create a policy where a role "Admin" can update the profiles table I tried it using the UI in supabase, and added, profiles.role_id = 1 in the USING expression and left the WITH CHECK EXPRESSION BLANK. but it still doesnt let me update in the frontend. :/

I turned RLS off for now

Is there a way to restrict the size and/or amount of images a user can upload to Supabase storage?

You probably can by creating a function and trigger that checks the

storage.objects

table before insert, I haven't tested this myself but it should be possible.

sweet, we had a similar high level idea 🙂 We want to prevent malicious users from uploading too many images

Or you can allocate uploading to the server side and do the check before the upload starts. I need to check with the Supabase Team about the storage upload lifecycle because I'm not sure if the insert into the

storage.objects

table happen before the upload is completed or after.