Home / Companies / Hasura / Blog / Post Details
Content Deep Dive

Architecture of a high performance GraphQL to SQL engine

Blog post from Hasura

Post Details
Company
Date Published
Author
Sandip
Word Count
1,449
Company Posts That Month
4
Language
English
Hacker News Points
-
Post removed?
No
Summary

The Hasura platform's data microservice provides a HTTP API to query Postgres using GraphQL or JSON in a permission safe way. It is designed for high performance with fast response times, large throughput, and low CPU and memory usage. A GraphQL query goes through stages of session resolution, query parsing, validation, execution, and response generation. The architecture aims to minimize HTTP stack overhead, enable efficient query translation from GraphQL to SQL, generate efficient Postgres compiled SQL queries, and efficiently send back results. Optimizations include batching queries, using joins for data collection, optimizing response generation by pushing transformations into Postgres, and utilizing prepared statements. These enhancements result in significant performance benefits compared to other architectures.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.