Skip to content

BFF(Backend For Frontend) with GraphQL generated its DB schema (postgres) by sqlc.

License

Notifications You must be signed in to change notification settings

tk42/bff-gqlgen-sqlc-template

Repository files navigation

bff-gqlgen-sqlc-template

BFF(Backend For Frontend) with GraphQL generated its DB schema (postgres) by sqlc.

  • 99designs/gqlgen
  • vektah/dataloaden
  • kjconroy/sqlc

Quickstart

  1. Create .graphql
    1. Create a new project in hygraph / strapi
    2. Edit the schema on the browser
    3. Fill ACCESS_TOKEN, ENDPOINT in .env.local
    4. docker compose run export creates schema.graphql
  2. Generate autostub codes in /gen
    1. Write schema.sql
    2. Write queries.sql
    3. Edit generate code for each model in dataloaders/generate.go
    4. Generate files in /gen by docker compose -f docker-compose.autogen up
  3. Fill the autostub codes.
    1. Write resolver/resolvers.go to pass queries to detaloaders and mutations to repository
    2. Fill repository/relations.go only for entities with relations
    3. Fill dataloaders/dataloaders.go
  4. To migrate tables, write down DDL in schema.sql on pgweb

Run GraphQL Server

docker compose up

Then access Playground.

If you want to see raw database or query it, you can access pgweb

If you want to try GraphQL API with Insomnia, you can import Insomnia.yaml.

Special thanks

fwojciec/gqlgen-sqlc-example

About

BFF(Backend For Frontend) with GraphQL generated its DB schema (postgres) by sqlc.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published