-=vyruss=- / blog

  • articles
  • talks
  • tweets
  • blog roll
  • main page
  • Changing your huge table's data types in production [FOSDEM 2021]

    • Apr 15, 2021
    • 1 min read

    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

    • May 14, 2020
    • 5 min read

    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...

  • ««
  • «
  • 1
  • 2
  • 3
  • 4
  • »
  • »»
Rendering: Pelican  •  Theme: Peli-Kiera (modified)  •  Copyright © 2025   Jimmy Angelakos