As part of code that runs when the application runs.

Always write migrations that can be adopted gradually, and always use transactions where possible.

RIP to those not using Postgres who can’t use DDL in transactions.