SQL Articles

An illustration of a grand old library reading room, where a small front table holds a handful of books beside a placard captioned 'Is That Really All?', while endless shelving packed with far more books recedes into shadow behind it

Why total Alone Can’t Tell You a Paginated List Hit Its LIMIT

2026.10.01

Say you’re building an API that lists orders…

An illustration of a rotating airport baggage carousel beneath a large station clock, captioned 'Missing. No Error.', where a single suitcase keeps circling forever while every other bag has already been claimed

A WHERE updated_at > ? Sync Drops the Rows That Commit Late

2026.09.14

Say you’re moving order rows from one system…

thumbnail: illustration of two pc users and a robot

The Statistics Behind Every SQL Query

2025.01.29

DBMS and the Query Optimizer Hi, I’m Aki Mat…