Can you explain what Liquibase is and how it is used for database management?

Liquibase is a tool for database version control (Database Change Management). It allows describing database structure changes (creating tables, modifying columns, adding indexes, etc.) in scripts or XML/JSON/YAML files called changelog.

Main features of Liquibase:

• Automatic application of changes to the database in the correct order
• Tracking already applied changes
• Rollback capability
• Support for various DBMS

Example of usage: you write a changelog describing changes, and Liquibase applies them to the database, ensuring that all developers and environments have the same database structure.

Example of a changelog in XML:

<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
    http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">

    <changeSet id="1" author="dev">
        <createTable tableName="person">
            <column name="id" type="int" autoIncrement="true" primaryKey="true"/>
            <column name="name" type="varchar(255)"/>
        </createTable>
    </changeSet>

</databaseChangeLog>

Liquibase is often integrated into CI/CD processes for automatic database updates during deployment.