Community Tutorials

• Building a Contacts List with PostgREST and Vue.js - In this video series, DigitalOcean shows how to build and deploy an Nginx + PostgREST(using a managed PostgreSQL database) + Vue.js webapp in an Ubuntu server droplet.

• PostgREST + Auth0: Create REST API in mintutes, and add social login using Auth0 - A step-by-step tutorial to show how to dockerize and integrate Auth0 to PostgREST service.

• PostgREST + PostGIS API tutorial in 5 minutes - In this tutorial, GIS • OPS shows how to perform PostGIS calculations through PostgREST Functions as RPC interface.

• “CodeLess” backend using postgres, postgrest and oauth2 authentication with keycloak - A step-by-step tutorial for using PostgREST with KeyCloak(hosted on a managed service).

• How PostgreSQL triggers work when called with a PostgREST PATCH HTTP request - A tutorial to see how the old and new values are set or not when doing a PATCH request to PostgREST.

• REST Data Service on YugabyteDB / PostgreSQL

• Build data-driven applications with Workers and PostgreSQL - A tutorial on how to integrate with PostgREST and PostgreSQL using Cloudflare Workers.

• A poor man’s API - Shows how to integrate PostgREST with Apache APISIX as an alternative to Nginx.

Templates

• compose-postgrest - docker-compose setup with Nginx and HTML example

• svelte-postgrest-template - Svelte/SvelteKit, PostgREST, EveryLayout and social auth

Example Apps

• delibrium-postgrest - example school API and front-end in Vue.js

• ETH-transactions-storage - indexer for Ethereum to get transaction list by ETH address

• general - example auth back-end

• guild-operators - example queries and functions that the Cardano Community uses for their Guild Operators’ Repository

• PostGUI - React Material UI admin panel

• prospector - data warehouse and visualization platform

DevOps

• cloudgov-demo-postgrest - demo for a federally-compliant REST API on cloud.gov

• cloudstark/helm-charts - helm chart to deploy PostgREST to a Kubernetes cluster via a Deployment and Service

• cyril-sabourault/postgrest-cloud-run - expose a PostgreSQL database on Cloud SQL using Cloud Run

• eyberg/postgrest - run PostgREST as a Nanos unikernel

• jbkarle/postgrest - helm chart with a demo database for development and test purposes

External Notification

These are PostgreSQL bridges that propagate LISTEN/NOTIFY to external queues for further processing. This allows functions to initiate actions outside the database such as sending emails.

• pg-notify-stdout - writes notifications to standard output (use in shell scripts etc.)

• pg-notify-webhook - trigger webhooks from PostgreSQL’s LISTEN/NOTIFY

• pgsql-listen-exchange - RabbitMQ

• postgres-websockets - expose web sockets for PostgreSQL’s LISTEN/NOTIFY

• postgresql2websocket - Websockets

Extensions

• aiodata - Python, event-based proxy and caching client.

• pg-safeupdate - prevent full-table updates or deletes

• postgrest-node - Run a PostgREST server in Node.js via npm module

• PostgREST-writeAPI - generate Nginx rewrite rules to fit an OpenAPI spec

Client-Side Libraries

• postgrest-csharp - C#

• postgrest-dart - Dart

• postgrest-ex - Elixir

• postgrest-go - Go

• postgrest-js - TypeScript/JavaScript

• postgrest-kt - Kotlin

• postgrest-py - Python

• postgrest-rs - Rust

• postgrest-swift - Swift

• redux-postgrest - TypeScript/JS, client integrated with (React) Redux.

• vue-postgrest - Vue.js