Notes for week 29 of 2021

I cI continued the trend of visiting friends and enjoying summer. I temporarily removed sport as I am ramping up to finally become a first-category citizen.

Random

  • I’ve walked 24 km. I’ve been active for 5.5 hours during 6 activities. This week’s max speed was 11.9 km/h.
  • I managed to do a lot of phone calls. I am proud of myself.
  • I’ve learned about PSI, or parasocial interaction. It’s an interesting and useful concept for the age where “media output” isn’t just the author’s work, but the author’s “life feed”.
  • I prepared an adventure of The Quest with a newbie and as expected, the game preparation package works really well

Graveyard

  • Migrations hit again: the easiest way to get rid of invalid defaults (like 0000-00-00 00:00:00 for DATETIME columns) is to add a manual RunSQL migration that says ALTER TABLE table MODIFY column DROP DEFAULT.
  • MySQL Enum field is a bit weird. This article provides a good overview. Django does not use them and using ChoiceField will still modify the underlying ENUM to VARCHAR. This may require planning since it’s an expensive ALTER to do.

Published in Notes and tagged


All texts written by . I'd love to hear your feedback. If you've liked this, you may want to subscribe for my monthly newsletter or . You can always return to home page or read about the site and its privacy handling.