Company
Date Published
Author
Sfurti Sarah
Word count
1242
Language
English
Hacker News points
None

Summary

Liquibase is an open source change management project that supports various databases, including Snowflake, MySQL, and PostgreSQL via JDBC. It allows users to define changes in SQL, XML, JSON, or YAML, which are then managed in a version control system for documentation, ordering, and standardization. Liquibase can be used with YugabyteDB, a distributed SQL database. To start using Liquibase with YugabyteDB, one needs to install it on their local workstation, create a cluster, and add the necessary dependencies, including the Liquibase YugabyteDB extension. The extension overrides methods from PostgreSQL database implementation for changes where PostgreSQL and YugabyteDB differ. A changelog file is created to manage sequence of changesets, each making small changes to the structure of the database. The changelog file contains XML code that defines the changeset, which can be executed using the `liquibase update` command. After executing the first change, a second change can be issued using SQL in a separate file, and it will be executed similarly. However, certain changesets are not supported by YugabyteDB yet, such as dropPrimaryKey or addUniqueConstraint.