Data & Databases

Queries that lie, keys that leak, and pipelines that quietly drop rows.

From the desk

Data & Databases

PgBouncer Prepared Statement Already Exists: Escaping the Pooling Prepared-Statement Collision

Database applications that combine a connection pooler with a client library that auto-tracks prepared statements discover quickly that the two reuse strategies do not mix. Without matching…

Data & Databases

Why Time-Ordered UUIDv7 Helps Your Indexes — and What It Costs

Newly specified UUIDv7 changes the front of the identifier from random pattern to time sequence, which changes how keys cluster in indexes. For database administrators weighing primary key…

Data & Databases

Keyset Pagination Skipping Rows: How to Avoid Row Skipping and Duplicates When Data Moves

Offset pagination is a common approach to fetching rows in chunks for an interactive feed. But it has a hidden problem: the page boundaries are not anchored to any actual rows, so when the…

04
Data & Databases
SQL NOT IN Returns No Rows for Subquery with One NULL
SQL's NOT IN operator can silently return no rows if its subquery has as much as one null. That's because the NOT IN predicate behaves like a chain of <> comparisons, all of which…

Data & Databases

From the desk

PgBouncer Prepared Statement Already Exists: Escaping the Pooling Prepared-Statement Collision

Why Time-Ordered UUIDv7 Helps Your Indexes — and What It Costs

Keyset Pagination Skipping Rows: How to Avoid Row Skipping and Duplicates When Data Moves

SQL NOT IN Returns No Rows for Subquery with One NULL