i have used foreign key for user

in messages table

Ah nvm rookie mistake

Had turned on RLS and forgot to add policies

I thought it wud error out tho instead it just returns null in joins and an empty array if i query that table directly

Does the download button in the storage dashboard work properly? Wasted a good hour, because the downloaded file would only have "null" in them, only to find out that if you just open the link you'd get the file with the correct content. I've set the correct content type, is there something I'm missing? Context: Happens with text files with the default content type and json files when content type is set to applicaton/json, when writing a string, haven't checked if this happens when you upload the file with the content directly

@User just launched his project on product hunt! lets show him some love for supporting the community by boosting everyone's projects! https://www.producthunt.com/posts/made-with-supabase

Has anybody else problems with the API, for me nothing is responding to any calls. Also I can't send magic links...

Whoo! Hacktoberfest completed

so you can delete objects from storage and the public url still owrks

that doesn't seem right

Deleted objects from storage still has a working public url

Hi

Just wonder is there anything for the js library or does

select()

work the same way

I think this sentence is incomplete, can you clarify what you are asking please?

Oh as in

select()

selects the entire row

The one in stackoverflow returns a count/ a result which states one

Lesser data transferred is better right?

trying to understand the use of foreign key for storage. I see that storage queries accept the path to the stored object. So, what's the use of having its foreign key in the database?

It’s still unclear what you are asking

As in

select()

selects all the data. Is it possible to just do a

count()

without doing a select

Yes you can create a function to do this and call it via .rpc

I see okay thanks. Probably just sticking with just plain ol select. Doesn't seem like its worth that much to just count it when select does the trick

select() accepts a second parameter which allows exactly what you need - it's name is a little strange: "head"

for example: supabase.from('cities').select('*', { head: true, count: exact }) - this should return only the count of cities

Which is the best way to contact Supabase for event support/ sponsorships?

Wow thanks!

😄

guys, what do I do here?

nvm, figured it out