Recommendations from Shopify's Data Migrations team for adding NOT NULL columns safely to your own database tables, based on a recent investigation into schema change safety using using the popular Large Hadron Migrator (LHM) gem.
NayaRead shows a summary and links to the original article. The full article is hosted on shopify.engineering.