Lmst

Flyway the Right Way
A blog by Ronald

Sometimes when you upgrade your application the new version does not work correctly, and you need to downgrade. When you are unlucky you did some changes in your database that cannot be undone. In that case you need to restore the database from a backup, which is usually quite cumbersome and time-consuming. How nice would it be if you could just...

#dev #softwaredevelopment #SoftwareDevelopment #DatabaseManagement #Flyway #Rollback

https://jdriven.com/blog/2026/03/Flyway-the-Right-Way/

Flyway migrations are not just SQL scripts.
They’re startup code — and startup code can fail your system.

This article shows how to use Flyway callbacks in Quarkus to:
• block unsafe migrations
• validate production state
• measure migration time
• fail fast before your app becomes ready

No magic. No demos. Real startup behavior.

🔗 https://www.the-main-thread.com/p/flyway-callbacks-quarkus-production-migrations

#Java #Quarkus #Flyway #Database #DevOps #Production

https://documentation.red-gate.com/flyway/ai-services-in-flyway - #Flyway is getting #AI services. Here's how to turn it on. Nice work #Redgate.

Hear ye, Java Database Touchers, hear ye! 🔊🔊🔊

I've cut a few more releases of Quuxo Migrate since 0.9 a few months back, with some important fixes, but it now also has a Maven plugin for rolling migrations forward and back in your development db's from the command line.

If you need Java SQL and other data migration support for your app and don't want to use the limited freemium-but-actually-propriety options out there, give Migrate a shot.

Feedback, testing, bug reports, pull requests, and boosts of this post all appreciated! 🙏🏻

https://codeberg.org/quuxo/migrate
https://codeberg.org/quuxo/migrate-maven

#java #sql #database #migration #flyway #liquibase

Путевые заметки о знакомстве со Spring Data R2DBC

Привет, Хабр! Меня зовут Каненков Александр, я backend-разработчик в Домклик. Не так давно я резко и с головой погрузился в мир реактивного программирования и очень заинтересовался этой темой. Хочу поделиться кратким введением в Spring Data R2DBC, зачем это нужно, как начать использовать и какие преимущества даёт. Мы разработаем небольшое приложение, добавим flyway и напишем пару тестов.

https://habr.com/ru/companies/domclick/articles/966514/

#java #kotlin #spring_data #r2dbc #testcontainers #flyway

https://github.com/dotnet/aspire/issues/4160#issuecomment-2214891909 - What if we could use #Aspire tasks to create a #database and run #db #migrations? I love this proposal idea. Yeah, you can `.AddDatabase(databaseName).WithCreationScript(creationScript)`, but how do I run #Flyway Migrate when I aspire run?

Dear Java Relational Database Touchers,

I've just released a new lightweight Java-based library for schema and data migration: Quuxo Migrate: https://codeberg.org/quuxo/migrate

Initially supporting SQL-based migrations only, but already extensible with custom migration types, it's a permissively-licenced, fully-libre, very lightweight alternative to Flyway and Liquibase.

I'm using it in production project at the moment, if it fits your needs, please give it a try.

Boosts appreciated! 🙏🏻

#java #sql #database #migration #flyway #liquibase #libresoftware

I recently read and shared You’re Wasting Time in #Java Without These 10 Libraries. I commented on it a bit in my newsletter, but given the amount and intensity of reactions, I think a full-blown post is in order.

* Project #Lombok
* #MapStruct
* #JUnit 5 & #Mockito
* #SLF4J with Logback
* Apache Commons Lang & Google Guava
* #Jackson
* Hibernate Validator
* #SpringFramework
* Apache HttpClient / OkHttp
* #Liquibase or #Flyway

https://blog.frankel.ch/wasting-time-without-10-libraries/

We've tweaked the way #SpringModulith's #Flyway support customizes the application-module-aware migrations. Now fully isolated, migration history per module. Please give it a spin before our GA release next week! 🍃📦 https://docs.spring.io/spring-modulith/reference/2.0-SNAPSHOT/runtime.html#module-aware-flyway-migrations

As of Spring Modulith 2.0, we support the execution of module-specific Flyway migrations. Application modules are encouraged to define migrations for their own persistent data only, which means that these migrations have to be executed in the order of the module dependency tree.

Assume a default Flyway setup with migrations located in classpath:db/migration, two application modules first and second (with second depending on first), and an activated spring.modulith.runtime.flyway-enabled configuration property.

With that in place we will customize the Flyway setup as follows:

The root migration folder will be changed to db/migration/__root. For that, the default version tracking table will be used.

Additional migrations for db/migration/$moduleIdentifier will be registered with a tracking table of flyway_schema_history_$moduleIdentifier. These migrations are also set up to a baseline version of 0 and set up to baseline on migrate.

Migration locations ending in a wildcard will not be customized.

Note, that he version numbers used in migration scripts are now effectively scoped to the application module and should not use global ordering.

