We want your feedback. Take the Liquibase Usability Survey!

New Liquibase.org

You’ve probably noticed some changes here on Liquibase.org. The cosmetic stuff is just one small piece of a much larger change, so let’s jump in. Community ...

Read more

Liquibase 3.9.0 Released

Liquibase 3.9.0 is now available. Here's a closer look at what's included in the latest release.Liquibase Pro extended diff command capabilityAutomate ...

Read more

Making it easier to contribute code to Liquibase

The internal Liquibase team spent the past month streamlining code contributions for Liquibase Community! We have a lot of updates to share.Making it simple to ...

Read more

New Beta Program for Liquibase 4.0

Hey community, we are on our way to making Liquibase 4.0 a reality! This major release contains hundreds of bug fixes and improvements, merging dozens of Pull Requests and ...

Read more

Liquibase 4.0 Beta 1 Released

Liquibase 4.0 Beta 1 is now available through Liquibase.org. In this new major release, we have integrated dozens of community Pull Requests, addressing well over 100 bugs, in ...

Read more

Liquibase 3.8.9 Released

Liquibase 3.8.9 is now available through Liquibase.org. We’re continuing to improve everyone’s experience with Liquibase by fixing some bugs and improving existing ...

Read more

Diffs: The Good, the Bad, and the Ugly of Comparing Databases

Database diffs are a great tool to have in your toolbox. They can provide a super-easy way to begin using Liquibase on existing projects. You can simply run the ...

Read more

Liquibase 3.8.8 Released, Provides Minor Bug Fixes

Liquibase 3.8.8 is now available. We fixed a couple of minor bugs in this release.​Bug FixesFor both Liquibase Community and Liquibase Pro users, the following bugs ...

Read more

Recent Liquibase Articles, March 2020

Here are some articles and other interesting things written by the many people around the world that are using Liquibase.JHipster Crash Course - Part 1JHipster is an ...

Read more

Liquibase 3.8.7 Released

Liquibase 3.8.7 is now available. Here’s a closer look at what’s included in the latest release.Liquibase 3.8.7 OverviewMore Targeted Rollback functionality for ...

Read more

Liquibase Installer: An Easier Way to Get Started with Liquibase

Our team has been working on making Liquibase easier for new users to install and to get up and running quickly with all-in-one Windows and MacOs installers.Watch the MacOS ...

Read more

Liquibase 3.8.6 Released

Liquibase 3.8.6 is now available. Here’s a closer look at what’s included in the latest release.Liquibase 3.8.6 OverviewIntroducing Targeted Rollback for Liquibase ...

Read more

Recent Liquibase Articles, February 2020

Here are some articles and other interesting things written by the many people around the world that are using Liquibase.SQLcl : Automating Your SQL and PL/SQL Deployments ...

Read more

3 Ways to Run Liquibase

There are a few different ways to run Liquibase. Each application and project team has different needs so the best way to run Liquibase depends on what works best for your use ...

Read more

Liquibase Works with Plain Old SQL

It’s time for some myth-busting! Yes, Liquibase really can work with SQL scripts. In fact, our recent Liquibase survey revealed that most of our users prefer using ...

Read more

Liquibase 3.8.5 Released

Liquibase 3.8.5 is now available. Here’s a closer look at what’s included in the latest release.Liquibase 3.8.5 Bug Fix OverviewWe’ve fixed a number of issues with ...

Read more

Top 10 Findings from Our 2019 Liquibase Community Survey

First, a huge THANK YOU to everyone who participated in the Liquibase community survey. We had the best turnout ever and really appreciate all of the great input and feedback. ...

Read more

Liquibase 3.8.4 Released

Liquibase 3.8.4 is now available. Here’s a closer look at what’s included in the latest release.Liquibase 3.8.4 OverviewLiquibase 3.8.4 fix for Liquibase Pro Spring ...

Read more

Liquibase 3.8.3 Released

Liquibase 3.8.3 is now available. Here’s a closer look at what’s included in the latest release.Liquibase 3.8.3 OverviewImproved Support for Liquibase-Maven Plugin ...

Read more

Recent Liquibase Articles, December 2019

Here are some recent mentions of Liquibase on other sites.Fear database changes? Get them under control with CI/CD Why you should be including database concerns in your ...

