Having decided to use an RDBMS, however, didn’t mean we would be able to define our schema once and live with it forever. In Boxever, we try to embrace Agility which means that things change often. This meant that we needed a way of easily and automatically managing our Postgres schema evolution, i.e. a database migration framework. For that purpose, we decided to use Flyway as it provides, amongst other things, support for both PostgreSQL and Amazon’s RedShift – the datawarehouse from AWS which our analytics and data science teams use.