Don't Leave Your Production Data Lying Around: Anonymize It with DbToolsBundle!
summary
DbToolsBundle is a PHP component (usable in any Docker stack) that automates production-data anonymization and database management to avoid keeping raw prod backups locally. It covers integrating the bundle into projects, creating a GDPR-compatible cloning/anonymization workflow, performing backup and restore and gathering DB statistics, and extending the tool with custom anonymizers; the talk also demonstrates using advanced SQL to anonymize one million rows in under 20 seconds.
AI-written summary · about
chapters (11)
- 0:00Data anonymization intro
- 1:28DBToolsBundle overview
- 3:38Tool issues and goals
- 5:26DBToolsBundle features
- 8:59Basic anonymization config
- 14:19Secure anonymization workflow
- 17:29Custom anonymizers
- 19:16Performance benchmark
- 22:04SQL query details
- 27:03Roadmap and future
- 30:12Contributing
related talks
42mProd backups in staging? Why not
32mAnonymizing Data in Postgres Without Losing Your Mind (or Your
34mDatabase Anonymization with PostgreSQL
32mAnonymization and Dynamic Masking with PostgreSQL
26mAnalytics & Data Science with Privacy at its Core
28mOpen the gate a little: strategies to protect and share data
01h 00mAutomating Security in Your Data Pipeline
39mBastion DB: enabling secure developer access to databases
