How to do a migration properly without downtime? Avoid a transaction on all rows.

Method:

1. add new column as nullable
2. new writes use the new column and read from the old-and new columns
3. Deploy
4. Fix the old data in a batch. Pause briefly between each batch and run another one once the database load is correct.