Strategies To Edit Production Data
summary
Progresses through five concrete strategies for making SQL writes from a Python stack and gives specific tradeoffs: Raw SQL queries (fast but un-audited), Local one-off scripts (repeatable but manual), Run scripts from Jenkins with command line arguments (CI safety, configurable), and Build a Script Runner application (centralizes scripts, enforces arguments, records audit logs). States which tooling and guards actually reduce incidents — transactional rollbacks, dry-run modes, access controls, and searchable change logs.
AI-written summary · about
chapters (5)
- 0:00Production data editing intro
- 3:52Why editing production is risky
- 12:02Safe data editing strategies
- 20:46Advanced tools and techniques
- 27:00Summary
related talks
30mStrategies to Edit Production Data
26mStrategies to Edit Production Data
29mStrategies to Edit Production Data
27mStrategies to Edit Production Data
21mPractical Deployment Strategies for Production Python Apps
36mUnlocking the Benefits of Database DevOps and Automation
23mOptimizing SQL + Python Pipelines for Data Science
20mExcellent Database Adventure: From Code Errors to Reliable Releases