“If you're adding a nullable column, it doesn't require to do a lot more competition at the backend, and it doesn't require any schema changes”
Sahil Walia · Software Engineering Radio - the podcast for professional software developers · Sahil Walia on Schema Changes and Data Migrations
Play from 10:55
10:55
Audio streams from the publisher’s own feed. Verbatim does not host or copy it.
What was described
state that adding a nullable column is a safe schema change even with downstream consumers
Said nearby on the same subject
“One column had less than 2 percent of the values populated, and it was initially assumed those don't bring value, but later it was realized ... downstream jobs started breaking”
SW
Sahil Walia
Software Engineering Radio - the podcast for professional software developers ·
“You will write ahead logs in Postgres or binlog in MySQL… replay the changes into a new system when the new schema… essentially zero application code changes.”
SW
Sahil Walia
Software Engineering Radio - the podcast for professional software developers ·