HasuraCon'21 is over. Get the recordings

Introducing Cross Database Joins at the GraphQL Layer

Introducing Cross Database Joins at
the GraphQL Layer

Instant realtime GraphQL on all your data

Hasura is an open source service that gives you production-grade APIs on your data without having to build, operate & scale a GraphQL server.

Build apps and APIs 10x faster
Built-in authorization and caching
5x-50x more performant than hand-rolled APIs

250M+
downloads

Serving 10B+
API calls

23.6k
GitHub stars

Productize your data

From your databases to a unified GraphQL API in just one minute

Run Hasura, locally or in the cloud, and connect it to your new or existing databases to instantly get a production grade GraphQL API.

Developers and architects love Hasura because it takes no time to get started, doesn’t need them to be a GraphQL expert upfront, and saves their teams months of recurring effort in building, shipping and maintaining thier APIs.

Where do I put business logic?

mutation {
insert_products(objects:[{
name: "Product 1",
image: "product1.jpg"
}]) {
id
}
}

subscription fetchOrder {
order ( where: {id: {_eq: “XX-56”}})
{
id
payment
dispatched
}
}

subscription notifyOrderPlaced {
orders(
where: {
id: {
},
placed: {
}
}
)
}

Supported APIs

Coming Soon

Supported Databases

ENTERPRISE GRADE SECURITY

Built-in powerful authz: ready for external or internal API consumers

Hasura’s built-in RLS style authorization engine allows you to conveniently specify authorization rules at a model level, and safely expose the GraphQL API to developers inside or outside your organization.

Hasura’s authz engine is enabling agile teams in fast growing startups as well as powering mission-critical data access in highly regulated environments such as Fortune 500 healthcare, financial services and US federal agencies.

Can Hasura integrate with my authentication system?

Model name: Reviews

Role name: User

Allow reading an entity if:

{
“_exists”: {
“_table”:
{ “schema”: “public”, “name”: “product” },
“_where”: {
“_and”: [
{ “id”: { “_ceq”: [“product_id”] } },
{ “orders”:
{ “order”: { “user_id”:
{ “_eq”: “X-Hasura-User-Id” } } } }
]
}
}
}

Allow [user] to access [columns]:

5x-50x more performant

Blazing fast API performance, that’s remarkably easy to scale

Query compilation:
GraphQL queries are processed in a JIT compiler to create efficient queries that prevent N+1 problems

Authz predicate push-down:
Authorization policies are compiled into data access queries, avoiding multiple trips, and resulting in a massive performance boost in production

JSON aggregations:
Hasura avoids the cartesian product problem while fetching data from underlying systems by performing JSON aggregations in the upstream database itself

Scale-up and scale-out:
Get linear scalability, both vertically and horizontally, without any configuration

Does Hasura also automatically cache queries or data to improve performance?

KEY USE-CASES

Delivering on a deadline

Hasura is used in mission critical applications across Fortune 500 companies and is helping enterprise teams deliver on their strategic initiatives in an incremental, rapid and risk-free way.

Rapid Execution:
Build new applications or add new features to an existing application in days instead of weeks, using the power of GraphQL and self-serve access to data.

Read Philips Healthcare’s case study

Application Modernization:
Hasura automates 50-80% of your API development work, making your transformation project tractable and within a much shorter timeframe.

Read Optum’s case study

Data API vs Database Access:
Replace direct database access with a scalable, performant and secure data API to create a unified and federated “Core Data Service”

Read Cherre’s case study