PostGraphile Quickstart

This page contains a quickstart to help you get PostGraphile up and running with Postgres Container Apps on Crunchy Bridge. We recommend you start with the quickstart to get an understanding of container apps.

About PostGraphile

From the project:

Instant lightning-fast GraphQL API backed primarily by your PostgreSQL database. Highly customisable and extensible thanks to incredibly powerful plugin system. Formerly “PostGraphQL”.

PostGraphile with Postgres Container Apps Quickstart

First ensure you have Container Apps enabled with CREATE EXTENSION pgpodman;. Once enabled you’ll need your DATABASE_URL from Crunchy Bridge to include in the command. To start your PostGraphile you can run:

SELECT run_container('-dt -p 5433:5000/tcp -e DATABASE_URL="<DATABASE_URL>"  t');

Now you can visit your running PostGraphile at your hostname:5433.