Recursive CTEs in Postgres for Hierarchical Data Queries
Understand how Postgres executes recursive CTEs to query hierarchical data efficiently.
Daniel Kwiatkowski
Section
SQL and Query Writing
12 stories in SQL and Query Writing.
Detecting and Fixing N+1 Query Problems in Rails and Django ORMs
How lazy loading causes performance disasters and what tools catch them before production.
Priya Sundaram
Full-Text Search in Postgres Without Elasticsearch
Postgres tsvector and GIN indexes deliver full-text search power without external tools.
Daniel Kwiatkowski
Writing Idempotent SQL Data Migration Scripts
Ensure migrations run safely on retry by designing for final state instead of linear sequence.
Priya Sundaram
Common Table Expressions vs Subqueries in Postgres Performance
Postgres 12 changed how CTEs run, but the planner still stumbles sometimes.
Marcus Oyelaran
Lateral Joins in Postgres for Per-Row Subqueries
Unleash multi-row subqueries that see the current row's data.
Priya Sundaram
Window Functions in Postgres for Ranking and Running Totals
Postgres window functions let you rank rows and compute running totals without collapsing your data.
Marcus Oyelaran
JSON Query Patterns in Postgres With JSONB
Learn which Postgres JSON operators to use for fast queries and indexing.
Daniel Kwiatkowski
Writing Safe UPDATE and DELETE Statements in Production
Learn the two-stage safety loop that prevents destructive SQL mistakes in production.
Priya Sundaram
Aggregation Patterns for Business Metrics in SQL
Learn seven SQL patterns that solve nearly every business metric question executives ask.
Daniel Kwiatkowski
Writing Efficient Pagination Queries in Postgres
OFFSET pagination gets exponentially slower on large tables, while keyset pagination stays fast.
Daniel Kwiatkowski
SQL Joins Explained for Non-Engineering Team Members
LEFT JOIN finds the gaps your business actually needs to chase down.
Priya Sundaram