Coursera Spring Sale
40% Off Coursera Plus Annual!
Grab it
In this 29-minute conference talk from DevOpsDays NYC 2018, Julie Qui explores practical strategies for safely editing production databases. Learn how to progress beyond risky direct SQL edits to more secure, auditable methods for Python stack teams. Discover five increasingly sophisticated approaches: raw SQL queries, local one-off scripts, application server script deployment, Jenkins script execution with command line arguments, and building dedicated Script Runner applications. Understand the advantages and disadvantages of each method to determine which solution best fits your team's specific requirements. By the end of the presentation, gain the knowledge needed to implement safer infrastructure for production database modifications, reducing risk while maintaining necessary flexibility for data operations.