Re: Using GIT to caught delta between database versions

Поиск
Список
Период
Сортировка
От Łukasz Jarych
Тема Re: Using GIT to caught delta between database versions
Дата
Msg-id CAGv31odGXSHS3V1es_U=L0mU4z3sqedDtw4DuhL0vc7kEEUB2A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Using GIT to caught delta between database versions  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
thank you Adrian,

Best,
Jacek 

2018-06-13 21:09 GMT+02:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 06/13/2018 11:13 AM, Łukasz Jarych wrote:
Hi Adrian,

thank you .

why i should use sqitch or any other software to catch the delta?

When i will export plan-text SQL , git should catch delta automatically?
Can you please explain it?

You are correct Git will catch the changes in the plain text files.

What is nice about Sqitch and similar tools is they offer additional functionality, such as deploying to different servers(production, dev, testing, etc), declaring dependencies between changes, rolling back individual changes, etc. To get a sense of what is possible take a look here:

https://metacpan.org/pod/sqitchtutorial

I have found it very useful. It comes down to individual preference.



Best,
Jacek





--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: "a"
Дата:
Сообщение: Re: How to reference a composite type in schemas not "public"?
Следующее
От: Atul Kumar
Дата:
Сообщение: question on streaming replication