The Architecture of a High-Performance GraphQL to SQL Engine

The Hasura platform’s data microservice provides an HTTP API to query Postgres using GraphQL or JSON in a permission safe way.

You can exploit foreign key constraints in Postgres to query hierarchical data in a single request. For example, you can run this query to fetch “albums” and all their “tracks” (provided the “track” table has a foreign key to the “album” table):

Source de l’article sur DZONE