safe-pg-migrations

What's Changed

Fixes 🐛

• Fix check used when adding non null constraint by @teckwan in https://github.com/doctolib/safe-pg-migrations/pull/142
• BatchRecord: select primary keys instead of full records by @maximerety in https://github.com/doctolib/safe-pg-migrations/pull/138

New Features 🎉

• Added new check to ensure composite indexes are dropped ahead of columns removal by @CharlotteFeather in https://github.com/doctolib/safe-pg-migrations/pull/141
• Tt 23249 increment lock_timeout gradually to reduce failing migrations by @MouadHilali and @CharlesDelannoy in https://github.com/doctolib/safe-pg-migrations/pull/140

New Contributors

• @maximerety made their first contribution in https://github.com/doctolib/safe-pg-migrations/pull/137
• @teckwan made their first contribution in https://github.com/doctolib/safe-pg-migrations/pull/142
• @CharlotteFeather made their first contribution in https://github.com/doctolib/safe-pg-migrations/pull/141

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v3.0.1...v3.1.0

What's Changed

Bugfix 🔨

• Fix args bug for create_table by @CharlesDelannoy in https://github.com/doctolib/safe-pg-migrations/pull/134

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v3.0.0...v3.0.1

What's Changed

Fixes 🐛

• DODO 1632 not idempotent add_column when type differ by @CharlesDelannoy in https://github.com/doctolib/safe-pg-migrations/pull/123

New Features 🎉

• remove dependency to activerecord max 7.0 by @CharlesDelannoy in https://github.com/doctolib/safe-pg-migrations/pull/130
  ==> Now we support 7.1 and above
• stop ruby 2 support by @CharlesDelannoy in https://github.com/doctolib/safe-pg-migrations/pull/132

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v2.3.0...v3.0.0

What's Changed

New Features 🎉

• Add add_check_constraint to the retryable actions by @CharlesDelannoy in https://github.com/doctolib/safe-pg-migrations/pull/117
• DODO 1552 add_check_constraint to the sensitive logger by @CharlesDelannoy in https://github.com/doctolib/safe-pg-migrations/pull/118
• bump new version (2.3.0) by @CharlesDelannoy in https://github.com/doctolib/safe-pg-migrations/pull/119

New Contributors

• @CharlesDelannoy made their first contribution in https://github.com/doctolib/safe-pg-migrations/pull/117

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v2.2.1...v2.3.0

What's Changed

Fixes 🐛

• Railtie: next unless of break by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/111
• Detect and reuse already existing constraint by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/112

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v2.2.0...v2.2.1

What's Changed

New Features 🎉

• Make lock_timeout configurable by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/102
• Bugfix: UselessStatementLogger now warns when disable_ddl_transaction is called by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/104
• Add sensitive_logger by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/101
• Introduce default_value_backfill_threshold: config to avoid unwanted long migration when adding a column with :update_in_batches by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/105
• drop_table: Remove foreign keys before removing a column by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/107
• Set statement timeout by default by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/106

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v2.1.0...v2.2.0

What's Changed

New Features 🎉

• Adding drop_table to the list of retriable statements by @MouadHilali in https://github.com/doctolib/safe-pg-migrations/pull/93
• Add safe add_check_constraint by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/95
• safe change_column_null by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/97
• Add small margin to lock timeout, otherwise it is hidden by statement timeouts by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/99
• Implement default_value_backfill algorithm in add_column by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/98

New Contributors

• @MouadHilali made their first contribution in https://github.com/doctolib/safe-pg-migrations/pull/93

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v2.0.0...v2.1.0

What's Changed

Fixes:

• Fix ruby2_keyword warning by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/75

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v1.4.1...v1.4.2

What's Changed

Breaking

• Drop Ruby 2.5, 2.6 and ActiveRecord < 6, add ruby 3.2 and AR 7.0 by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/80
• Remove support for PG 9 and 10 as they are EOL by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/82

Features:

• Add remove_foreign_key idempotent by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/79
• Add safe_pg_migrations_verbose by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/86
• Add logs when add_index is taking too long by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/91

Fixes:

• Fix Add index for ruby 3.0 by @MaximeRDY in https://github.com/doctolib/safe-pg-migrations/pull/78
• Fix deprecated ActiveRecord::Base.verbose_query_logs by @ThHareau in https://github.com/doctolib/safe-pg-migrations/pull/87

New Contributors

• @MaximeRDY made their first contribution in https://github.com/doctolib/safe-pg-migrations/pull/78
• @tanguy-platsec made their first contribution in https://github.com/doctolib/safe-pg-migrations/pull/81

Full Changelog: https://github.com/doctolib/safe-pg-migrations/compare/v1.4.2...v2.0.0