Keep it simple, use Postgres for everything.
The goal of this repository is to demonstrate how to use Postgres for Everything.
It's inspired by this article from the Amazing CTO as well as this GitHub gist from @cpursley.
It seems like every week I hear of a new tool on top of Postgres or another way it can being used, so I wanted a place where I can keep track of everything. If you have other examples, submit a PR!
- Blog Posts & Articles
- Cron Jobs
- Message Queues
- Analytics
- GIS & Mapping
- Audit Logs
- Access Control & Authorization
- Search
- Time Series
- Column Oriented
- NoSQL
- Graph Data
- Foreign Data
- Alternative Query Languages
- HTTP
- APIs
- Events, Replication, CDC
- Caching
- Unit Tests
- HTML & Applications
- Graphics & Visualizations
- Migrations
- Performance Tuning
- Scaling
- Dashboards & UIs
- Data Visualization
- Package Management
- Language Servers
- Miscellaneous
- 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
- SKIP LOCKED
- https://github.com/riverqueue/river
- 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
- Postgres Full Text Search vs the rest
- https://www.postgresql.org/docs/current/datatype-json.html
- https://github.com/robconery/dox
- https://www.ferretdb.com
- Using JSONB in PostgreSQL®: How to Effectively Store & Index JSON Data in PostgreSQL
- https://github.com/kaspermarstal/plprql
- https://supabase.github.io/pg_graphql
- https://github.com/dosco/graphjin
- https://github.com/PostgREST/postgrest
- https://github.com/hasura/graphql-engine
- https://postgraphile.org
- https://supabase.github.io/pg_graphql
- The Notifier Pattern for Applications That Use Postgres
- 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