Need to duplicate data in Postgres? Several options are on the table.

Looks like an interesting tool for creating anonymized pre-production environments.

Looks like a neat extension which can come in handy.

Definitely not as simple as it sounds. The devil is once again in the details.

Interesting experiment showing that BLOBs in a database can be a good alternative to individual files on a filesystem in some contexts.

Some improvements coming in SQLite transactions. Here are some early tests.

Where are the limitations of using SQLite in production for web applications? Here is a good list.

Django doesn't always generate the migration you'd expect. Read them before going to production. Also it's fine to adjust them.

Forced to use UUID as primary key in a table? Then make sure to use them properly to not kill the performance more than necessary. Ideally use something else though.

A simple explanation about dirty writes during database transactions.

Nice return on experience of using a simple stack to serve loads of web requests.

Interesting tool for diffing database tables. Should come in handy for tests.

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.