We all use git and more complex CI/CD tools to manage versions of code and deploy it to relevant server infrastructure. However, the way I see this, application state, or databases, are completely excluded from this process. In other words, the burden of ensuring that database matches the most recent version of code, lies either on application developers, or some kind of specialized tool.

I’m looking for such a tool.

In other words, I need a way to configure and automate updates for database schema and dedicated tables (dictionaries and what not) synchronously with publishing code that relies on those database updates. Git for postgresql, or something, I dunno. How do they do that in the industry?

submitted by /u/arteregn
[link] [comments]