news.ycombinator.com• Jun 28, 2021• 1 min read
Ask HN: How do you manage dev db environment?Hi db experts,I'm curious how do you manage dev environments? Here is some background:- We use Vertica for prod/dev. Data team members share the same dev database.- We need to import data from prod to dev for testing frequently. At least a few times per Sprint per developer.- We don't control the databases. DBAs from HQ control them and the response time is from a few days to infinity.Here are the pain points:- If two or more developers are developing two different features for the same table, we have to make sure that neither breaks the table.- It's slow to import data from prod to dev. We tried vsql (the command line tool) and pandas and neither works great.
