Long but nice post about all the things you need to figure out about working with databases when the only thing you know is imperative languages.

An oldie but a goodie about SQL injection. Does a good job getting the overall picture of this particular security plague.

Looks like an interesting way to improve SQL. This feels like a nice extension, it's much better than throwing out the baby with the bathwater.

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

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

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

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

Good primer about database transactions and the issues you might run with when using them.

Everything you wanted to know about SQL joins, and more.

I don't understand the SQL shaming I see in some circles. It's clearly based on dubious arguments.

Interesting bug in SQLite. In particular look for the conclusion regarding tests and coverage. It's something I often have to remind people of.

Interesting set of SQL optimizations. Also shows PostgreSQL still had (has?) some room for improvement.

A good example of using the best tool for the job. Having your whole data analysis pipeline in pandas might not be what you want for performance reason. Very often there's a relational database you can leverage first.

Starts a bit like a (somewhat deserved) love letter to SQLite. But that also does a good job pointing out some of its caveats and when to not use it.

Because when things are presented a bit too rosy I get suspicious... it's nice to have such counterpoints to realize PostgreSQL is not perfect which means there are scenarios where you might not want it.

SQLite keeps being a fun database full of little nuggets. Plenty of cases when it could fly but when somehow we use the bigger players instead.

Not exactly new, but easy to loose sight of it when in the hamster wheel. Clearly a good reminder.

Do you ever need to order items stored in SQL? There are ways to do it right and ways to do it wrong. Do it right and pick something meaningful for your case. This article does a good job at listing the typical approaches.