pressly/goose
Goose
Goose is a database schema versioning system and SQL migration tool designed for Go applications. It functions as a framework for tracking and applying incremental database changes through versioned SQL scripts, ensuring consistency across different environments.
The project distinguishes itself by providing a build-time capability to exclude unused database drivers to optimize binary size and a filesystem abstraction that allows migration scripts to be bundled directly into a compiled executable. It also supports out-of-order execution logic to apply missing scripts that were created after a newer version was already recorded.
The tool covers a broad range of schema evolution capabilities, including forward migrations, rollbacks, and the population of initial reference data through seeding utilities. It manages SQL execution with semicolon-aware statement grouping, transaction-aware processing with manual overrides for non-transactional operations, and the injection of dynamic values via environment variable substitution.
Features
- Database Schema Migrations - Automates the application of versioned updates to database schemas to ensure consistency across different environments.
- Data Seeding Utilities - Includes utilities for populating databases with initial reference data or test records as part of schema setup.
- Go Language Integrations - Provides a specialized framework for Go applications to embed SQL migration files and automate schema updates.
- Database Versioning - Manages the evolution of database structures through forward migrations and rollbacks to previous versions.
- Migration Execution - Implements the logic for executing pending migration scripts to bring the schema to the latest version.
- Schema Migration Tools - Provides a tool for managing and applying incremental database schema changes using SQL scripts.
- Schema Migrations - Supports reverting the database schema to previous versions by executing defined inverse migration logic.
- SQL Migration Workflows - Executes complex SQL scripts with support for environment variable injection and custom transaction handling.
- Migration State Tracking - Maintains a database table to record which migration scripts have been executed to ensure consistency.
- Transactional Migration Managers - Executes schema migrations within atomic transactions by default to ensure data integrity.
- Build-Time Pruning - Provides a build-time capability to exclude unused database drivers to minimize the final binary size.
- Database Seeding Tools - Provides utilities to populate databases with initial reference data as part of the migration process.
- Filesystem Abstractions - Implements a filesystem abstraction that allows migration scripts to be bundled directly into the compiled executable.
- Embedded Asset Bundling - Bundles migration files directly into the compiled executable using a virtual filesystem abstraction.
- Out-of-Order Migrations - Supports applying missing migration scripts that were created after a newer version had already been applied.
- Database Deployment Automation - Automates schema updates during deployment by bundling scripts into a binary and utilizing environment variables.
- Binary Footprint Optimizers - Provides build-time pruning of unused database drivers to reduce the application's binary footprint.
- Non-Transactional Migrations - Allows executing migration statements outside of transaction blocks for operations that are incompatible with transactions.
- Migration Progress Monitors - Enables listing all available migrations and identifying which have been applied versus which remain pending.
- Out-of-Order Application - Supports out-of-order execution logic to apply missing migration scripts created after a newer version was recorded.
- Database Migration Tools - Manages migrations via incremental SQL or Go scripts.
- Database Tools - Database migration tool.
- Schema Migration Tools - Tool for managing database evolution via SQL or Go scripts.
Star history
How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.
