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.

presslygoose

Features

Star history