All topics

Join tables

Vizualinx

5 months ago

How do I join Supabase tables?
Tom Ireland

5 months ago

If using the API, you can use the select query. You would add the table name and then columns in brackets.

The PostgREST docs have some information on this where Supabase is lacking: https://docs.postgrest.org/en/v12/references/api/resource_embedding.html#foreign-key-joins
@Tom Ireland
If using the API, you can use the select query. You would add the table name and then columns in brackets.

The PostgREST docs have some information on this where Supabase is lacking: https://docs.postgrest.org/en/v12/references/api/resource_embedding.html#foreign-key-joins
Vizualinx

5 months ago

Thanks!
Would you be able to share a screenshot how it would look in toddle?
@Vizualinx
Thanks!
Would you be able to share a screenshot how it would look in toddle?
Tom Ireland

5 months ago

Sure! It's pretty much the same format as in the docs. Here's an example call to my developers table (without the Supabase base URL). This is a deeper join because tool_id in the developer_tools table is linked to records in the tools table.

/developers?profile_complete=eq.true&select=first_name,last_name,country_code,bio,developer_tools(tool_id:tools(name,tool_url))
@Tom Ireland
Sure! It's pretty much the same format as in the docs. Here's an example call to my developers table (without the Supabase base URL). This is a deeper join because tool_id in the developer_tools table is linked to records in the tools table.

/developers?profile_complete=eq.true&select=first_name,last_name,country_code,bio,developer_tools(tool_id:tools(name,tool_url))
Vizualinx

5 months ago

Got that, I just don't get how to do it in the toddle UI ..
Tom Ireland

5 months ago

Query params
profile_complete and select are query params. The rest in between is the values I'm providing, which includes columns and the joining by table name.
Tom Ireland

5 months ago
One trick I use is to pass each column as an array item in a formula and then convert to string. You get your commas for free then and it makes it easier to add/remove columns instead of typing in the field.
@Vizualinx
How do I join Supabase tables?
Lucas G

5 months ago

Same thing as what you say the other day on the video lol. It's a supabase (technically PostgREST) feature, it's the same everywhere 😂
select (*), table-two(*)
That would pull everything from first table and everything from second table
Vizualinx

5 months ago

Ohhh, got it. Just need to put it all in one line.

Thanks guys!
👍1
Tod

5 months ago

Great energy @Vizualinx! Your continuous contribution to the toddle Community just made you advance to Community Level 16!

Join tables

Vizualinx

Tom Ireland

Vizualinx

Tom Ireland

Vizualinx

Tom Ireland

Tom Ireland

Lucas G

Vizualinx

Tod