C
C
CocaColaBear2015-06-02 15:11:23
PostgreSQL
CocaColaBear, 2015-06-02 15:11:23

PostgreSQL version control system?

Hello!
Is there any version control system for PostgreSQL?
There is a project on which, at the moment, 3 people are working. Everyone works in a different industry and almost every day there are changes in the database. Whether it's deleting columns, moving, whatever.
I would like to somehow simplify the process of transferring the database schema from developer to developer. Since, for now, the DUMP base is lightweight and very easy to carry, there are no particular problems. But soon this size will grow dozens or even hundreds of times, and dumping will be very costly.
Can someone share their experience of working or organizing a version control system for databases (not necessarily PostgreSQL).

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Alexander Aksentiev, 2015-06-02
@Sanasol

It's called migration.
https://github.com/search?utf8=%E2%9C%93&q=sql+mig...

D
Denis Smirnov, 2016-11-10
@darthunix

I successfully use Pyrseas in production. Saves the schema as a yaml file, convenient for versioning and working with branches. According to the difference between the yaml file and the database, it automatically generates an sql migration.

I
Igor Rusinov, 2015-06-03
@RusinovIG

If the project is in php, I can advise https://github.com/robmorgan/phinx

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question