Yeah, I’m not great with database architecture. I actually failed DB like 3 times in college. 😦 How would you structure for users, user profile comments, episode comments, movie comments, reviews… I would make (profile) comments a nested collection on user collection, reviews a nested collection on movies collection and tv show collection, comments a nested collection on movies collection, tv show collection, and tv episode (which would be a nested collection on the tv show collection)…

Collections are like, subtables I guess?

i'd say you should probably look into graphql as a query language for complex nested queries like this. supabase offers a full graphql endpoint for you to use. tables are just setup as you would set up any table with foreign keys.

Ugh I hate graphql. I’m a rest boi.

from my understanding firebase doesn't use sql, its a document storage layout isn't it?

Right. It’s more like json. I hate SQL.

also, this is going really in deph, so i suggest to you make a post in the right channel, and you will probably get the answer.

that makes supabase probably not right for you.

Hi, I try the OPENAI case example, I got stuck at set Vector extension to database , any tips?

try to create a post on the help and questions channel.

nice, I will write down for it

how to get support from supa base?

write a ticket on https://app.supabase.io/support/new

In relational database these would just be related tables, we don't tend to do nesting in relational databases (although you can with a jsonb type column). You would essentially model your database in a way that related tables have an identifier that matches its parent table record. Supabase uses PostgREST for its querying in its SDK and that can return the results as nested json if your tables are modelled correctly. Do note you should continue any follow up questions in #1006358244786196510.

Yeah, maybe not. :/ I really do like the document storage type system of Firebase better. I like how Supabase is posting the latest videos and tutorials for how-to with Next.js 13 SSR though.

anyone? 😄

😄

It forgot to say it's experimental and some answers may not be completely correct.

That's because it's experimental 😄

Hate it when this happens to an API I've been using for 10 years. Use it a forum I hate maintaining to begin with... Also means every post in one of the forums has now lost the image that went with it.

Oh no, its really hard when depending on third party APIs but sometimes you can't start building without them.

Yeah they actually served the little images of a webpage and the snips were just a url to their site. Not sure I'll bother finding another solution, probably will just turn of the image feature.

Time to build your own.

I love how Supabase went all 80s synth disco themed.

They clearly know how to partay

A custom hook I write using useQuery combine Supabase. Are you have the better solution to write?

hi, how do i enable team plan on my subscription?

Please ask on #1006358244786196510 . This is off-topic chat only.

its not directly the right channel but i think its funny to my defence i am learning 😄 ( i whant a channel fail of the day) 1h debugging reseting root server setting up local env i whas so sure that my code isnt at fault there is no way need to be anything else

js
const { user, error } = await supabase.auth.getUser()

why is user always empty.....