Ecosystems:
PostgreSQL
PostgreSQL is Awesome!
This repository contains resources I found during my journey with PostgreSQL.
Postgres-based databases
- Citus - Distributed PostgreSQL as an extension
- Apache AGE - Postgres extension - Graph database optimized for fast analysis and real-time data processing
- Google - Run AlloyDB anywhere - in your data center, your laptop, or in any cloud
- Supabase - Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage
- Neon
Hosting
Partitioning
- Postgres Documentation - Table Partitioning
- EDB - Postgres Table Partitioning
- David Rowley - Partition Elimination in PostgreSQL 11
- Amit Jain - How to Take Advantage of the New Partitioning Features in PostgreSQL 11
- pgDash - PostgreSQL 11 Partitioning Improvements
- StreamBright - Creating partitions automatically in PostgreSQL
- Daniel Westermann - PostgreSQL 14: Automatic hash and list partitioning?
- Denish Patel - Is there a limit on number of partitions handled by Postgres?
- AWS - Managing PostgreSQL partitions with the pg_partman extension
- Automatically Creating Partition in PostgreSQL
- Workable Tech Blog - Postgres — Live Table Partitioning
- AWS - Partition existing tables using native commands in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL
- Azure - Azure Database for PostgreSQL : Logical Replication
WAL
Logical Replication
- Gunnar Morling - The Wonders of Postgres Logical Decoding Messages
- AWS - Using logical replication to replicate managed Amazon RDS for PostgreSQL and Amazon Aurora to self-managed PostgreSQL
- Fujistsu - How PostgreSQL 15 improved communication in logical replication
- Amit Kapila - Replication Improvements In PostgreSQL-14
- Thiago - How to use Change Data Capture (CDC) with Postgres
- Ramesh naik E - Change Data Capture(CDC) in PostgreSQL
- Percona - The 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot
- Konstantin Evteev - Recovery use cases for Logical Replication in PostgreSQL 10
- Several9s - Using PostgreSQL Logical Replication to Maintain an Always Up-to-Date Read/Write TEST Server
- Wal2Json - JSON output plugin for changeset extraction
- AWS Database Blog - Stream changes from Amazon RDS for PostgreSQL using Amazon Kinesis Data Streams and AWS Lambda
- PGDeltaStream - Streaming Postgres logical replication changes atleast-once over websockets
- Hrvoje Milković - Replicate PostreSQL data to Elasticsearch via Logical replication slots
- Azure Database for PostgreSQL—Logical decoding and wal2json for change data capture
- Npgsql - Logical Replication
- Postgresql To Kinesis For Java - Disney Streaming
Queuing
- pg-boss - Queueing jobs in Node.js using PostgreSQL like a boss
- Adriano Caloiaro - Choose Postgres queue technology
Locks
- Chris Hanks - Turning PostgreSQL into a queue serving 10,000 jobs per second
- Alvaro Herrera - Postgres - Waiting for 9.5 – Implement SKIP LOCKED for row-level locks
- Vlad Mihalcea - How do PostgreSQL advisory locks work
- Marco Slot - When Postgres blocks: 7 tips for dealing with locks
- Marco Slot - PostgreSQL rocks, except when it blocks: Understanding locks
- Nickolay Ihalainen - PostgreSQL locking, Part 1: Row Locks
- Nickolay Ihalainen - PostgreSQL locking, part 2: heavyweight locks
- Nickolay Ihalainen - PostgreSQL locking, part 3: lightweight locks
Scaling
JSON
Keys
Testing
Security
- Paul Ramsey - Generate Unlimited Crypto Using Postgres!
- Marco Pegoraro - Per-User Encryption with Postgres
WASM
- Supabase - Postgres WASM by Snaplet and Supabase
- WASMer - Postgres library to run WebAssembly binaries
Wire Protocol
Releases
Execution Plans
API
JavaScript
Caching
- Martin Heinz - You Don't Need a Dedicated Cache Service - PostgreSQL as a Cache
- Greg Sabino Mullane - PostgreSQL Unlogged Tables - Look Ma, No WAL!
Clients
NPM
Badges
Extracted from project README
