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 Stored Procedures 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.

Templates

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

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

Example Apps

• chronicle - tracking a tree of personal memories

• code-du-travail-backoffice - data administration portal for the official French Labor Code and Agreements

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

• elm-workshop - building a simple database query UI

• ember-postgrest-dynamic-ui - generating Ember forms to edit data

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

• ext-postgrest-crud - browser-based spreadsheet

• general - example auth back-end

• goodfilm - example film API

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

• handsontable-postgrest - an excel-like database table editor

• heritage-near-me - Elm and PostgREST with PostGIS

• ng-admin-postgrest - automatic database admin panel

• pgrst-dev-setup - docker-compose and tmuxp setup for experimentation.

• postgres-postgrest-cloudflared-example - docker-compose setup exposing PostgREST using cloudfared

• postgrest-demo - multi-tenant logging system

• postgrest-example - sqitch versioning for API

• postgrest-sessions-example - example for cookie-based sessions

• postgrest-translation-proxy - calling to external translation service

• postgrest-ui - ClojureScript UI components for PostgREST

• postgrest-vercel - run PostgREST on Vercel (Serverless/AWS Lambda)

• PostgrestSkeleton - Docker Compose, PostgREST, Nginx and Auth0

• 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

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

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

External Notification

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

• pg-bridge - Amazon SNS

• pg-kinesis-bridge - Amazon Kinesis

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

• pgsql-listen-exchange - RabbitMQ

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

• postgresql-to-amqp - AMQP

• postgresql2websocket - Websockets

• skeeter - ZeroMQ

Extensions

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

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

• postgrest-auth (criles25) - email based auth/signup

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

• postgrest-oauth - OAuth2 WAI middleware

• postgrest-oauth/api - OAuth2 server

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

• spas - allow file uploads and basic auth

Client-Side Libraries

• aor-postgrest-client - JS, admin-on-rest

• elm-postgrest - Elm

• general-angular - TypeScript, generate UI from API description

• jarvus-postgrest-apikit - JS, Sencha framework

• mithril-postgrest - JS, Mithril

• ng-postgrest - Angular app for browsing, editing data exposed over PostgREST.

• postgrest-client - JS

• postgrest-csharp - C#

• postgrest-dart - Dart

• postgrest-ex - Elixir

• postgrest-go - Go

• postgrest-js - TypeScript/JavaScript

• postgrest-kt - Kotlin

• postgrest-py - Python

• postgrest-request - JS, SuperAgent

• postgrest-rs - Rust

• postgrest-sharp-client (needs maintainer) - C#, RestSharp

• postgrest-swift - Swift

• postgrest-url - JS, just for generating query URLs

• postgrest_python_requests_client - Python

• postgrester - JS + Typescript

• postgrestR - R

• py-postgrest - Python

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

• vue-postgrest - Vue.js