- 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
- 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
- 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/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
- 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
- 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 (subscribe to Postgres WAL events - powers Appraisal Inbox)
- 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
Amazing list, very helpful.
Scaling section can be improved further.
Connection Pools and Load balancers: (similar to Supavisor added by you)
PgCat
PgBouncer
PgPool-II
Sharding:
Citus can be under scaling as well due to sharding capability.
I am not sure below Postgres derivatives can be part of the list as they are not open source but they are part of Postgres compatible scaling solutions.
Distributed Postgres flavors:
Yugabyte
Multi-master Postgres derivatives for scaling :
Spock
EDB Postgres-distributed
AWS PGACTIVE