October 2026
-
14 Oct 2026🐥Handling local timezones in Ash while storing UTC datetimes
-
8 Oct 2026🐥Cross-schema queries in PostgreSQL without the loop
September 2026
-
20 Sep 2026🔗A deep (and fuzzy) dive into search
-
16 Sep 2026🔗Introducing sqlfmt: an SQL GoFmt-style formatter
-
16 Sep 2026🔗Modeling state transitions in PostgreSQL
-
10 Sep 2026🔗The DISTINCT in your COUNT
August 2026
-
27 Aug 2026🔗How to optimize SQL queries: 20 proven best practices
-
14 Aug 2026🔗The query that was correct but broke everything else
-
4 Aug 2026🔗Ever run into a PostgreSQL query that you can figure out what it does??
July 2026
-
31 Jul 2026🔗The Order of Data: defaults, performance, determinism & paging
-
10 Jul 2026🔗Six SQL patterns I use to catch transaction fraud
June 2026
May 2026
-
16 May 2026🔗12 practices for optimizing PostgreSQL queries for large datasets
-
13 May 2026🔗SQLite features you didn’t know it had: JSON, text search, CTE, STRICT, generated columns, WAL
-
4 May 2026🔗Waiting for PostgreSQL 19 – Introduce the REPACK command
April 2026
-
18 Apr 2026🔗mickamy/sql-tap: Watch SQL traffic in real-time with a TUI
-
12 Apr 2026🔗Good CTE, bad CTE
-
10 Apr 2026🔗9 advanced PostgreSQL features I wish I knew sooner
-
7 Apr 2026🔗How moving one word can speed up a query 10–50x
March 2026
-
30 Mar 2026🔗Batch inserts in SQL for large data loads
-
27 Mar 2026🐥Enforcing polymorphic integrity in PostgreSQL with num_nonnulls
-
26 Mar 2026🔗Row locks with joins can produce surprising results in PostgreSQL
-
24 Mar 2026🔗Use SQL triggers to prevent overwriting a value
-
22 Mar 2026🔗Our 3-part series on SQL performance optimisations
-
20 Mar 2026🔗Fix a top cause of slow queries in PostgreSQL (no slow query log needed)