Folders and files

Name		Name	Last commit message	Last commit date
Latest commit History 1,392 Commits
.cargo		.cargo
.ci		.ci
.github		.github
bin		bin
dockerfiles		dockerfiles
docs		docs
sql		sql
src		src
test		test
.clang-format		.clang-format
.dockerignore		.dockerignore
.gitignore		.gitignore
.pre-commit-config.yaml		.pre-commit-config.yaml
Cargo.lock		Cargo.lock
Cargo.toml		Cargo.toml
LICENSE		LICENSE
README.md		README.md
docker-compose.yaml		docker-compose.yaml
mkdocs.yaml		mkdocs.yaml
pg_graphql.control		pg_graphql.control

Repository files navigation

`pg_graphql`

Documentation:https://supabase.github.io/pg_graphql

Source Code:https://github.com/supabase/pg_graphql

pg_graphql adds GraphQL support to your PostgreSQL database.

Performant
Consistent
Serverless
Open Source

Overview

pg_graphql reflects a GraphQL schema from the existing SQL schema.

The extension keeps schema translation and query resolution neatly contained on your database server. This enables any programming language that can connect to PostgreSQL to query the database via GraphQL with no additional servers, processes, or libraries.

TL;DR

The SQL schema

createtableaccount(    idserialprimary key,    emailvarchar(255)not null,    created_attimestampnot null,    updated_attimestampnot null);createtableblog(    idserialprimary key,    owner_idintegernot nullreferences account(id),    namevarchar(255)not null,    descriptionvarchar(255),    created_attimestampnot null,    updated_attimestampnot null);createtypeblog_post_statusas enum ('PENDING','RELEASED');createtableblog_post(    id uuidnot null default uuid_generate_v4()primary key,    blog_idintegernot nullreferences blog(id),    titlevarchar(255)not null,    bodyvarchar(10000),    status blog_post_statusnot null,    created_attimestampnot null,    updated_attimestampnot null);-- This enables default inflection, which automatically renames-- snake_case to PascalCase for type names, and snake_case to camelCase for field names.-- See https://supabase.github.io/pg_graphql/configuration/#inflection for more details.COMMENT ON SCHEMA public ISe'@graphql({"inflect_names": true})';

Translates into a GraphQL schema displayed below.

Each table receives an entrypoint in the top levelQuery type that is a pageable collection with relationships defined by its foreign keys. Tables similarly receive entrypoints in theMutation schema that enable bulk operations for insert, update, and delete.