Postgres for Everything (e/postgres)

Keep It Simple Stupid, just use postgres.

Goals & Inspiration

The goal of this repository is to demonstrate how to use Postgres for Everything.

It's inspired by this article from the Amazing CTO as well as this GitHub gist from @cpursley.

Why maintain this list?

It seems like every week I hear of a new tool on top of Postgres or another way it can being used, so I wanted a place where I can keep track of everything. If you have other examples, submit a PR!

Table of Contents

Blog Posts & Articles
Cron Jobs
Message Queues
Analytics
GIS & Mapping
Audit Logs
Access Control & Authorization
Search
- Full Text
- Vector
Time Series
Column Oriented
NoSQL
Graph Data
Foreign Data
Alternative Query Languages
HTTP
APIs
Events, Replication, CDC
Caching
Unit Tests
HTML & Applications
Graphics & Visualizations
Migrations
Performance Tuning
Scaling & Storage
Dashboards & UIs
Data Visualization
Package Management
Language Servers
Miscellaneous
Bonus: How many items include Supabase?

Blog Posts & Articles

Cron Jobs

Message Queues

https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology
tembo-io/pgmq
SKIP LOCKED
riverqueue/river
sequinstream/sequin: Sequin is a tool for change data capture (CDC) in Postgres. Sequin makes it easy to stream Postgres rows and changes to streaming platforms and queues (e.g. Kafka and SQS). You can backfill existing rows and stream new changes in real-time.

Analytics

pg_analytics: Transforming Postgres into a Fast OLAP Database

GIS & Mapping

postgis/postgis

Audit Logs

Access Control & Authorization

arkhipov/acl
https://www.postgresql.org/docs/current/pgcrypto.html
michelp/pgjwt
supabase.com/docs/guides/database/vault)

Search

Full Text

Postgres Full Text Search (bunch of helpful links)
paradedb/paradedb
Postgres Full Text Search vs the rest

Vector

neondatabase/pg_embedding
pgvector/pgvector
tensorchord/VectorChord: PostgreSQL extension designed for scalable, high-performance, and disk-efficient vector similarity search. It serves as the successor to the pgvecto.rs project.

Time Series

Column Oriented

NoSQL

Graph Data

https://age.apache.org

Foreign Data

supabase/wrappers

Alternative Query Languages

HTTP

APIs

Events, Replication, CDC

The Notifier Pattern for Applications That Use Postgres
https://www.postgresql.org/docs/current/sql-notify.html
cpursley/walex (Disclosure: I maintain this and think it's pretty awesome)
PeerDB-io/peerdb
debezium/debezium
2ndQuadrant/pglogical

Caching

Unit Tests

HTML & Applications

SQLpage](https://github.com/lovasoa/SQLpage))
Omnigres](https://github.com/omnigres/omnigres))
pg_render](https://github.com/mkaski/pg_render))
plmustache](https://github.com/PostgREST/plmustache))

Graphics & Visualizations

pgSVG](https://github.com/dr-jts/pg_svg))

Migrations

Performance Tuning

Scaling & Storage

How Cloudflare Achieved 55 Million Requests per Second with Just 15 PostgreSQL Clusters!
supabase/supavisor
pg-sharding/spqr
orioledb.com/: OrioleDB is a PostgreSQL extension that combines the advantages of both on-disk and in-memory engines. It uses PostgreSQL pluggable storage to increase performance and cut costs.

Dashboards & UIs

Data Visualization

Package Management

Language Servers

supabase/postgres_lsp

Miscellaneous

Very comprehensive list of Postgres tooling
Unsupported PostgreSQL features in Aurora DSQL: AWS has a new database engine called Aurora DSQL, and explicitly listed what PostgreSQL features are not supported.

Bonus: How many items include Supabase?

11

sterngefeuert/postgres_for_everything

ErrorLooks like something went wrong!

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Error
Looks like something went wrong!

Packages