Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

You need a foreign key constraint on the user_uploaded_contents table. Then you can use this:
```js
supabase.from("user_public").select("*, contents:user_uploaded_contents(*)")
```
If you are getting a could not find a relationship, be sure to add a foreign key on the user_uploaded_contents table for the user_public table.

`contents:user_uploaded_contents(*)` i never understood this syntax can you please explain it to me?

I could do such direct relationship, but I wondered if I can do it indirectly using user_id cause it simplifies inserting. but if it's not possible so be it. maybe I'll use stored procedure

Because I have many relationships in my database I tend to use this

so in <select> u give it a comma seperated list of column names

nevermind, I didn't know that table 'user_uploaded_content' can refer to the same 'user_id' column on 'user_public'. I thought I had to refer user_public.id

A more advanced example
```typescript
  const [data] = await supabase
    .from("activities")
    .select(
      `*, 
      result:activity_flow_${mode}_results(*),
      nodes:activity_flow_node_${mode}_results(*, node:flow_nodes(*)),
      node_statistics:activity_flow_node_${mode}_statistics(node_id, statistic),
      tries:activity_flow_try_${mode}_results!activities_tries_activity_id_fkey(*, 
      last_node_tries:flow_node_${mode}_tries!flow_node_tries_try_id_fkey(*))`
    )
```