I understand the whole mechanism of setting the cookie, using the cookie in getServerSideProps etc, but I just can manage to make it work on the

/

path

Hey, how is it going? Quick question: I just tried to update my table to use realtime and rls but my client doesn't receive events despite the "everyone can read" policy. Is there anything I am missing?

realtime and RLS

Maybe I'm misunderstanding something or missing something obvious, but I can't get my avatar bucket files to update using from.update(). A new upload is fine, but when I use update using the same path/name I get a 404 error saying the resource not found. Here's my code between the two calls. Can anyone see what I'm doing wrong? Thanks!

Bucket API Help

hello everyone, i want implement follow and following. How do i go about implementing it?

I am having trouble inserting an array into a text array

Hello, I have trouble understanding what is the difference between those 2 requests, could someone drop a link with the sql references or explain it here please ? Have a good day

js
await $core.db.from('persona').update({ model: 450 }).match({ id: 1 });
await $core.db.from('persona').update({ model: 450 }).eq('id', 1);

The end result is the same for what you show. .match lets you have multiple columns as part of the object and uses an object. It is more a convenience thing as you don't need to build an object to use .eq on a single column.

I see, it's obvious said like that thank you

For some reason i keep getting a 403 (forbidden error) when attempting to insert to supabase table. Anyone know why?

403 forbidden error

https://supabase.com/docs/reference/javascript/or#use-or-with-and Could somebody explain this query to me?

.or('id.gt.20,and(name.eq.New Zealand,name.eq.France)')

Like this?

ID > 20 OR (name = ‘New Zealand’ AND name = ’France’) ?

Doesn't make sense to me that name could be New Zealand AND France (?)

Looks incorrect. I would expect it to be

.and('id.gt.20, or(name.eq.New Zealand, name.eq.France'))

I have a fairy complex one here https://github.com/jensen/chatatat/blob/15d4933a649f5c4ed159ef6f1becb18b4a745605/src/routes/conversations/%24id/messages.tsx#L32

It's making sure a direct message was either from a to b or from b to a.

Thanks! My use case is that I'd like to have all posts that are published and (a OR b) - I have RLS active, but as an admin I can see all posts 😉

ah yeah

that should work then..

Like the other way around from the example, but the AND at the end confused me

🌠 ed your repo btw 🙂

thanks! there are other examples in there as well

beeng trying out supbase for the past month or so

from_id.eq.${u?.id}

What happens if you query with

undefined

? Will it skip the rule? (if u is not defined)

It won't find anything as far as I can tell

this was a hackathon rush job, so no error handling lol

but yeah, if u is undefined I expect it not to find the item

in that loader it should actually handle the error higher up if the user doesn't exist

ok

> .and('id.gt.20, or(name.eq.New Zealand, name.eq.France')) But there is not .and available 🤔