Strategies to Edit Production Data

B9c37c30e9e196fa2f2d52ce7b724677?s=47 Julie Qiu
January 19, 2018

Strategies to Edit Production Data

https://www.devopsdays.org/events/2018-new-york-city/program/julie-qiu/

At some point, we all find ourselves at a SQL prompt making edits to the production database. We know it’s a bad practice, and we always intend to put in place safer infrastructure before we need to do it again, but what does a better system actually look like?

This talk progresses through 5 strategies for teams using a Python stack to do SQL writes against a database, to achieve increasing safety and auditability:

1. Raw SQL queries
2. Local one-off scripts
3. Deploy and run scripts from an application server
4. Run scripts from Jenkins with command line arguments
5. Build a Script Runner application

We’ll talk about the pros and cons of each strategy, and help you determine which one is right for your specific needs.

By the end of this talk, you’ll be ready to start upgrading your infrastructure for making changes to your production database safely!

B9c37c30e9e196fa2f2d52ce7b724677?s=128

Julie Qiu

January 19, 2018
Tweet