Bulk inserts, update & delete on conditions.
Import existing databases.
Postgres View to GraphQL.
Add multiple roles and role-based permissions.
“git push” to apply migrations
Hasura's GraphQL engine compiles GraphQL queries into optimal SQL queries and avoids the (n + 1) queries pitfall. It also exploits multiple cores and can scale vertically and horizontally.
If each user makes an API call every seconds,
a DigitalOcean - droplet running Hasura can support 3200 active users.
Read more about the high-performance architecture here.
Create relationships between tables, or between tables and views.
Create aggregations and joins with views to query on "derived" data.
Make self-referencing relationships for tree-like data like comments.
Store schemaless data in JSON columns.
pg_dumpand import into Hasura's postgres instance with
psql. Read the docs here. If you have a different database, you'll have to convert it to postgres first using tools like these.