![]() While stacking it against existing CLI tools like Liquibase / Flyway, it has the advantage of employing a modern programming language (Go instead of Java), and learnings from tools like Terraform and Prisma. They even debuted as Terraform for Database Migrations on Hacker News:Īltas current focus is on CLI. It's also heavily influenced by HashiCorp Terraform, using Go and inventing its own DSL.Originally, it chooses the same state-based approach as Prisma, but looks like it also added the migration-based approach. It resembles Prisma in that it designs its own Domain Specific Language (DSL) to define the database schema.It resembles Liquibase / Flyway / Sqitch in that it's mainly CLI focused, though it also has a lightweight UI to visualize the schema.The Starlets AtlasĪtlas is a new database schema migration tool that debuted recently. Sqitch also provides the unique tag and bundle command for the schema change deployment, which grants teams more power to wire the schema deployment into the application development lifecycle. If you later want to apply another migration depending on appschema, you need to supply with -requires: In the below example, you need to name the schema migration as appschema: Both Liquibase and Flyway use the file naming convention to control the schema migration behavior (convention over configuration): Sqitch has its own design philosophy about how to manage database schema changes. Unlike Java-based Liquibase/Flyway, Sqitch is developed in Perl.Ĭhoosing Perl is not the only interesting aspect. Sqitch is also an open source project been on the market for a while. Liquibase caters to enterprise customers, while Flyway feels more accessible to the developers. The major difference lies in their respective positioning. Yet Flyway shows a classic example that content matters more than cosmetic beauty and its documentation stands out because of the clarity. You can even spot some basic UI spacing issues. Flyway carries a more casual branding tone:įlyway website is not as shining as those new DevTools companies using sophisticated gradients. The branding may cause some confusion, while it also sets a boundary between the open source and commercial offering. The commercial entity behind Flyway is Redgate through an acquisition. Flyway also recently announced a web portal named Hub. Its core product includes the CLI and a Java library. It's an open source project with a long history and a large customer base. Recently, Liquibase introduced HUB, it's an information portal for paid customers to view, organize and monitor database change activity in real-time.įlyway resembles Liquibase in many ways. It records the incremental change instead of the desired end state of the target database schema. Plain SQL is also supported with proper annotation: Probably due to its age and root in Java, the most commonly used form is XML (YAML and JSON support have been added later): In Liquibase, a schema migration unit is encapsulated in a Change Set. Applications usually embed Liquibase library to apply any applicable schema migration on startup. For the Java application, Liquibase can also be used as a library. Via the CLI, developer teams can integrate the database schema migration into their CI/CD workflow. Liquibase main product is a Java-based CLI. ![]() The company used to be called Datical, and was renamed Liquibase to consolidate the branding (wise move). Liquibase is both an open source project as well as a company providing its commercial offering. When someone asks for database schema change advice on a forum, oftentimes, you will see a reply mentioning Liquibase. Started in 2006, Liquibase is arguably the most well-known product in this segment. In this blog, we will review the state-of-the-art in the Database as Code landscape and share our own insight into the current and future trends in this space. Several innovative products have also emerged to challenge the incumbents. At the same time, we are observing an accelerated trend of embracing Database as Code (DaC) across the industry. Many engineering teams have employed Liquibase / Flyway to adopt this practice. ![]() The idea of codifying database schema changes (aka schema migration) is not new.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |