dhis2-devs team mailing list archive

[sunbiz@xxxxxxxxx]

Openmrs started using liquibase because these database scripts were taken from mysqldump and could not b used with other dbms many times. Liquibase makes it kind of database independent.

Don't get me wrong I really love liquibase, but it also adds some xml overhead and small but learning curve.

The way I see openmrs and dhis different is that the dhis model is made by the user and its ui driven. Most of the basics are very much stable. Openmrs on the other hand is changing its model and not user, but developer driven. These reasons made me ask question if others feel the need to have liquibase for database chnages


Sent from my BlackBerry®

-----Original Message-----
From: Ola Hodne Titlestad <olatitle@xxxxxxxxx>
Date: Tue, 29 Sep 2009 13:22:23 
To: <sunbiz@xxxxxxxxx>
Cc: Bob Jolliffe<bobjolliffe@xxxxxxxxx>; DHIS 2 developers<dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-devs] Use liquibase to deal with database changes and 
	tosimplify DHIS update process?

2009/9/29 <sunbiz@xxxxxxxxx>

> I had tutored one student nishtha who was learning java to implement these
> beautiful looking setup screens of openmrs.
>
> So I know its quite simple to inplement and applying updates works quite
> out of the box in liquibase. Though I don't fully understand why we want to
> use it in dhis.
>
>
Hi Saptarshi,

The main reason as I see it will be to avoid manual sql update scripts on
all existing installations every time there is a change to the database that
Hibernate cannot take care of. That happened quite often in the past, and
still happens from time to time, although not as often as before as the data
model has stabilised. If liquibase can track all changes to the data model
("master database") and make sure the local database gets updated when
loading a new war file that would be a great simplification of the update
process I think. And my understanding is that it is used in openmrs for
exactly the same reason. Why do you see DHIS as different from OpenMRS when
it comes to using liquibase?

Ola
---------



>
> -----Original Message-----
> From: Bob Jolliffe <bobjolliffe@xxxxxxxxx>
> Date: Tue, 29 Sep 2009 11:54:08
> To: Ola Hodne Titlestad<olatitle@xxxxxxxxx>
> Cc: DHIS 2 developers<dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Subject: Re: [Dhis2-devs] Use liquibase to deal with database changes and
> to
>        simplify DHIS update process?
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>