Safe Pg Migrations Versions Save

Make your PostgreSQL migrations safe

v3.1.0

1 week ago

What's Changed

Fixes :bug:

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

v3.0.1

5 months ago

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

v3.0.0

5 months ago

What's Changed

Fixes :bug:

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

v2.3.0

9 months ago

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

v2.2.1

10 months ago

What's Changed

Fixes :bug:

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

v2.2.0

10 months ago

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

v2.1.0

10 months ago

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

v1.4.2

1 year ago

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

v2.0.0

1 year ago

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