- Hasura is awesome! Especially the relationships. It took a while before it clicked but I don't see myself going back to joins. Also permissions are really powerful.
- Nhost stack allows you to do more complex stuff than with Supabase.
Cons:
- The documentation can sometimes be a bit unclear. Comparing to Supabase they can really improve on this.
- Deploying migrations can be a pain. Took a while before it clicked.
- Not a big community (yet). But they are growing.
I've been using Hasura.io (through nhost.io) for quite some time now and I think it would suit your needs very well. It is very good in handling complex relationships with subscriptions.
Pros:
- The team is very approachable and responsive.
- Hasura is awesome! Especially the relationships. It took a while before it clicked but I don't see myself going back to joins. Also permissions are really powerful.
- Nhost stack allows you to do more complex stuff than with Supabase.
Cons:
- The documentation can sometimes be a bit unclear. Comparing to Supabase they can really improve on this.
- Deploying migrations can be a pain. Took a while before it clicked.
- Not a big community (yet). But they are growing.