By selecting which folder to place the migration files in, you can differentiate migrations always to be run from ones that will only get executed for the corresponding module. The application module test integration will only execute the default migration and the ones for modules included in the test run.

Best Open Source Tools for Data Migration

What are the best open-source tools for your data migration? Data migration has become a crucial aspect of IT operations. Whether you're moving data between on-premises systems, migrating to the cloud, or shifting between different databases, the right tools can make the difference between a smooth migration and a complex, error-prone process. Open-source tools are vital in simplifying data movement by offering automation, reliability, and flexibility. In this post, we will […]

https://www.simplyblock.io/blog/open-source-tools-for-data-migration/

Key facts about the data migration ecosystem and the best open source tools for data migration

Что еще могёт курсор

Началось все весьма прозаично, клиент позвонить к нам в техподдержку и спросил «а как бы мне поставить ваш софт но в другую схему БД». Собственно вопрос проще некуда — мы писали на спринге, а значит лезем в application.yml и ставим схему. Но, клиент не из тупых и уже это попробовал — не сработало. Начинаем разбираться что сломалось и кто виноват. Первым делом ДевОпс повторяет кульбиты клиента и выдает простой вердикт: «В 151 миграции лажа». Я открываю и: «батюшки родный, да это же лосенок явное указание схемы!»

https://habr.com/ru/articles/961056/

#flyway #spring #migrations #java #bruteforce

🥁📢#SpringModulith 2.0 RC1 is out! Spring Boot 4.0 RC1 upgrade and application-module-aware #Flyway migrations. https://spring.io/blog/2025/10/27/spring-modulith-2-0-rc1-1-4-4-and-1-3-10-released 🍃📦

https://www.red-gate.com/blog/new-in-flyway-pre-and-post-deployment-scripts-for-state-based-deployments-via-callbacks - #Redgate #Flyway now has pre- and post-deployment scripts in state-based #Database #Migrations

https://www.red-gate.com/blog/database-development/introducing-postgresql-static-data-in-flyway - #Redgate #Flyway adds static #data to #Postgres. Drool!!!

Absolute fantastic conversation between Marco and Axel about #Flyway #Database migration

https://www.youtube.com/watch?v=lwF2fg1fOHk

Application-module-aware #Flyway migrations have just landed in #SpringModulith! Check out the reference docs for details. https://docs.spring.io/spring-modulith/reference/2.0-SNAPSHOT/runtime.html#module-aware-flyway-migrations 🍃📦

Application-Module Aware Flyway Migrations
As of Spring Modulith 2.0, we support the execution of module-specific Flyway migrations. Application modules are encouraged to define migrations for their own persistent data only, which means that these migrations have to be executed in the order of the module dependency tree.

Assume a default Flyway setup with migrations located in classpath:db/migration, two application modules first and second (with second depending on first), and an activated spring.modulith.runtime.flyway-enabled configuration property. With that in place we will augment the configured migration to run the default one first, followed by one for classpath:db/migration/first and one for classpath:db/migration/second.

By selecting which folder to place the migration files in, you can differentiate migrations always to be run from ones that will only get executed for the corresponding module. The application module test integration will only execute the default migration and the ones for modules included in the test run.

We will not augment migration runs including wildcard expressions in the migration location definition.

Faster Feedback for Database Changes – How Real Database Branching Changes the Game

TLDR; Database change management process is a great solution to keep track and automatically apply database schema changes. This process doesn't eliminate the human factor, though. When writing code or maintaining a codebase, we need to ensure that schema and semantic changes are applied consistently. We also need to ensure we have sufficient understanding of semantics to develop for all edge cases. Production-grade database branches are the logical extension of already existing database […]

https://www.simplyblock.io/blog/database-change-management-needs-database-branching/

Tools like Liquibase help implementing a clean process to collect, version, and apply changes to the database schema. Use Liquibase and Git to build a successful database change management process.

#Landscape changes elevate the #risk of avian #influenza virus diversification and emergence in the East Asian–Australasian #Flyway, https://etidiohnew.blogspot.com/2025/08/landscape-changes-elevate-risk-of-avian.html

https://www.red-gate.com/products/redgate-pgcompare/ - pgCompare is a free (non-commercial) tool for comparing two #Postgres databases and applying the differences. Want to script it in a DevOps pipeline? Upgrade to #Redgate #Flyway.

Just published a blog post on optimizing Gradle builds with Docker, Flyway, jOOQ & Postgres 🐘🐳🐦

I hit a weird issue where the DB started up even when everything was up-to-date. Turns out: Gradle task graphs & build services can be tricky!

Here’s how I fixed it with a cleaner setup 👇
https://britter.dev/blog/2025/07/22/gradle-jooq-docker/

#gradle #docker #jooq #flyway #java #devlog #programming

#Flyway

Client Info