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

GraphQL schema on Postgres with foreign keys and without foreign keys

Blog post from Hasura

Post Details
Company
Date Published
Author
Shahidh K Muhammed
Word Count
515
Company Posts That Month
15
Language
English
Hacker News Points
-
Post removed?
No
Summary

The Hasura GraphQL Engine allows for modeling a graph using a relational database system like Postgres. It supports creating relationships between tables (nodes) using single-column foreign keys, multi-column foreign keys, or even without foreign keys. In the case of single-column foreign keys, Hasura's console suggests relationships over these columns and derives a GraphQL schema containing relation names for querying both tables in a single query. Relationships can also be created manually without a constraint, allowing for more flexibility when defining relations between tables. This enables GraphQL queries over extra information not necessarily constrained by foreign keys.

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.