medium10 pts · first answer countsdatabasesdeployment

Renaming a column safely

You need to rename users.fullname to users.display_name in production while old and new app versions run side by side during a rolling deploy. What is the safest approach?

A.Run ALTER TABLE ... RENAME COLUMN right before deployingB.Delete the old column first, then deploy the new codeC.Expand and contract: add the new column, write to both, backfill, switch reads, then drop the old column in a later releaseD.Stop the database for a few minutes over the weekend

Discussion 0

Join free to post in the discussion.

Renaming a column safely

Discussion 0

Related questions