Many of the evolutions presented by the Platform, whether to add new functionalities or to improve existing ones, require modifications to our databases. To facilitate this process and automate it as much as possible, version 5.2.0-Topgun of Onesait Platform has added Liquibase as a database change management tool.
What is Liquibase?
Liquibase is an open source database-independent library for tracking, managing and enforcing database schema changes.
To run Liquibase on a database, simply specify the database data. Once configured, it is enough to have the sentences to be applied in a file called “changelog” (which can be defined in different formats, facilitating the abstraction on the databases). Once executed, Liquibase generates information about the execution in the database, allowing both the analysis of the results and the possibility of rollback.
How does Liquibase fit into the dynamics of continuous integration?
In order to make the necessary changes to the existing database schemas in the Platform, Liquibase has been used by integrating it with GitLab and Jenkins to follow a CI/CD cycle.
For this, we have used the containerized version of Liquibase, which will be launched on the target environment using Jenkins for this purpose.
We have configured this cycle in such a way that by parameterizing the execution simply with the version to be applied from Jenkins, it applies the whole process with Liquibase and the changelog corresponding to the version.
Liquibase therefore helps the process of automation and traceability of changes in a database.
If you are interested in learning more about this DevOps new functionality, do not hesitate to leave us a comment or send us a notice on our Onesait Platform support channel.