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: SQL
Apache Iceberg vs Delta Lake vs Hudi: Choosing Your Lakehouse Table Format
The data lakehouse has gone from contested idea to default architecture in just a few years, and the table format
Continue readingApache Iceberg vs Delta Lake vs Hudi: Choosing Your Lakehouse Table Format
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
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
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