Liquibase and Spring Boot

I think it’s great that Spring Boot has built-in support for Liquibase but I think there is missing documentation on it. Some of it is on Spring’s part and others are in Liquibase. I hope to demystify it a bit.

Spring Boot’s default master change log is db/changelog/db.changelog-master.yaml . Note the file extension is yaml not the standard yml. No idea why they did it that way.

For database migrations, I don’t like storing everything in one changelog file. Instead I like putting them in different files in a folder. Liquibase has an includeall directive but only documents it in XML. Not sure how I figured this out but here is how I did it with yaml:

databaseChangeLog:
   - includeAll:
       path: classpath*:db/changelog/changes/

So now I can store my changes in classpath*:db/changelog/changes/ with any format that I want.

Lastly you can use Spring Intializr to put Liquibase in your project but, oddly, it doesn’t include the Liquibase plugin if you pick Maven or Gradle, which means that you don’t have Liquibase commands in your build file. So be aware that, regardless of your build tool, you will have to do more work to get things as workable as it should be.

About the Author

Mike Hostetler profile.

Mike Hostetler

Principal Technologist

Mike has almost 20 years of experience in technology. He started in networking and Unix administration, and grew into technical support and QA testing. But he has always done some development on the side and decided a few years ago to pursue it full-time. His history of working with users gives Mike a unique perspective on writing software.

One thought on “Liquibase and Spring Boot

  1. Gustavo says:

    classpath*:db/changelog/changes/ exactly what I was looking for. Thank you!

  2. Brendan says:

    I had trouble using `classpath:` in my configuration because the liquibase-maven-plugin starts by searching the classpath.

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Blog Posts
Feature Flags in Terraform
Feature flagging any code can be useful to developers but many don’t know how to or even that you can do it in Terraform. Some benefits of Feature Flagging your code You can enable different […]
Infrastructure as Code – The Wrong Way
You are probably familiar with the term “infrastructure as code”. It’s a great concept, and it’s gaining steam in the industry. Unfortunately, just as we had a lot to learn about how to write clean […]
Snowflake CI/CD using Jenkins and Schemachange
CI/CD and Management of Data Warehouses can be a serious challenge. In this blog you will learn how to setup CI/CD for Snowflake using Schemachange, Github, and Jenkins. For access to the code check out […]
How to get your pull requests approved more quickly
TL;DR The fewer reviews necessary, the quicker your PR gets approved. Code reviews serve an essential function on any software codebase. Done right, they help ensure correctness, reliability, and maintainability of code. On many teams, […]