golang-migrate/migrate
Migrate
This project is a command-line utility designed to manage database schema versioning and automate incremental schema updates. It functions as a version control system for database structures, ensuring consistency across environments by tracking applied migrations in a dedicated metadata table and executing scripts in a sequential, reliable manner.
The tool distinguishes itself through a driver-based abstraction layer that supports a wide range of database engines, including various SQL and distributed cloud databases. It provides robust concurrency control through advisory locking, which prevents conflicting schema changes during simultaneous deployment attempts. To ensure data integrity, the system supports atomic execution by wrapping migration scripts in transactions, while also offering the flexibility to execute custom shell scripts or complex multi-statement files using delimiter-based parsing.
The platform includes comprehensive configuration options for managing database connections, retry logic for transient errors, and the customization of migration tracking tables. It is designed to integrate into automated deployment pipelines, providing a unified interface for schema management regardless of the underlying database technology.
Features
- Database Schema Migrations - Automates the application of versioned SQL schema updates to maintain structural consistency across database environments.
- Database Migrations - Automates incremental schema updates and tracks version history to ensure consistency across environments.
- Automated Migrations - Executes automated schema updates as part of a deployment pipeline to keep database structures in sync.
- Database Versioning - Manages incremental changes to database structures by tracking applied versions across environments.
- Database Migration Management - Manages and automates schema updates across environments using versioned scripts and concurrency-safe advisory locking.
- Advisory Locking Mechanisms - Prevents conflicting schema changes during simultaneous deployment attempts by utilizing advisory locks.
- Schema Migrations - Records the current version of the database schema in a dedicated table to ensure sequential application of migrations.
- Database Abstraction Layers - Provides a unified interface layer to interact with various SQL and distributed database engines.
- Database Migration Tools - Comprehensive migration tool with CLI and library support.
- Database Migrations - Multi-database migration handling tool.
- Database Tools - Database migration tool.
- Databases and Storage - A library and CLI tool for database schema migrations.
- Schema Migration Tools - Database migration library and CLI tool.
- Database Transactions - Ensures database integrity during schema updates by wrapping migration scripts in atomic transactions.
- Transactional Migration Managers - Wraps migration scripts in atomic transactions to ensure schema changes either fully succeed or roll back.
- ClickHouse Connectors - Connects to ClickHouse analytical databases to manage schema migration state.
- CockroachDB Connectors - Establishes secure connections to CockroachDB clusters for safe schema migration operations.
- Firebird Connectors - Connects to Firebird databases using custom authentication and wire encryption settings.
- MySQL Connectors - Connects to MySQL databases with support for encryption and custom connection configurations.
- PostgreSQL Connectors - Connects to PostgreSQL instances using secure connection strings and custom schema search paths.
- Database Deployment Automation - Prevents conflicting schema changes during simultaneous deployment attempts by utilizing advisory locks and state management.
- Version Tracking - Maintains a dedicated metadata table to track applied schema versions and prevent duplicate execution.
- Concurrency Control - Prevents conflicting schema changes during simultaneous deployments using database-level advisory locks.
- Migration Execution Engines - Splits migration scripts into individual statements using delimiters to support complex schema modifications.
- Distributed Databases - Supports connections to distributed database instances to apply schema changes across multiple nodes.
- Database Connection Configurations - Configures database connection parameters including authentication, security certificates, and timeouts.
- Migration Configurations - Configures advisory locking strategies and timeouts to manage concurrent migration access.
- Migration Execution - Manages migration execution behavior including custom table names and transaction controls.
