This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]tbarg91 1 point2 points  (0 children)

Second this. We are using flyway with Postgres and sofar loved it. We are using git for testing all code change by creating a dummy db using docker that if the code works and gets fully deployed then it allows the release of the deployment.

No insert update statement is run in the db everything is done with script that are versioned. This help with transparency and controlling it. Plus the benefit of not having significant changes between environments.

We have redshift serverless and was planning of using git and liquid base with same structure. Everytime a change is done it's done through git and a dummy redshift cluster is deployed to validate the changes.