Hi guys, what’s up? I’ll share with you some things that I’ve been reading lately and I think relevant and worthy to take a look:
- Liquibase is a database version control tool. Supports changesets, branching and merging and also has traceability. It supports the following file formats: XML, JSON, YAML and SQL. Here is an example taken from the official site:
--liquibase formatted sql --changeset nvoxland:1 create table person ( id int not null primary key, firstname varchar(80), lastname varchar(80) not null, state varchar(2) ); --changeset nvoxland:2 alter table person add column username varchar(8) --changeset nvoxland:3 create table state AS SELECT DISTINCT state AS id FROM person WHERE state IS NOT NULL; alter table state modify id char(2) NOT NULL; alter table state add primary key(id); alter table person add constraint fk_person_state foreign key (state) references state(id);
- State of the Study: I intend to use, first to test and use the features. If I like, I want to use whenever I can.
- My Opinion About the Subject: Anything that makes easier database maintenance is valid. Before this, I only used Flyway, but I will test Liquibase.
My Reference Link (BR): https://dicasdolampada.wordpress.com/2012/03/19/evoluindo-o-banco-de-dados-com-o-liquibase/
My Reference Link (EN): https://blog.codecentric.de/en/2015/01/managing-database-migrations-using-liquibase/
Ionic vs React Native