My main use case for Liquibase is currently data warehouse deployment.
For data warehouse deployment, we have a product with SQL Server, and we use Liquibase as part of scripts for data warehouse layers with CI/CD based on a copy solution.
Another use case connected with Liquibase is application deployment; it was an application based on Oracle and SQL Server databases, and we use Liquibase as a deployment method for both databases.
The best features Liquibase offers compared to competitors include its flexibility with the options of files that you could use for delivery, such as YAML, XML, and SQL, providing various possibilities to deliver the best script for various deployments.
The flexibility of using different file formats in my day-to-day work can be easier if I use YAML or XML files for applications, which are set up based on various RDBMS; however, for data warehouse, SQL code is more useful because the code is much longer, based only on one database type, and that is why we use SQL for warehousing and XML or YAML file for application deployment.
Liquibase has positively impacted my organization by speeding up the deployment process in the CI/CD framework, being much more useful than different solutions for database deployment that we used before.
While we did not create any KPI for that, we notice it is much quicker, especially in application deployment when we have only two configuration files for various database setups, allowing us to deploy a new version of an application within minutes instead of hours; for data warehousing, we use a lot of variables that enable us to create dynamic stored procedures, making it feasible even without KPIs, as it saves our team from having to recreate code for various environments.
Liquibase contains most of the features that we really need in the project; however, SQL files could be extended by an additional layer of prerequisites since YAML and XML files have that option, and I believe SQL files could also benefit from having more complex prerequisites.
I have been using Liquibase for five years.
Regarding Liquibase's AI capabilities, I think it is secure due to the lack of SQL injection, and that suffices for that solution.
In terms of Liquibase's AI capabilities, its accuracy and reliability of output is currently very reliable for the solution that we need.
My advice for others looking into using Liquibase is that they should connect it with GitHub actions because it is a really useful solution. I give this review an overall rating of 10.