Deploying PostgreSQL DB Changes Through AWS Developer Tools Using Flyway

The fundamentals of deploying database changes through Flyway are pretty simple. At the root of it all, there are two words you need to know: This of course comes with a whole set of assumptions. You’ve set up your configuration to connect to the correct database being just one of them. And that’s talking about Read more

Running Flyway Pre-Migration Checks on the Database

This article demonstrates how to run a preliminary check that issues a warning, or throws an error, if the conditions aren't met for a Flyway migration to succeed. It provides some example checks for PostgreSQL databases that use Flyway SQL callbacks to ensure the server is running the correct PostgreSQL version, or that the database has a required extension installed. Read more

Getting an Overview of Changes to a PostgreSQL Database using Flyway

How to use Flyway and PowerShell to automatically generate a database build script every time Flyway successfully created a new version. You can then investigate schema changes between versions simply by using a Diff tool to compare build scripts. Read more