Postgres is Enough

postgresql_is_enough.md

PostgreSQL is Enough

• Just Use Postgres for Everything
• Simplify: move code into database functions
• Hacker News discussion

Background and Cron Jobs

• https://github.com/citusdata/pg_cron

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

• https://github.com/arkhipov/acl

Authorization

• https://www.postgresql.org/docs/current/pgcrypto.html
• https://github.com/michelp/pgjwt

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

Graph Data

• https://age.apache.org

Foreign Data

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

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

Unit Tests

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

HTML and Applications

• SQLpage
• Omnigres
• pg_render
• plmustache

Graphics / Visual

• pgSVG

Migrations

• https://github.com/purcell/postgresql-migrations
• https://www.bytebase.com/

Dashboards / UIs

• Baserow
• NocoDB
• AppSmith

Data Visualization

• Evidence
• Metabase

Language Servers

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

What's missing? Please share in the comments.