# PostgreSQL is Enough

- [Just Use Postgres for Everything](https://www.amazingcto.com/postgres-for-everything/)
- [Simplify: move code into database functions](https://sive.rs/pg)
- [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

- 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](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

## 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](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

## 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)

## Language Servers

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

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