ankane/strong_migrations

Features

• PostgreSQL Schema Migrations - Detects and blocks risky schema changes in PostgreSQL to ensure zero-downtime deployments.
• Schema Migration Validation - Identifies risky database operations and suggests safe patterns to prevent production downtime.
• Safe Pattern Automation - Automatically executes dangerous operations using safe alternatives without requiring changes to the original migration code.
• Database Lock Mitigation - Prevents migrations from blocking application traffic by managing statement timeouts and retry logic.
• Database Migration Safety - Identifies dangerous operations during development to ensure safe execution patterns before production.
• Zero-Downtime Schema Migrations - Prevents production outages by detecting and blocking risky schema changes that could lock tables.
• Lock and Statement Timeout Management - Sets lock and statement timeouts to prevent migrations from blocking active database operations.
• Migration Lock Managers - Implements statement timeouts and automatic retry logic for lock timeouts to prevent database congestion during migrations.
• Migration Safety Validators - Identifies risky SQL patterns and suggests safe alternatives to prevent production downtime during deployments.
• Lock Timeout Retries - Automatically retries migration statements that fail due to database lock timeouts to prevent deployment failure.
• Automatic Task Retries - Automatically re-executes migration statements when they encounter database lock timeouts.
• Table Performance Optimizers - Updates database statistics after schema changes to maintain consistent query performance and planning.
• Target Version Configuration - Allows specifying target database versions to align safety checks with engine capabilities.
• Version-Aware Validation - Matches migration patterns against a registry of safe features specific to the target database engine version.
• Post-Migration Statistics Refresh - Triggers database analyze commands after index creation to maintain optimal query planner performance.
• Concurrent Index Cleanup - Provides utilities to clean up invalid concurrent indexes and update table statistics after schema changes.
• Invalid Index Cleanup - Removes invalid indexes created by failed concurrent index additions before retrying the migration.
• Method Interception Proxies - Wraps standard database migration methods to inject safety checks and safe-pattern replacements at runtime.
• Static Analysis AST Parsing - Uses abstract syntax tree parsing to identify dangerous database operations in migration source code before execution.

Star history