SQL Window Functions in PostgreSQL: Running Totals, Rankings, and the End of Self-Joins
Every reporting query has a moment where GROUP BY stops being enough. You need the aggregate and the row it
Tag: PostgreSQL
PostgreSQL Connection Pooling: PgBouncer Modes, Pitfalls, and Production Config
PostgreSQL connections are expensive. Each backend process consumes roughly 10 MB of resident memory, holds a socket, and runs a
Continue readingPostgreSQL Connection Pooling: PgBouncer Modes, Pitfalls, and Production Config
Pagination at Scale: Choosing Between Offset, Keyset, and Cursor Strategies
Pagination is one of those API design decisions that seems trivial until your dataset grows. Return everything at once and
Continue readingPagination at Scale: Choosing Between Offset, Keyset, and Cursor Strategies
Change Data Capture with Debezium: Streaming Database Changes to Kafka
Every production database tells a continuous story — orders placed, statuses updated, accounts created. But most applications treat their database
Continue readingChange Data Capture with Debezium: Streaming Database Changes to Kafka
PostgreSQL Indexing Strategies: Choosing the Right Index for Every Query
Most production performance problems in database-backed applications trace back to the same root cause: missing or misused indexes. Not slow
Continue readingPostgreSQL Indexing Strategies: Choosing the Right Index for Every Query
5 Trending GitHub Repos: A 744B Model in Pure C, Postgres in Rust, and Python Compiled to Metal
Every week, the open-source community ships projects that make you stop and think — sometimes because they’re audacious, sometimes because
Change Data Capture with PostgreSQL and Debezium: Building Reliable Event Pipelines
Every application that updates a database and then does something else — pushes to a search index, invalidates a cache,
Continue readingChange Data Capture with PostgreSQL and Debezium: Building Reliable Event Pipelines
PostgreSQL 19 Beta 1: GROUP BY ALL, REPACK CONCURRENTLY, and What Else Is Coming
Editor’s note, September 2026: PostgreSQL 19 is still in beta as of this update — Beta 3 shipped on August
Continue readingPostgreSQL 19 Beta 1: GROUP BY ALL, REPACK CONCURRENTLY, and What Else Is Coming
pg_durable: Durable Workflows Inside PostgreSQL Without External Infrastructure
Every backend team eventually builds the same thing: a rickety scaffolding of cron jobs, background workers, message queues, and status
Continue readingpg_durable: Durable Workflows Inside PostgreSQL Without External Infrastructure
PostgreSQL 18 Features That Change How You Write Queries
Editor’s note (September 12, 2026): Everything below still checks out against the official PostgreSQL 18 release notes — verified feature-by-feature,
Continue readingPostgreSQL 18 Features That Change How You Write Queries