Get your free Liquibase Fundamentals Certification!
Anyone that manages a Cockroach database knows that at some point you’ll need to modify your database schemas. Perhaps you need to store new kinds of information. Or maybe ...
“Wait! You’re saying strangers will be touching the code?” Just the thought of a developer I’ve never met changing code I’m responsible for testing was a ...
There are so many scenarios where using XML changelogs can be extremely useful. Yes, you can use plain old SQL. And yes, sometimes it seems like formatted SQL changelogs are an ...
There are situations where grants or synonyms need to be created for all objects that meet certain criteria, one example is when they belong to a specific schema. You could rely ...
Docker is super awesome for running machines that we previously used via virtual machines. But, each virtual machine requires a separate copy of the operating system. That’s a ...
We are excited to announce the penultimate 3.x Liquibase release in Liquibase 3.10.2, available now!Community contributions andbug fixesThis release merges many ...
Using Liquibase diff commands gives you a powerful way to compare two database schema states. Diff commands are handy when you need to examine an unexpected change. ...
I recently had to set Liquibase up to do some work on Azure Postgres. Both Azure and Postgres have seen an uptick in popularity and the combination works really well. ...
Are you looking for an easy bit of professional development during the pandemic? If you work in DevOps, I think our Liquibase Fundamentals certification is time well spent. ...
Communities are pretty dang cool and powerful. People from all over the world with different perspectives come together to connect and break bread over a cause they believe in, a ...
We are excited to announce that Liquibase 4.0 is now available. This is the first semantic versioning number upgrade in a long time.Liquibase 4.0 is the result of thousands ...
Liquibase 3.10.1 is now available. Here’s a closer look at what's included in the latest release.Community contributions for many, many bug fixesWe've brought in so ...
You can now download Liquibase 4.0 Beta 2. Here’s an overview of what’s in this latest Beta release. Improvements and BugfixesHere’s what’s new in this ...
Lately, I have been really into the She-Ra reboot on Netflix. It’s easy-to-watch and engaging. But more than that, it feels really familiar to me. See if you can follow me on ...
Sometimes you need to modify SQL in specific changesets and you still want to use the abstracting power of XML to make your change database agnostic. Although Liquibase supports ...
Liquibase 3.10.0 is now available with SQL Plus integration, custom executor extensibility, and a new auto-complete Bash script. Here’s a closer look at what’s included in ...
We asked and you answered! THANK YOU to everyone who participated in the Liquibase Usability survey. Those who took the time to jot down their thoughts are stars in the Liquibase ...
Liquibase extensions allow developers to easily create support for all databases. With extensions for MongoDB, Snowflake, SAP HANA, and many more, developers across the world are ...
We’re excited to share our new forum! Zoho had served us well for many years, but there were a lot of issues. New users would get 404s when trying to sign up and it just ...
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 ...
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 drift detection at ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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: ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Liquibase 3.6.2 is now available from liquibase.org/download and through the Maven repositories. Question or comments can be directed to ...
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 ...
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 ...
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 ...
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 ...
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 ...
Bugfix release Liquibase 3.5.2 is now available from liquibase.org/download and through the Maven repositories.Highlights include:Formatted SQL added ...
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 ...
Liquibase has always focused mainly on “standard” SQL databases, but we are looking to improving support for NoSQL databases like Cassandra, MongoDB, Hadoop and ...
10 years ago today was the initial public announcement of Liquibase, originally called the “Sundog Database Refactoring Tool”.Like most open source projects, Liquibase ...
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 ...
Agile development practices and modern source control systems such as Git have transformed how application software is developed and managed.But for many application ...
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 ...
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 ...
Liquibase 3.5.0 is now available from liquibase.org/download and through the Maven repositories. Question or comments can be directed to ...
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 ...
Bugfix release Liquibase 3.4.2 is now available from liquibase.org/download and through the Maven repositories.Fixes include:Maven <skip> configuration ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Bugfix release Liquibase 3.4.1 is now available.Fixes include:improvements to includeAll logicbetter handling of older-version DATABASECHANGELOG table structures with ...
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: ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Liquibase 3.3.2 is officially released. It is primarily a bugfix release, but has one major new feature: object diffChangeLog/generateChangeLog object ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Liquibase 3.0.8 is officially released. It is purely a bugfix release that covers improvements to data type handing, performance improvements, and much ...
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 ...
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 ...
Lots of good bugfixes in 3.0.7, but major improvements are:Significantly decreased memory usage, especially with large sql filesImproved checksum performanceFixed SQLite ...
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 ...
After far too long, a new version of the Liquibase-Hibernate extension has been released!Downloads, documentation, and issue tracking is hosted ...
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 ...
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 ...
The major focus of this release is performance improvements:Startup time is significantly improved for larger databasesPreconditions now snapshot far less of the ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
For NetBeans users, there is a Liquibase plugin now available.The current, 0.2 version implements rudimentary support and concentrates on the most needed ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
Liquibase 1.9.0 has been released!Major features include:modify SQL supportincludeAll supportSybase Adaptive SQL Anywhere supportPaths in <include> can be relative to ...
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 ...
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, ...
Liquibase 1.8.0 has been released.Major changes include:Improvements to preconditionsonFail and onError controlsSeveral new precondition checksCustom preconditions ...
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 ...
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 ...
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 ...
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 ...
Liquibase 1.5.2 has been released.Changes include:Fixed bug with runOnChange and MD5sum checkHandles generating changelog for tables with composite primary keysOther ...
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 ...
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 ...
Liquibase 1.3 has been released. Major features include:Added `custom` changeAdded `executeCommand` changeAdded `createProcedure` changeAdded sqlCheck ...
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. ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
