Postgres is Enough

postgresql_is_enough.md

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• Just use Postgres
• 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
• https://github.com/crunchydata/pg_incremental

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

• https://github.com/pgvector/pgvector
• Vecto: Hybrid Search with Postgres (pgvector) and Elixir (Ecto)
• Postgres Full Text Search (bunch of helpful links)
• https://github.com/paradedb/paradedb
• https://github.com/postgresml

Time Series

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

Column Oriented

• https://github.com/paradedb/paradedb/tree/dev/pg_analytics
• https://github.com/paradedb/paradedb/tree/dev/pg_lakehouse
• https://github.com/hydradatabase/hydra
• https://github.com/citusdata/cstore_fdw

NoSQL

• https://github.com/microsoft/documentdb
• https://www.ferretdb.com
• https://github.com/event-driven-io/Pongo
• https://www.postgresql.org/docs/current/datatype-json.html
• https://github.com/robconery/dox

Graph Data

• https://age.apache.org
• https://github.com/edgedb/edgedb

Foreign Data

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

Custom Types

• pgPDF: pdf type for Postgres

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 (subscribe to Postgres WAL events - powers Appraisal Inbox)
• 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

• https://github.com/nexsol-technologies/pgassistant
• Index Advisor
• Dexter
• HypoPG
• pg_hint_plan
• PGHero
• https://codeberg.org/Data-Bene/StatsMgr

Scaling

• How Cloudflare Achieved 55 Million Requests per Second with Just 15 PostgreSQL Clusters!
• https://github.com/supabase/supavisor
• https://github.com/postgresml/pgcat
• https://www.pgbouncer.org/
• 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

In-Browser & WASM

• https://github.com/electric-sql/pglite
• https://github.com/instantdb/instant

Miscellaneous

• Very comprehensive list of Postgres tooling

What's missing? Please share in the comments.

For scaling: https://github.com/postgresml/pgcat

For search: https://github.com/postgresml

For RAG/ML/AI: https://github.com/postgresml

recommend adding https://anyblockers.com/posts/postgres-as-a-search-engine under #Search

Edgedb should be in there somewhere.

I would love to see some self hosting best practices and gotchas!

https://codeberg.org/Data-Bene/StatsMgr was just introduced as advanced statistics management

GIS/Mapping: https://github.com/pgRouting

Cloud native Postgres: https://cloudnative-pg.io/

Worth mentioning pgroonga for advanced multilingual search https://pgroonga.github.io/

Great repo - @cpursley !!

I’d suggest adding this 5-part blog series on advanced data science with PostgreSQL window functions:
https://data-nerd.blog/tag/window-functions/

Covers ranking, rolling stats, gaps/islands, and more—pure SQL, no external tooling. Could fit under Analytics or Advanced SQL with PostgreSQL.