A new column can be a minor patch or a dangerous migration. The difference comes from how you add and backfill it. Done right, it becomes part of the system with no downtime and no corrupted data. Done wrong, it locks tables, spikes CPU, and slows every query.
First, define the column with the right type. Changing column types later is costly. Decide on NULL vs NOT NULL before you write anything. If you declare NOT NULL without a default on a large table, the database will rewrite the whole thing. That’s risk you can avoid with a default value and a carefully planned rollout.
Next, use online schema change tools when the database supports them. In PostgreSQL, ADD COLUMN is fast if you include no default. In MySQL, consider ALGORITHM=INPLACE or ALGORITHM=INSTANT where available. For massive datasets, add the column first, then fill it in batches to avoid blocking writes.