3 ms·
I tried it via Supabase (open source Firebase clone that uses PostgREST under the hood). At the time there was no join support which was incredibly limiting, an
by 0x62 5y ago
I tried it via Supabase (open source Firebase clone that uses PostgREST under the hood). At the time there was no join support which was incredibly limiting, and we ended up using Hasura instead.
Overall though, the user experience was generally very good and we still use it for some smaller standalone components on otherwise static websites (e.g. a mailing list signup form) where you don't need complex joins.
- andix 5y agoCan’t you use views for joins? Usually you should be fine with a few views, in most schemas, there are just a limited amount of tables you can join in a meaningful way.
- kiwicopple 5y ago> no join support Perhaps you mean no left-join support? There has been support for inner-join support in PostgREST for a few years :) (example: https://supabase.com/docs/reference/javascript/select#query-foreign-tables https://supabase.com/docs/reference/javascript/select#query-...)