Postgres is Enough

postgresql_is_enough.md

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

• https://github.com/citusdata/pg_cron
• https://github.com/cybertec-postgresql/pg_timetable

Message Queues

• https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology
• https://github.com/tembo-io/pgmq

GIS/Mapping

• https://github.com/postgis/postgis

Audit Logs

• https://github.com/arkhipov/temporal_tables
• https://github.com/supabase/supa_audit
• https://github.com/pgMemento/pgMemento
• https://github.com/pgaudit/pgaudit

Access Control & Authorization

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

Search

Full Text

• Postgres Full Text Search (bunch of helpful links)
• https://github.com/paradedb/paradedb

Vector

• https://github.com/neondatabase/pg_embedding
• https://github.com/pgvector/pgvector

Time Series

• https://github.com/timescale/timescaledb

Column Oriented

• https://github.com/hydradatabase/hydra
• https://github.com/citusdata/cstore_fdw

NoSQL

• https://www.postgresql.org/docs/current/datatype-json.html
• https://github.com/robconery/dox
• https://www.ferretdb.com

Graph Data

• https://age.apache.org

Foreign Data

• https://github.com/supabase/wrappers

Alternative Query Langauges

• https://github.com/kaspermarstal/plprql
• https://supabase.github.io/pg_graphql

HTTP

• https://github.com/pramsey/pgsql-http
• https://github.com/supabase/pg_net

APIs

• https://github.com/PostgREST/postgrest
• https://github.com/hasura/graphql-engine
• https://postgraphile.org
• https://supabase.github.io/pg_graphql

Events, Replication, CDC,

• https://www.postgresql.org/docs/current/sql-notify.html
• https://github.com/cpursley/walex (Disclosure: I maintain this and think it's pretty awesome)
• https://github.com/PeerDB-io/peerdb
• https://github.com/debezium/debezium
• https://github.com/2ndQuadrant/pglogical

Caching

• https://martinheinz.dev/blog/105
• https://github.com/readysettech/readyset

Unit Tests

• https://github.com/theory/pgtap
• https://github.com/peterldowns/pgtestdb

HTML and Applications

• SQLpage
• Omnigres
• pg_render
• plmustache

Graphics / Visual

• pgSVG

Migrations

• https://github.com/purcell/postgresql-migrations
• https://www.bytebase.com/
• https://github.com/xataio/pgroll
• https://github.com/stripe/pg-schema-diff

Performance Tuning

• Index Advisor
• Dexter
• HypoPG
• pg_hint_plan
• PGHero

Scalling

• How Cloudflare Achieved 55 Million Requests per Second with Just 15 PostgreSQL Clusters!
• https://github.com/supabase/supavisor
• https://github.com/pg-sharding/spqr

Dashboards / UIs

• Baserow
• NocoDB
• AppSmith

Data Visualization

• Evidence
• Metabase

Package Management

• https://github.com/pgxman/pgxman
• https://github.com/supabase/dbdev

Language Servers

• https://github.com/supabase/postgres_lsp

Miscellaneous

• Very comprehensive list of Postgres tooling

What's missing? Please share in the comments.

My Postgres collection, perhaps you'd like to use some of the items as well. Here is my list of Postgres blogs worth visiting regularly.

These are great @mjf, thanks! I added a link under miscellaneous.

I've recently put together the Rust crate postgresql-embedded that will allow you to embed PostgreSQL into an executable for use in environments where downloading the installation may not be an option.

@cpursley @kenfar checkout https://github.com/hydradatabase/hydra and https://github.com/paradedb/paradedb for analytics/column stores.

I have been using https://github.com/sqitchers/sqitch for a while on production to handle migrations with Postgres it works perfectly.