How to select multiple tables in toddle (supabase).

unicodes · 2024-07-20T13:50:25.759+00:00

I have two tables and i need to slect them (first is note and second users, where note.user_id = users.id). I want to get all notes where date = YYYY.MM.DD and for each note I want the user info from users (select * users). For other situation I used views, but in this case I can not use views (supabase), is there a way to query multiple tables in toddle?

unicodes
1 year ago
I have two tables and i need to slect them (first is note and second users, where note.user_id = users.id). I want to get all notes where date = YYYY.MM.DD and for each note I want the user info from users (select * users). For other situation I used views, but in this case I can not use views (supabase), is there a way to query multiple tables in toddle?
Max
1 year ago
This is more of a supabase question as this is not specific to Toddle. You can perform a lookup in your REST call. You can check their docs: https://supabase.com/docs/guides/database/joins-and-nesting?queryGroups=language&language=url
🙏1
unicodes
1 year ago
Hello @Max it works! Thank you! I would like to ask what is the best way from you experience to query the database? Is this solution "URL" a performant and good one? What would you recommend?
@unicodes
Hello @Max it works! Thank you! I would like to ask what is the best way from you experience to query the database? Is this solution "URL" a performant and good one? What would you recommend?
Max
1 year ago
Yes, this is the way to go 🙂 Either that or views in Supabase
unicodes
1 year ago
Thank you Max! I found out also functions, have you tried them?
Max
1 year ago
Yes, functions are also performant als they are executed on the Postgresql level. But for a simple use case like lookups there is not need to create a function

How to select multiple tables in toddle (supabase).

unicodes

Max

unicodes

Max

unicodes

Max