PostgreSQL
Plan Advice in PostgreSQL 19
There is a conversation that happens in every PostgreSQL shop eventually. A query that has been fine for a year gets slow overnight. Nothing was deployed. The data grew a …
tag
SQL
17 posts
PostgreSQL
Getting Ready for PostgreSQL 19
PostgreSQL 19 Beta 3 shipped on August 13, 2026, and the release notes have been filled in as of 2026-07-18 — still marked subject to change, and the GA date isn’t …
PostgreSQL
Introducing YeSQL: Practical PostgreSQL, One Concept at a Time
I’m happy to share something new: YeSQL is live, a free set of 24 short PostgreSQL lessons — one concept, one runnable query, real data, no signup. It’s free …
PostgreSQL
Introducing sqlfmt: an SQL gofmt-style formatter
Formatting SQL tends to bring some of the same questions again and again: should we uppercase clause keywords? should we put the separating comma at the start of a line …
PostgreSQL
SQL Improvements in PostgreSQL 11–18: A Personal Selection
Seven major versions of PostgreSQL shipped between 2018 and 2025, one per year without exception, and each with a changelog of 150 to 200 user-visible changes. Each …
PostgreSQL
Simple Data Modeling with a Test Data Set
In How to Write SQL we saw how to write SQL queries as separate .sql files, and we learnt about using query parameters with the psql syntax for that (:variable, …
PostgreSQL
The Mode Ordered-Set Aggregate Function
In our article Exploring a Data Set in SQL we discovered a data set related to music: the Chinook sample database. Our discovery led us to find albums containing tracks …
PostgreSQL
What's in a name: “Mastering”
Now that my book Mastering PostgreSQL in Application Development is released (and selling well, thanks guys!), I’ve had some questions about the title. The idea is …
PostgreSQL
Mastering PostgreSQL in Application Development launches!
Today is the day my book Mastering PostgreSQL in Application Development launches! I’m all excited that everybody interested is now able to actually read my book! …
PostgreSQL
Mastering PostgreSQL in Application Development
Mastering PostgreSQL in Application Development is the full title of the book I am currently writing. Running the PostgreSQL is YeSQL series of blog posts has shown me …
PostgreSQL
Regular Expressions and Grouping Sets
There’s a very rich set of PostgreSQL functions to process text, you can find them all at the String Functions and Operators documentation chapter, with functions …
PostgreSQL
SQL Regression Tests
In a previous article here we saw How to Write SQL in your application code. The main idea in that article is to maintain your queries in separate SQL files, where …