# PostgreSQL is Enough

- [Simplify: move code into database functions](https://sive.rs/pg)
- [Just Use Postgres for Everything](https://www.amazingcto.com/postgres-for-everything/)
- [PostgreSQL is the worlds’ best database](https://www.2ndquadrant.com/en/blog/postgresql-is-the-worlds-best-database/)
- [Postgres is eating the database world](https://medium.com/@fengruohang/postgres-is-eating-the-database-world-157c204dcfc4)
- [Hacker News discussion](https://news.ycombinator.com/item?id=39273954)

## 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](https://gist.github.com/cpursley/e3586382c3a42c54ca7f5fef1665be7b) (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](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 / Visual

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

## 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](https://github.com/supabase/index_advisor)
- [Dexter](https://github.com/ankane/dexter)
- [HypoPG](https://github.com/HypoPG/hypopg)
- [pg_hint_plan](https://github.com/ossc-db/pg_hint_plan)
- [PGHero](https://github.com/ankane/pghero)

## Scalling

- [How Cloudflare Achieved 55 Million Requests per Second with Just 15 PostgreSQL Clusters!](https://levelup.gitconnected.com/how-cloudflare-achieved-55-million-requests-per-second-with-just-15-postgresql-clusters-2d8a28ffd100)
- https://github.com/supabase/supavisor
- https://github.com/pg-sharding/spqr

## Dashboards / UIs

- [Baserow](https://baserow.io)
- [NocoDB](https://github.com/nocodb/nocodb)
- [AppSmith](https://appsmith.com)

## Data Visualization

- [Evidence](https://evidence.dev)
- [Metabase](https://metabase.com)

## 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](https://gist.github.com/mjf/d885e3631c3eaa8a5a9ea62c5c20407c)

# What's missing? Please share in the comments.