2 ms·
We have a sandbox dev cloud environment and a way to sample a subset of prod data into this dev sandbox. The sandbox dbs are namespaced by the devs username and
by softwaredoug 5y ago
We have a sandbox dev cloud environment and a way to sample a subset of prod data into this dev sandbox. The sandbox dbs are namespaced by the devs username and their branch, so you don’t have conflicts. Devs control how they sample prod to recreate the needed behavior. And we can test on each other scenarios as needed.
The key here is “sample” from prod to dev, otherwise it’s far too large to be workable.
- markus_zhang 5y agoSounds good. If I understand correctly each of your devs has his own copy of the database and I think that's definitely better than just one big dev db. Yeah the sample is very important, usually we only import maybe a few days of data but still have to write our own scripts to import the data. The pain point is perhaps we don't control the databases so there are a few facilities in Vertica that we can't use.