PostgreSQL Locks: Deadlocks, Object-Level Locks, and Predicate Locks

Engineers Detail Technical Hurdles of Rewriting PostgreSQL Database Engine in Rust

Developers attempting to rewrite PostgreSQL in Rust have documented significant technical challenges, including a 12–15% CPU overhead introd

PostgreSQL Connection Pooling Explained: How It Works and Why It Matters

PostgreSQL Connection Pooling Explained: How It Works and Why It Matters

Something you probably want to know about if you're using SQLite in Golang

I recently published an article on how a code using database/sql can easily deadlock. That article started multiple interesting conversation

The Gold Standard, Evolved: What's New with PostgreSQL and Why It's Still Your Go-To Database

A journey through the PG Ecosystem since 2020

The transactional outbox pattern: keeping a database and Kafka consistent

Wrote this up after one too many "the row updated but the event never fired" incidents. It walks through why the dual-write problem is unavo

Key PostgreSQL Queries to Detect Silent Database Degradation Early

A technical guide published on DEV Community outlines how PostgreSQL databases can degrade silently without triggering standard monitoring a