Instant Realtime GraphQL API for PostgreSQL
Hasura connects to Postgres database and gives Instant Realtime GraphQL APIs
Powerful queries out-of-the-box
Queries
Query across tables & views with powerful filtering, pagination and pattern search.
Insert Mutations
Insert single or multiple objects. Make upsert operations on conflict to simplify app logic.
Update Mutations
Update objects based on a condition. Update to Increment/multiply directly.
Remove old product tags & insert new tags
Fetch first 5 brands with top 10 products for each
Realtime with subscriptions & live-queries
Convert any GraphQL query to a live query by using subscriptions.
1) Setup a GraphQL subscription
2) As Postgres data changes...
| Orders (postgres table) | ||
|---|---|---|
| order_id | payment | dispatched |
| XX-57 | true | NULL |
3) The UI is updated
| Order XX-57 (mobile/web UI) | ||
|---|---|---|
| Payment | ||
| Delivery | ... | |
Trigger webhooks on database events
Hasura captures changes to Postgres tables and triggers webhooks- Atomic capture, reliable delivery, horizontally scalable.
Add to an existing, live postgres database
Add Hasura to any existing postgres database as-is and expose select tables & views over GraphQL.
We took Gitlab CE (a complex rails + postgres application), hosted it on DigitalOcean and added GraphQL to it in just a few minutes. Check out the demo on the left!
View on Github Rails like Database migrations for Postgres
- Using Hasura Console in migration mode, the database migration files are automatically created.
- up/down migrations for going back and forth and reverting changes.
Optimise Postgres performance using explain
Hasura supports Postgres read replicas that can be used automatically to load-balance your GraphQL queries.
Manage Postgres data with Hasura Console
- Hasura comes with a Console admin UI that can be used to manage the database schema and adding/modifying records.
- The UI can also be used with CLI to manage database migrations automatically.
Postgres flavors and extensions that work with Hasura
Hasura works natively with different Postgres flavors and extensions
TimescaleDB - Timeseries Database
YugabyteDB - Distributed
Aurora Postgres - Serverless
PostGIS - Geo Postgres ExtensionJoin the community!
If you need any help with developing on Hasura, the 6000+ member strong Hasura Discord is here to help. Our community members include some very experienced engineers from some of the world’s most exciting companies, and many of them have been using Hasura in Production for a long time.
FAQ
What versions of Postgres does Hasura support?
v9.5 and above
Can I use multiple Postgres databases with the same Hasura instance?
Yes we can