- 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
- https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology
- https://github.com/tembo-io/pgmq
- https://github.com/arkhipov/temporal_tables
- https://github.com/supabase/supa_audit
- https://github.com/pgMemento/pgMemento
- https://github.com/pgaudit/pgaudit
- 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
- Postgres Full Text Search (bunch of helpful links)
- https://github.com/paradedb/paradedb
- https://www.postgresql.org/docs/current/datatype-json.html
- https://github.com/robconery/dox
- https://www.ferretdb.com
- https://github.com/PostgREST/postgrest
- https://github.com/hasura/graphql-engine
- https://postgraphile.org
- https://supabase.github.io/pg_graphql
- 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
- https://github.com/purcell/postgresql-migrations
- https://www.bytebase.com/
- https://github.com/xataio/pgroll
- https://github.com/stripe/pg-schema-diff
I have been using https://github.com/sqitchers/sqitch for a while on production to handle migrations with Postgres it works perfectly.