New ask Hacker News story: Ask HN: How do you manage dev db environment?

Ask HN: How do you manage dev db environment?
3 by markus_zhang | 1 comments on Hacker News.
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.

Comments

Popular posts from this blog

New ask Hacker News story: Tell HN: Equifax free credit report dark patterns

New ask Hacker News story: Ask HN: Why can't the US government run their own social media?