Little and to the point reference on safer SQLite use. I should check if some of this would apply or is used by Akonadi as well.

The right and wrong approaches for paginating results coming from a database.

Good advice on designing your database tables. The comments are good too, they allow to complete the picture.

Interesting use of database templates and memory disks to greatly speed up test executions.

With some tuning SQLite can go a long way, even for server type workloads. There are still a few caveats but in some case this can reduce complexity and cost quite a bit.

Nice exploration of the GitLab database schema. This highlights and finds quite a few of the choices made with an eye on performances.

Nice index pointing to resources to do many things with Postgres.

Indeed, a very underappreciated keyword in SQL. It can do much more than what it's often used for.

Overview of the differences in behavior between the two most popular ORMs in the Python ecosystem. This shows interesting different design options for such things.

Very interesting exploration of the design choices behind the creation of a key value storage engine.

It might not be as clear cut as sometimes assumed. With the right index UUIDv4 can still do as key in databases.

An exploration of how databases work from first principles, going all the way to distributed nodes etc. Good list of topics to explore further.

You like SQL? You like murder mysteries? This little game might be right for you.

Ever wondered how to programmatically introspect query plans? This is a long article but good starting point on how it's represented under the hood.

Interesting view on the motives and overall behavior of query planners.

Ever wondered what you can do with vector databases and LLMs? Here is an interesting use case.

Some more deserved praises for Sqlite. It's finding its way in more and more places.

This is a very important point. Communities should make sure that new blood gets in. Companies should also avoid just recruiting top talent and groom juniors to contribute.

Interesting property of the newer UUIDv7 spec.

Interesting primer of the intricacies of database migrations. It can get complex fairly quickly.