Presented by:

22be2a3ca29a44ddfd6407e1ff171095

Adam Kamor

Tonic
No video of the event yet, sorry!
Download the Slides

Subsetting a database means to take a subset of its rows, across multiple tables, while still maintaining all of the constraints of the original database. Subsetting a database can be desirable for many reasons. One common use-case is to scale down a production database to a more reasonable size so that it can be used in staging, test, and development environments. This can be done to save costs and, when used in tandem with PII removal, can be quite powerful as a productivity enhancer. Another example is copying specific rows from one database and placing them into another while maintaining referential integrity.

In this presentation, inspired by our blog post, we will discuss in detail how to accomplish the first use case. Specifically, we’ll show you how to scale a database down to a desired percentage of its original size, i.e., to return a new database containing only 5% of the users in production.

Date:
2018 October 15 11:40
Duration:
20 min
Room:
Market
Conference:
Silicon Valley
Language:
Track:
Dev
Difficulty:
Medium