Read more

5 Ways to Fix a Bad Database Change in Liquibase

You’ve just run a liquibase update. Moments later, your stomach churns as you realize that there were some big mistakes in the changes you just deployed and your database is ...

Read more

Liquibase 3.8.2 Released

Liquibase 3.8.2 is now available. Here’s a closer look at what’s included in the latest release.Snapshots and Reverse Engineering Expands to PostgreSQL and DB2TL;DR: ...

Read more

Liquibase 3.8.1 Released

Liquibase 3.8.1 is now available. Here’s a closer look at what’s included in the latest release.Liquibase bug fixes & doc updatesBoth Liquibase Community and ...

Read more

Liquibase 3.8.0 Released

Liquibase 3.8.0 is now available.Liquibase now comes in two modes:Liquibase CommunityLiquibase ProThe 3.8.0 release adds the ability to enter a license key for a ...

Read more

Improving Community Support

It’s an exciting time for the Liquibase community. The latest release, 3.7, has over 350 commits from the community and from Datical. Datical has dedicated several engineers to ...

Read more

What we learned from the 2018 Liquibase Community survey

Last year, we invited the Liquibase community to take a survey to help us understand how Liquibase is used and how we can improve. A small sample size from our community (a ...

Read more

Liquibase 3.7.0 Released

Liquibase 3.7.0 is now available.Version 3.7.0 is primarily a bugfix release, but there have been over 350 commits since 3.6.3, so TONS of good new things from both the ...

Read more

Updates to Liquibase Hibernate and HANA Extensions

We have reviewed and accepted pull requests for extensions that add and enhance support for Hibernate and HANA. Hibernate is one of the most popular Java ORMs and SAP HANA powers ...

Read more

Liquibase 3.6.3 Released

Liquibase 3.6.3 is now available. Question or comments can be directed to answer@liquibase.org.Version 3.6.3 is a bugfix release while we work on a 3.7.0 release.Fixes ...

Read more

Taking the XML Changeset and Changelog Workflows to the Next Level

As many of you know, a few years after starting the Liquibase open-source project, I joined the team at Datical. For those who are unaware, Datical is a commercial solution built ...

Read more

Liquibase 3.6.2 Released

Liquibase 3.6.2 is now available from liquibase.org/download and through the Maven repositories. Question or comments can be directed to ...

Read more

Liquibase 3.6.0 Released

Liquibase 3.6.0 (actually 3.6.1 as well) is now available from liquibase.org/download and through the Maven repositories. Question or comments can be directed to ...

Read more

2018 Community Survey

Listening to feedback from the community is a vital part of any open source project and it has frankly been a little too long since I’ve had the chance to hear the voice of ...

Read more

Liquibase 3.5.5 Released

For those of you not watching the download page every day, Liquibase 3.5.5 was released on Feb 15th.The 3.5.5 release is a bugfix release, pulling in a few high-prioritly/low ...

Read more

Liquibase Hibernate Plugin 3.6 Released

After far too long, the Liquibase-Hibernate plugin has been updated to support Hibernate 5.x!!To use the new Hibernate 5 support, either download the ...

Read more

Liquibase 3.5.3 Released

The issue that caused me to pull the 3.5.2 release turned out to be a false alarm.Therefore, Liquibase 3.5.3 is now available from liquibase.org/download and ...

Read more

Liquibase 3.5.2 Released

Bugfix release Liquibase 3.5.2 is now available from liquibase.org/download and through the Maven repositories.Highlights include:Formatted SQL added ...

Read more

Top 5 Indicators You Are Ready to Move to Liquibase Enterprise

Ten years ago, I started Liquibase to bring sanity to my database schema changes. At the time, I was working on a 3-tier Java web project. Ruby on Rails had Active Record ...

Read more

Expanding Database Support

Liquibase has always focused mainly on “standard” SQL databases, but we are looking to improving support for NoSQL databases like Cassandra, MongoDB, Hadoop and ...

Read more

Happy birthday to Liquibase

10 years ago today was the initial public announcement of Liquibase, originally called the “Sundog Database Refactoring Tool”.Like most open source projects, Liquibase ...

Read more

Liquibase for DBAs

The role of the Database Administrator is evolving and has never been more complex. DBA’s are constantly juggling schema management, performance tuning, change control, plus ...

Read more

Liquibase for Application Developers

Agile development practices and modern source control systems such as Git have transformed how application software is developed and managed.But for many application ...

Read more

Liquibase 3.5.1 Released

Bugfix release Liquibase 3.5.1 is now available from liquibase.org/download and through the Maven repositories.Fixes include:Fixed handling of Liquibase running ...

Read more

Liquibase for Application Release Managers

In the modern agile development environment there is a lot that happens in a very short period of time. This means application release managers need to be efficient with their ...

Read more

Liquibase 3.5.0 Released

Liquibase 3.5.0 is now available from liquibase.org/download and through the Maven repositories. Question or comments can be directed to ...

Read more

Liquibase for QA Test Teams

As a QA team member, you always make sure you are testing the current version of an application. However, it is just as important that the testing schema is correct and that ...

Read more

Liquibase 3.4.2 Released

Bugfix release Liquibase 3.4.2 is now available from liquibase.org/download and through the Maven repositories.Fixes include:Maven <skip> configuration ...

Read more

Halloween Fun

Halloween–the spookiest night of the year. Spookiest night for those who don’t do production deployments anyway…So, for you sys admins, DBAs, and developers who know ...

Read more

2015 Survey Results

There were 136 responses to the 2015 Liquibase Survey. Since I’m relying on self-selection for people answering the survey, the first question is how representative is the ...

Read more

Liquibase Without Changelogs

Early on, Liquibase only supported XML changelogs with each changeSet listed in it. There are many advantages to using that setup, but there are now many different ways to store ...

Read more

Liquibase Status: Sep 2015

If you missed last month, I’ve started a monthly status post to give a better window into Liquibase development and the Liquibase community. I’d appreciate any feedback you ...

Read more

Liquibase Survey 2015

One problem with running an open source project is that we don’t really have “customers” to contact for feedback and product suggestions. I can always just add features ...

Read more

Liquibase Status: August 2015

This is the first in a planned monthly post designed to give a better window into Liquibase development and the Liquibase community. I’d appreciate any feedback you have on how ...

Read more

Liquibase 3.4.1 Released

Bugfix release Liquibase 3.4.1 is now available.Fixes include:improvements to includeAll logicbetter handling of older-version DATABASECHANGELOG table structures with ...

Read more

Executing Liquibase: 3 Use Cases

Once you’ve created a database changelog file, what is the best way to run it? As always, it depends on what works best for you. There are three main ways to run Liquibase: ...

Read more

Liquibase Without a Database Connection

There are many, many different processes and requirements companies have for managing their database schemas. Some allow the application to directly manage them on startup, some ...

Read more

Liquibase 3.4.0 Released

Liquibase 3.4.0 has been released and is working its way through the Maven mirrors.Lots of good things in 3.4.0, but some highlights include:You can now save snapshots ...

Read more

Liquibase downloads moved off SourceForge

When I first released Liquibase as open source in 2006, Sourceforge was the obvious place to host the project. Over the years, however, I’ve been slowing shifting functionality ...

Read more

Trimming Liquibase ChangeLogs

For people who have used Liquibase for a long time, a common question they have is how to clear out a changelog file that has gotten unwieldy.The standard process for using ...

Read more

Liquibase 3.3.5 Released

Yes, I know 3.3.4 just came out yesterday, but there was a configuration issue that affected dependencies in Maven.3.3.5 resolves this with no other ...

Read more

Liquibase 3.3.4 Released

Bugfix release Liquibase 3.3.4 is now available on Liquibase.org and through the Maven repositories.The most notable fix was to make the Maven plugin ...

Read more

Liquibase and Datical

For those of you who don’t know, I’ve been working for Datical for the last year and a half as “Benevolent Dictator for Life.” I often joke that I feel like I’m ...

Read more

Liquibase 3.3.3 Released

Liquibase 3.3.3 is primarily a bug fix release.As always, Liquibase can be downloaded from the Liquibase download page and is available in the Maven repository as ...

Read more

Liquibase 3.3.2 Released

Liquibase 3.3.2 is officially released. It is primarily a bugfix release, but has one major new feature: object diffChangeLog/generateChangeLog object ...

Read more

Understanding Contexts vs. Labels

A new feature with Liquibase 3.3 is “labels”. Labels are similar to contexts in that both allow you to chose a subset of changeSets to execute at runtime. Labels are also ...

Read more

Liquibase 3.3.0 and 3.2.3 Released

Liquibase 3.2.3 and 3.3.0 have been released. As usual, they can be downloaded from the Liquibase download page and are available in the Maven repository as ...

Read more

Liquibase 3.2.2 Released

Liquibase 3.2.2 has been released. It is a small bugfix release to fix a checksum regression from 3.1 -> 3.2 that was not fixed in 3.2.1.Issues ...

Read more

Liquibase 3.2.1 Released

Liquibase 3.2.1 has been released. As usual, it can be downloaded from the Liquibase download page and is available in the Maven repository as ...

Read more

Adding Liquibase to an Existing Project

The Quick Start Guide works well for starting Liquibase on a new project because your empty changelog file matches your empty database. However, when you have an existing ...

Read more

Liquibase 3.2.0 Released

Liquibase 3.2.0 has been released. As usual, it can be downloaded from the Liquibase download page and is available in the Maven repository as ...

Read more

Slides from Percona Live Talk

I posted the slides from my Percona Live talk at https://www.percona.com/live/mysql-conference-2014/sessions/liquibase-source-control-your-schema.I modified them from the ...

Read more

Liquibase Talk at Percona Live

I’ll be giving a talk at Percona Live in Santa Clara on April 3rd titled “Liquibase: Source Control For Your Schema”.It is a beginner-level course covering Liquibase ...

Read more

Liquibase Hibernate Extension 3.3 Released

The Liquibase hibernate extension has been updated for both hibernate 3 and hibernate 4.Major changes include:Support for Liquibase 3.1.1Support for Hibernate ...

Read more

Liquibase 3.1.1 Released

Liquibase 3.1.1 has been released with a few bug fixes. The most important fixes reverts how <createProcedure> checksums are computed so they are compatible with 3.0 and fix ...

Read more

Liquibase 3.1.0 Released

Liquibase 3.1.0 has been released. For most people 3.1 is a drop in replacement for 3.0.If you use <includeAll> with relative paths or are running against ...

Read more

Liquibase 3.0.8 Released

Liquibase 3.0.8 is officially released. It is purely a bugfix release that covers improvements to data type handing, performance improvements, and much ...

Read more

Experimental Amazon Redshift Support

A new Liquibase-Redshift extension is now available at https://github.com/liquibase/liquibase-redshift. If you are interested in trying out Liquibase with Amazon Redshift, give ...

Read more

Liquibase Hibernate Extension 3.1 Released

The Liquibase hibernate extension has been updated for both hibernate 3 and hibernate 4.This release adds support for catching changes to sequences and unique constraints as ...

Read more

Liquibase 3.0.7 Improves Memory Usage

Lots of good bugfixes in 3.0.7, but major improvements are:Significantly decreased memory usage, especially with large sql filesImproved checksum performanceFixed SQLite ...

Read more

Group of Liquibase Extensions Updated

There has been a lot of activity the last couple weeks on the Liquibase extensions I manage and/or have source access to. There were a few running up against the Oct 15th ...

Read more

New Liquibase Hibernate Extension Released

After far too long, a new version of the Liquibase-Hibernate extension has been released!Downloads, documentation, and issue tracking is hosted ...

Read more

Liquibase 3.0.6 Released

I’m happy to announce Liquibase 3.0.6 has been released. While the previous release focused on performance, this release was focused on catching up with pull requests and ...

Read more

Full Speed Ahead for Liquibase

For the last two months I have been working full time as an employee with Datical, a startup that is building an enterprise-ready database change management solution on top ...

Read more

Liquibase 3.0.5 Released

The major focus of this release is performance improvements:Startup time is significantly improved for larger databasesPreconditions now snapshot far less of the ...

Read more

Liquibase 3.0.4 Released

There was a null pointer issue that was tripping up enough people with 3.0.3 that I created a small 3.0.4 release to address the issue.The issues fixed ...

Read more

Liquibase 3.0.3 Released

Liquibase 3.0.3 has been officially released. As always, you can download from the Liquibase download page and the new version should be working its way through the maven ...

Read more

Liquibase 3.0.2 Released

Liquibase 3.0.2 has been officially released. It is a purely bugfix release. The major issues fixed are:Indexes and foreign keys were not being correctly handled in the ...

Read more

Liquibase 3.0.0 Released

At long last, I’m happy to announce that Liquibase 3.0.0 is finally out!There has been a lot of changes and a lot of work put into 3.0, but the major highlights ...

Read more

Liquibase 3.0 Beta 1

Although it has been far too long since the last liquibase release, that is not from a lack of work. I’ve been hard at work at a major update that has been stuck in the “I ...

Read more

Liquibase 2.0.5 Released

2.0.5 has been released. This is to fix a couple regressions introduced in 2.0.4.Download from the Liquibase download page.Bug Fixes:Removed new load blob/clob data ...

Read more

Liquibase 3.0 Status Update

It has been a while since the last Liquibase release, and I wanted to give a quick status update.The main thing I have been working on is the next version of Liquibase, which ...

Read more

Liquibase 2.0.3 Released

2.0.3 is a very small update, mainly fixing the maven repository and the end of line char in the command line unix shell script.Other bugs fixed are:Allow Changelog ...

Read more

Liquibase 2.0.2 Released

Liquibase 2.0.2 has been released. It is primarily a bug fix release on the 2.0.1 release and can be downloaded from the Liquibase download page.Visit the forum with any ...

Read more

Liquibase Source Moved to GitHub

For those of you watching and/or contributing to the Liquibase source code, the repository has now moved from the old subversion repository at liquibase.jira.com ...

Read more

NetBeans Liquibase Plugin Available

For NetBeans users, there is a Liquibase plugin now available.The current, 0.2 version implements rudimentary support and concentrates on the most needed ...

Read more

Clojure Wrapper for Liquibase Now Available

Kumar Shantanu has implemented a Clojure DSL/wrapper for Liquibase which is has reached version 0.1. It is available at https://bitbucket.org/kumarshantanu/clj-liquibase/src. One ...

Read more

Liquibase 2.0 Officially Released

At long last, Liquibase 2.0 has been released. For those of you watching closely, you know that 2.0.0 was actually released December 19th, but I wanted to give it a couple weeks ...

Read more

New Standard Liquibase Plugin: Grails Database Migration

Now that the Grails Database Migration plugin has had its first release, I will no longer continue maintaining a the Liquibase Grails plugin past the current 1.9.x ...

Read more

Liquibase 2.0 Apache 2.0 License

As of the 2.0 release of Liquibase, we will switch to being licensed under the Apache License, version 2.0 rather than the LGPL.The reason for the change is to make Liquibase ...

Read more

Liquibase Formatted SQL

Part of the changes made in the upcoming 2.0 release is supporting the ability to specify changelog files in formats other than XML.As a proof of concept, I added the ability ...

Read more

Liquibase 2009 Plugin Content Winners

Congratulations to the winners of the 2009 Liquibase Plugin Contest!Grand Prize (Choice of 5 O’Reilly Books, donated by O’Reilly):Oracle Extensions by ...

Read more

Liquibase 1.9.5 Released

Liquibase 1.9.5 has been released, and can be downloaded from Liquibase download page.This is purely a bugfix release. As usual, let us know on the forums if you ...

Read more

Liquibase Extension Contest 2009 Now Underway

Liquibase 2.0 is all about 3rd party extension and integration, and to help kick that off, we are holding a contest.Thanks to donations ...

Read more

Liquibase 1.9.4 Released

Liquibase 1.9.4 has been released. The 1.9.x branch continue to be maintained, even as work continues on Liquibase 2.0.1.9.4 is primarily a bug fix release, but also ...

Read more

Database Version Control on Stack Overflow Podcast

One of the questions that was discussed on a recent StackOverFlow podcast was “Do you source control your database”.It is, obviously, a question near to my heart and I ...

Read more

Looking for Feedback on Statement Refactoring

I am starting the extensibility refactoring at the *Statement class level and moving up from there. I committed an initial version of what I am thinking to trunk, and am looking ...

Read more

Moving Test Datasets Across Database Types

While the main goal of Liquibase is database change tracking, I found a very different use for it lately: moving test datasets.I have an application that has been ...

Read more

Liquibase 1.9.2 Released

Liquibase 1.9.2 has been released. It is a bugfix release, mainly around issues with the includeAll tag.Like always, it can be downloaded ...

Read more

What Affects ChangeSet Checksums?

We store an md5 checksum with each changeset entry in the database changelog table to detect differences between what is currently in the changelog and what was actually ran ...

Read more

Liquibase 1.9.1 Released

Liquibase 1.9.1 has been released which addresses several bugs. Most bugs were relatively minor, but it is recommended you upgrade.Some of the bugs fixed include:H2 ...

Read more

Liquibase 1.9.0 Released

Liquibase 1.9.0 has been released!Major features include:modify SQL supportincludeAll supportSybase Adaptive SQL Anywhere supportPaths in <include> can be relative to ...

Read more

Dealing with Changing ChangeSets

The goal of a Liquibase change log file is to track the linear sequence of changes required to take a database from a starting point to the current state, and it is built up one ...

Read more

Liquibase 1.8.1 Released

Liquibase 1.8.1 is now available for download. It is a bug fix release that fixes several minor bugs found in 1.8.0.As usual, if you have any questions or comments, ...

Read more

Liquibase 1.8.0 Released

Liquibase 1.8.0 has been released.Major changes include:Improvements to preconditionsonFail and onError controlsSeveral new precondition checksCustom preconditions ...

Read more

Martin Fowler on Incremental Data Migration

Martin Fowler makes good points in his Incremental Migration Bliki post. Data migration is easy to push off or forget, and can often kill an otherwise great ...

Read more

Liquibase 1.7.0 Released

It is Liquibase 1.0’s first birthday, but you get the gift: Liquibase 1.7.0 is now available.Major changes include:Added loadData change which allows importing of ...

Read more

Liquibase 1.6.1 Released

Liquibase 1.6.1 has been released.This is primarily a bug fix release, but also includes a release of the 1.6 version to the Maven (still propagating), Grails, and IntelliJ ...

Read more

Liquibase 1.6.0 Released with Hibernate Support

The Liquibase team is proud to announce the 1.6.0 Liquibase Core release.This release focuses primarily on Hibernate integration which allows you to use ...

Read more

Liquibase 1.5.2 Released

Liquibase 1.5.2 has been released.Changes include:Fixed bug with runOnChange and MD5sum checkHandles generating changelog for tables with composite primary keysOther ...

Read more

Why aren’t Databases Version Controlled?

There was a great post the other day on Coding Horror titled “Get Your Database Under Version Control”.It references a good series of posts by K. Scott ...

Read more

Liquibase 1.5.1 + Grails and IntelliJ Plugins Released

Liquibase Core 1.5.1 has been released along with the initial 1.5.x series Grails and IntelliJ plugins.Changes to the core library are minor bug fixes including:Fixed ...

Read more

Liquibase 1.3 Released

...

Read more

SOX Compliance and Database Refactoring

Managing, tracking, and applying database changes is difficult, especially in an agile database environment where there are many changes made throughout a project’s life cycle. ...

Read more

Liquibase 1.0 Released

The Liquibase team is proud to announce version 1.0. Liquibase is an open source (LGPL) java-based tool for managing database changes and refactorings. It has been under active ...

Read more

The Problem with Rails Active Migrations

Rails Active Migration is nice for its simplicity, but in non-trivial projects, it quickly falls apart due to limitations it has regarding multiple developers and/or branches. ...

Read more

Managing Change Logs

While you can include all your change sets in one giant change log, there are many good reasons to split them up. While there are many ways to divide your change logs, the best ...

Read more

The Problem with Database Diffs

When talking about how Liquibase works, I’m often asked “Why not just do a database diff to know what changes need to be applied to a new database?”There are advantages ...

Read more

Building Database Tests that Don’t Break

As I discussed in Unit Testing the Database, a difficulty you run into when using a shared dataset for unit tests is making sure you write your test in such a way that changes ...

Read more

Unit Testing the Database Access Layer

The ProblemWriting unit tests for code that accesses a database is a difficult problem, and it’s one I’ve struggled with for several years. The problems come down to a ...

Read more

The Road to Liquibase 1.0 and Beyond

There is a lot going on in Liquibase-land right now.We are finishing up code and documentation clean-up of the Liquibase migrator and hope to have an initial release ...

Read more