Julie Qiu

Julie is a senior software engineer at Spring. She has led projects to improve search performance, personalize the user shopping experience, and ingest real time product updates at scale. She graduated from Yale University with a degree in Cognitive Science and currently lives in New York City

Strategies to edit production data



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: