How do you handle migrations ?

1. atlas

   1 74 6,811 9.6 Go

   Manage your database schema as code (by ariga)

   

   You might want to check out Atlas. It provides automatic migration planning for GORM, and has various guides on how deploying schema migration on the popular platform and tools, such as Helm, Kubernetes and ECS.

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. migrate

   2 78 16,626 7.5 Go

   Database migrations. CLI and Golang library.

   

   We use https://github.com/golang-migrate/migrate in an init-container, which (1) supports multiple durable storage technologies and (2) handles logical locking for the case where multiple migrations start concurrently.

4. liquibase

   3 56 5,007 9.8 Java

   Main Liquibase Source

   

   We use https://github.com/liquibase/liquibase, as most of Dev are used to and comfortable with it.

5. goose

   4 30 8,312 8.5 Go

   A database migration tool. Supports SQL migrations and Go functions. (by pressly)

   

   Next try https://github.com/pressly/goose We have this setup to be run by the CI-CD pipeline to be run before the application is started. BTW, this utility is compatible with https://sqlc.dev , so they work good together.

6. sqlc

   5 182 14,981 9.0 Go

   Generate type-safe code from SQL

   

   Next try https://github.com/pressly/goose We have this setup to be run by the CI-CD pipeline to be run before the application is started. BTW, this utility is compatible with https://sqlc.dev , so they work good together.

7. tern

   6 14 1,094 7.7 Go

   The SQL Fan's Migrator

   

   We use https://github.com/jackc/tern library (from the author of the pgx driver). We run migrations in k8s init containers and we do not do rollbacks (only up). Advantages over other popular solutions are:

Suggest a related project