- 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.
Maybe https://hasura.io is something to have a look at? It's a GraphQL server that gives you realtime GraphQL API's over Postgres/SQL.
I've been trying out https://nhost.io for some time now. They use Hasura and I'm impressed by how easy subscriptions are using Apollo to query the GraphQL API.
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.