Conceptually how do you handle deploys of SQL related things (table definition, scripts, stored procs etc) in a CI/CD way?

This page summarizes the projects mentioned and recommended in the original post on /r/ExperiencedDevs
Postgresql Migrations

WorkOS
Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors

  • reshape

    An easy-to-use, zero-downtime schema migration tool for Postgres

    • Shameless plug: I’ve been working on a tool called Reshape in this space: https://github.com/fabianlindfors/reshape. It fully automates zero-downtime schema migrations and avoids all the manual work that has been discussed in the comments here.

  • bytebase.com

    Source for bytebase.com

    • Several replies mentioned the SQL Server superior toolset in this category. And if you are a MySQL/PostgreSQL/ClickHouse/Snowflake shop. You can checkout https://bytebase.com. It provides a fully-fledged GUI to manage the database development lifecycle and is the only database CI/CD solution in the CNCF landscape. A few things the tool provides:

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts