my usual approach for database schema migrations involves, first, creating a detailed plan.

Hey everyone, I'm trying to figure out the best way to handle database schema changes in production. I've heard about blue-green deployments for databases and also just rolling back if a change breaks things. What do you all usually do to keep downtime and risk as low as possible when you're changing your database structure? I'd love to hear any bad experiences or what you've learned along the way!