Because of the world backup day:

use-the-index-luke.com/yesterday

Because of the world backup day:

use-the-index-luke.com/yesterday

More details about Simon Riggs death:

'A man who died after a private plane crashed at a well-known airfield has been named by friends and colleagues as pilot Simon Riggs.'

bbc.com/news/articles/…

There are still SQL tutorials featuring an 'age' column.

Sad news from LinkedIN:

'Yesterday afternoon Simon Riggs passed away.'

linkedin.com/feed/update/ur…

WHERE col IS JSON [ARRAY|OBJECT|SCALAR]

Test for Valid JSON, Distinguish between Arrays, Objects and Scalars

modern-sql.com/caniuse/is-json

Specialization of labor: A success story for 10000 years.

Today: Full stack developers.

Future civilizations will wonder what went wrong like we wonder about the decline of the roman empire.

There is a ORM tool, from which one might expect to take care mapping the 'object' world to the 'relational' world. But it turns out that 'ORM' tool never does joins (until now).

Did I get that right?

prisma.io/blog/prisma-or…

I started tracking our spends from Oct 2019. These are the server costs for simpleanalytics.com in recent years. With more customers, we buy more servers, but with bare metal, it stays very cheap.

We have been self-hosting our database since the start. It's sometimes…

Integration test failed? (Did you spot it?) Nothing they can't fix in Gozo!

Yet another Stonebraker system.

techcrunch.com/2024/03/12/new…

My first though was: reminds me of OS/400.

Have finished reading the 'SQL performance explained' book from Markus Winand (creator of the use-the-index-luke.com).

Have already known about indexes and B-trees, but the book helped to understand how they affect SQL operations under the hood. Highly recommend!

これは後で読もう。

「開発者のためのSQLパフォーマンスの全て」
use-the-index-luke.com/ja/sql/table-o…

Just announced new training dates.

There are still seats left in my next performance training in April. The remaining courses take place in fall.

winand.at/sql-training/o…

Performance sells is the 'Sex sells' of databases.

Opened a MySQL feature request to make MySQL's ANY_VALUE more aligned with the standard.

bugs.mysql.com/bug.php?id=114…

Not sure if I ever mentioned that I'm also on Blue Sky.
bsky.app/profile/winand…

Over there I'm ocassionally putting 'sneak peeks' into topics I'm working on. Only there.

The one thing flat-earthers don't understand is this:

We would actually like flat earth! That would save a lot of time zone hassles. Unfortunately, the earth is not flat.