-
Changing your huge table's data types in production [FOSDEM 2021]
You have a huge table, and it is necessary to change a column's data type, but your database has to keep running with no downtime. What do you do? Here's one way to perform this change, in as unobtrusive a manner as possible while your table keeps serving users, by avoiding long DDL table locks and leveraging procedural transaction control.
Read more... -
Keep your libraries updated and nobody gets hurt
Sometimes skipping an update or two for a library means that we can trigger unexpected breakages in other software that are very hard to troubleshoot.
Read more...