- 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://github.com/citusdata/pg_cron
- https://github.com/cybertec-postgresql/pg_timetable
- https://github.com/crunchydata/pg_incremental
- 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/postgresml
- 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://github.com/microsoft/documentdb
- 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
- https://github.com/nexsol-technologies/pgassistant
- Index Advisor
- Dexter
- HypoPG
- pg_hint_plan
- PGHero
- https://codeberg.org/Data-Bene/StatsMgr
I'm the author of QueenMQ, a C++ queue system backed by Postgres; we replaced Kafka with it in some of our B2B SaaS products.
Is also available as pg extension, that reproduce Kafka semantics directly from SQL. So you can use it without the server and the client, if needed.