DjangoCon 2018 - Strategies to Edit Production Data

Published: 24 May 2018
on channel: DjangoCon Europe

189

https://media.ccc.de/v/hd-45-strategi...

Editing data in a production database is sometimes necessary. However, mistakes in running these queries can be disastrous. In this talk, you will learn strategies for making edits to a production database with examples from a Python stack that increase safety and auditability.

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 — 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) Develop a process for raw SQL edits (2) Run scripts locally (3) Run scripts on an existing server (4) Use a task runner (5) Build a Script Runner service

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!

Julie Qiu

Watch video DjangoCon 2018 - Strategies to Edit Production Data online, duration hours minute second in high quality that is uploaded to the channel DjangoCon Europe 24 May 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 189 times and liked it 3 visitors.