| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Łukasz Jarych <jaryszek(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Using GIT to caught delta between database versions |
| Date: | 2018-06-13 19:09:10 |
| Message-ID: | 503bf40d-2b8d-cd49-75e8-1d5ea3333742@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Lizenko | 2018-06-13 20:10:18 | Replica string comparsion issue |
| Previous Message | Łukasz Jarych | 2018-06-13 18:13:08 | Re: Using GIT to caught delta between database versions |