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.
janbjorge/pgqueuer: PgQueuer is a Python library leveraging PostgreSQL for efficient job queuing.

Analytics

GIS & Mapping

postgis/postgis

Audit Logs

Access Control & Authorization

Search

Full Text

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

Vector

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.
timescale/pgai: PostgreSQL extension to allow RAG, semantic search and other AI application development from within postgres. Based on pgvector.
timescale/pgvectorscale: DiskANN vector index implementation complementary to pgvector.

Time Series

Column Oriented

NoSQL

Graph Data

https://age.apache.org

Foreign Data

supabase/wrappers

Alternative Query Languages

HTTP

pramsey/pgsql-http
supabase/pg_net

APIs

Events, Replication, CDC

Caching

Unit Tests

HTML & Applications

Graphics & Visualizations

pgSVG

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

Bonus: How many items include Supabase?

11

minh123viptanvan/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