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
create table person (
id int not null primary key,
lastname varchar(80) not null,
alter table person add column username varchar(8)
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