I've recently joined a small project that uses Azure for its storage and database. I need to implement a delete function, which requires me to update the database schema since the key currently has no 'on_delete' rule set. Additionally, I may need to add a new column later. The database was created using SQLAlchemy in Python. I'm worried that if I change the code and push the update, Azure might interpret it as a completely new schema and create a new database, which would result in the loss of all production data. I'm fairly confident that I can implement this without issues, but given that this is production data, I want to be cautious.
3 Answers
Since things can go wrong, I'd recommend making a copy of your database to another environment and test your schema changes there first. Better safe than sorry!
If you can't clearly explain what your code changes will do, you might want to reconsider deploying it to production. It's crucial to be sure before making any updates.
Azure doesn't automatically create a new database just because you've changed your schema. The updates you push with SQLAlchemy should apply to the existing database. Just make sure you have backups before you proceed.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically