Flyway 7.1.0 Released
Flyway 7.1.0 is out! This release contains new features and improvements over Flyway 7.0.0.
Highlights
- Support pgpass for authentication
- Allow for filtering info output by date or version
- Allow arbitrary script callbacks
- Allow number of lock retries to be configured
You can find a detailed list of the changes in the release notes.
Filtering info output
In the Flyway CLI output from info
can be filtered to only the parts of the history that you care about using the following 4 parameters, or a combination thereof:
infoSinceDate
: Limits info to show only migrations applied after this date, and any unapplied migrations. Must be in the formatdd/MM/yyyy HH:mm
(e.g.01/12/2020 13:00
)infoUntilDate
: Limits info to show only migrations applied before this date. Must be in the formatdd/MM/yyyy HH:mm
(e.g.01/12/2020 13:00
)infoSinceVersion
: Limits info to show only migrations greater than or equal to this version, and any repeatable migrations. (e.g1.1
)infoUntilVersion
: Limits info to show only migrations less than or equal to this version, and any repeatable migrations. (e.g.1.1
)
Example:
1 |
> flyway info -infoSinceDate="01/12/2020 13:00" |
See the documentation for more details.
Configuring lock retries
Sometimes you may want multiple instances of Flyway to run, each executing potentially very long lived migrations. Flyway will ensure only a single instance executes at once, but may timeout, giving an error for the instance that was waiting. With this new configuration parameter, you can tell Flyway how long you want it to try to acquire the lock before failing, allowing you to support this workflow.
1 2 |
./flyway <strong>-lockRetryCount</strong>=10 migrate |
See the documentation for more details.
Highlights of changes since 7.0.0
- Add Log4J v2 support
- Allow custom S3Client to be supplied
- Make AWS S3 SDK optional
- Fix table locking retry logic
- Fix getting Oracle database name
- Parser fixes to Oracle, MySQL, and SQL Server
- Log instead of throwing exception when PostgreSQL advisory locking fails
- Passwords embedded in Flyway URLs redacted analogously to
flyway.password
parameter
You can find a detailed list of the changes in the release notes
Download it now and enjoy!
You can download Flyway 7.1.0 now! We recommend you upgrade if you are affected by any of the issues logged in the release notes.
Flyway is brought to you with by the Redgate team: Julia Hayward, Philip Liddell, and Mikiel Agutu, with a lot of help from Axel Fontaine as well as the many contributors.
Now it’s your turn! Spread the word, follow @fly