Instant Multi-Tenant GraphQL APIs with PostGraphile, RLS, and PropelAuth

• postgraphile-propelauth-starter

  1 0 10.0 TypeScript
  

The coolest part of this whole project is how extensible it is. You can fork the starter template, edit and apply the schema.sql file, enter a few environment variables, and you’ll have a full secure, multi-tenant GraphQL API and a Next.js App where you can write your queries.

• dbmate

  25 4,345 8.1 Go

  :rocket: A lightweight, framework-agnostic database migration tool.

For managing the schema, you’ll likely want to use a tool like dbmate or Flyway, which can help you update the database over time. For this tutorial, we’ll just create it directly:

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• pg-simplify-inflector

  1 87 3.4 JavaScript

  Simplifies the graphile-build-pg inflector to trim the `ByFooIdAndBarId` from relations

  

To set up our project, we install Express, PostGraphile, and pg-simlify-inflector, which PostGraphile recommends for all new projects

• Flyway

  81 7,763 7.2 Java

  Flyway by Redgate • Database Migrations Made Easy.

  

For managing the schema, you’ll likely want to use a tool like dbmate or Flyway, which can help you update the database over time. For this tutorial, we’ll just create it directly:

Suggest a related project