Rootconf proposals for round the year in 2018

Rootconf proposals for round the year in 2018

On DevOps, security, cloud and IT infrastructure

Tanmai Gopal


Building Hasura: Instant realtime, high-performance GraphQL on Postgres

Submitted Jul 19, 2018

Hasura is an open-source engine that gives developers instant GraphQL on a new or existing Postgres database. This GraphQL server can handle upwards of a 1000 requests per second, even for deeply nested queries, with an extremely low resource footprint of 50-60MB of RAM.

Hasura does this by taking a unique approach of compiling GraphQL queries instead of resolving them. This results in huge-performance benefits.

In this talk, I’ll touch upon the design of the system, the structure of the GraphQL query and Postgres optimizations that can be leveraged and share other engineering learnings as we built Hasura.


  • Brief introduction to GraphQL
  • Why Postgres and GraphQL go well together
  • Designing GraphQL query syntax
  • Preventing n+1 queries
  • Handling authorization
  • Postgres optimisations to speed up GraphQL query execution

Speaker bio

Tanmai is the co-founder of He is a StackOverflow powered fullstack, polyglot developer whose areas of interest and work span react, nodejs, python, haskell, docker, postgres, kubernetes. He is passionate about making the power of building things accessible to everyone and is the instructor of India’s largest MOOC with over 250,000 students.

You will occasionally see him speaking, or more often being quietly awkward, at conferences and meetups. He has recently moved to the Bay Area and Bangalore, just like everyone else.



{{ gettext('Login to leave a comment') }}

{{ gettext('Post a comment…') }}
{{ gettext('New comment') }}
{{ formTitle }}

{{ errorMsg }}

{{ gettext('No comments posted yet') }}

Hosted by

We care about site reliability, cloud costs, security and data privacy