- 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
Great repo - @cpursley !!
I’d suggest adding this 5-part blog series on advanced data science with PostgreSQL window functions:
https://data-nerd.blog/tag/window-functions/
Covers ranking, rolling stats, gaps/islands, and more—pure SQL, no external tooling. Could fit under Analytics or Advanced SQL with PostgreSQL.