USING THE EXPAND AND CONTRACT PATTERN FOR SCHEMA CHANGES

Summary from the TLDR Dev newsletter

The expand and contract pattern is a multi-step process that allows for safe and reliable database schema migrations without downtime by introducing new structures in parallel, migrating data, and then transitioning clients incrementally to the new schema while providing rollback options.