PostGraphile (formerly PostGraphQL) builds a powerful, extensible and performant GraphQL API from a PostgreSQL schema in seconds; saving you weeks if not months of development time.
Documentation: https://www.graphile.org/postgraphile/usage/
- https://github.com/graphile-contrib/postgraphile-plugin-connection-filter
Used to add a powerful suite of filtering capabilities to a PostGraphile schema. - https://github.com/graphile/pg-aggregates
Used to add a powerful suite of aggregate functionality to a PostGraphile schema: calculating aggregates, grouped aggregates, applying conditions to grouped aggregates, ordering by relational aggregates, filtering by the results of aggregates on related connections, etc.
AWS RDS used to run Postgres
(https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html)
- The image is stored on Docker hub (https://hub.docker.com/)
- The Google Cloud Run is used to run the container (https://cloud.google.com/run)
- Restrict access to running GCR service to only authenticated users
- Enable JWT authentication for PostGraphile
- Enable VPC Egress for Cloud Run Service