Hey all, I have what I feel is a pretty simple task but I'm struggling to make sense of the PostgREST docs. Essentially, I have a column` 'voters'` within a

'projects'

table, which is structured as an array` ["tom", "mike", ...]` and I'm trying to filter only rows which contain

"mike"

(for example). How would this be achieved using the REST API?

PostgREST array includes

Hey guys I'm getting an Error 400 when trying to access a file from a public bucket. What am I doing wrong with the policies? @User

Here's the policy

I am accessing the URL from the session which is logged in

Is is possible to use postgresql functions like

jsonb_array_length

in filters?

await supabase.from('posts').select('slug, comments!inner(*)', { count: 'exact' })
      .eq("slug", query.slug)
      .gt("jsonb_array_length(comments.content->notes)", 0)

@eMeRiKa u can use a stored procedure to write that query

ha yeah ok I need to use the rpc, thanks

Is there any easy way to get the whole row from just knowing it's id without getting all the rows?

https://supabase.com/docs/reference/javascript/eq I'd really recommend reading through the docs for questions like this

Ok, thanks

I feel like I'm missing something simple here... I have a sveltekit app and need to invite users by email. I send the email from the dashboard and click on the link. I have a redirect to my local dev server. All works well except I can't workout how to get the new user to set up a password. Any hints would be greatly appreciated. Arggh - const { error } = await supabase.auth.update({ password }) NOT const { user, error } = await supabase.auth.update({ email, password })

can anyone help me with this please 😅

400 error on public bucket

is there a way to fetch all databases of a project? Their names

Is there an easy way to upload a file from to a bucket?

Fetch database of a project

upload file to bucket

check dms please @silentworks

Please create a thread here and ask your questions here

Listen to real-time subscription using containedBy (or cs)

Does

supabase.auth.onAuthStateChange()

fire an event every time at some point after the page initially loads? For example, if the user is already logged in and visits the page, does an event fire immediately after supabase determines this? Or do events only fire when signing in or signing out is explicitly called?

onAuthStateChange events

Hi everyone! I'm new to development so I appreciate all the help 🙂 I've started learning with Svelte.js and have grown to love it while using supabase as a backend for my simple blog site. I'm using just the fetch functions to get data from my sb db. The issue I was running into was building my blog post page. When requesting the information it would be returned as an array. Upon doing some research I found that it could be possible to get a single object back by changing the "Accept" header to "application/vnd.pgrst.object+json". It appeared to fix it but then I started getting a 401 which appears to be a CORS issue. Some guidance on this would be great since I've been stuck on this for 3+ days. Thanks!! 😄

I keep getting an

Error confirming user

with a 500 status when trying to use

verifyOTP

(this used to work, but today isnt). Has anyone else been experiencing this?

I have a verifyOTP test setup and just ran it on a new user to success.

it used to work but suddenly stopped for me

i get a different error if the verify code is wrong or of the phone number is wrong/doesn't exist

is there a doc on this library