Liquibase
Praneeth Varma
Nov 23, 2020
0 views0
Comments
Liquibase
DatabasesWhat is Liquibase?
Liquibase is th leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process.
Liquibase is a tool in the Databases category of a tech stack.
Key Features
Supports code branching and mergingSupports multiple developersSupports multiple database typesSupports XML, YAML, JSON and SQL formatsSupports context-dependent logicCluster-safe database upgradesGenerate Database change documentationRollbacksGenerate Database "diff's"Run through your build process, embedded in your application or on demandAutomatically generate SQL scripts for DBA code reviewDoes not require a live database connectionStored logic
Liquibase Pros & Cons
Pros of Liquibase
- ✓Great database tool
- ✓Many DBs supported
- ✓Easy setup
- ✓Database independent migration scripts
- ✓Database version controller
- ✓Unique open source tool
- ✓Precondition checking
- ✓Supports NoSQL and Graph DBs
Cons of Liquibase
- ✗Documentation is disorganized
- ✗No vendor specifics in XML format - needs workarounds
Liquibase Alternatives & Comparisons
What are some alternatives to Liquibase?
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
PostgreSQL
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
