Advanced PostgreSQL: A Fast-Paced Revision Guide
JOINs to LATERAL, on one schema. Not for beginners.

Series
JOINs to LATERAL, on one schema. Not for beginners.

Fast reference for people who already write SQL daily. It covers aggregates, ordered and filtered aggregation, statistical functions, and multi-level grouping, all on one small schema.

You already know SELECT. This is the string toolbox I reach for daily when cleaning, parsing and reshaping text in Postgres, with the gotchas that actually bite in production. One schema, one dataset,

Dates are where "it works on my machine" queries go to die: DST shifts, month-end overflow, inclusive BETWEEN on timestamps, ISO-year mismatches. This is a fast, opinionated refresher for people who a

Window functions compute across a set of rows related to the current row without collapsing them like GROUP BY. This post assumes you know SQL. It is a dense reference with one schema and runnable exa

You already know SQL. This is the JSON/JSONB toolkit in Postgres, one schema, runnable queries, no fluff. 1. Schema Three tables. JSONB columns hold the semi-structured parts: user preferences, produ
