📰 sql

On expressions' reordering in Postgres

Let’s discuss micro-optimisations

weeklyfoo #82 / 2025-04-28

Open

postgressql

Postgres is eating the database world

In fact, I only use postgresql if I need an SQL db (sometimes an SQLite)

weeklyfoo #25 / 2024-03-25

Open

sqlpostgresql

SQL as API

Sounds like a terrible idea, but read the blog post.

weeklyfoo #13 / 2023-12-31

Open

sqlapi

SQL query optimization: a comprehensive developer's guide

An SQL optimization guide for developers. With best practices, warnings, and pro tips to speed up your SQL query optimization.

weeklyfoo #21 / 2024-02-26

Open

sql

SQL Reserved Words

Lots of checks and crosses, nevertheless a good overview ;)

weeklyfoo #2 / 2023-10-16

Open

sql

SQL tips and tricks

A (somewhat opinionated) list of SQL tips and tricks that I’ve picked up over the years in my job as a data analyst.

weeklyfoo #52 / 2024-09-30

Open

sql

Transaction Isolation in Postgres, explained

Good deep dive!

weeklyfoo #12 / 2023-12-24

Open

sqlpostgres