← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

 

Thanks all for the feedback on this issue!

regards,

Lars


On Fri, Sep 8, 2017 at 1:19 PM, Hannan Khan <hannank@xxxxxxxxx> wrote:

> Hi Lars
>
> Fully agreed. To concentrate one one DB platforms will not only saves time
> and effort, also being efficiency to the system and can make more use of
> advance functionality of the PostgreSQL & PostGIS.
>
> You will have our full support.
>
> Hannan
>
> On Fri, Sep 8, 2017 at 2:26 PM, Lars Helge Øverland <lars@xxxxxxxxx>
> wrote:
>
>> Hi all,
>>
>> I want to bring up the idea of solely support PostgreSQL for DHIS 2 for
>> production use to get feedback from the community.
>>
>> The DHIS 2 team is seeing clear benefits of moving to PostgreSQL-only.
>> The main ones are:
>>
>> 1. Supporting and testing for more than one database platform is
>> time-consuming. The majority of DHIS 2 implementations is using PostgreSQL
>> already.
>>
>> 2. PostgreSQL supports advanced geospatial features through PostGIS. We
>> are already depending on these for the GIS module to work optimally (i.e.
>> for event clustering in GIS). There are no direct equivalent in e.g. MySQL.
>> We are also considering using PostGIS data types in main data model.
>>
>> 3. PostgreSQL will provide some impressive features which will become
>> very useful for us in version 10
>> <https://wiki.postgresql.org/wiki/New_in_postgres_10> and 11. E.g.
>> native partitioning, parallel queries, logical replication, foreign tables
>> and improved query performance will be useful and allow us to develop the
>> next DHIS 2 analytics solution.
>>
>>
>> We are aware this will be inconvenient for users of other databases such
>> as MySQL, but there is the option of migrating your database through the
>> DHIS 2 metadata and data value import-export feature.
>>
>> On a technical note, we will keep the Hibernate development framework and
>> keep supporting the H2 database for unit testing purposes.
>>
>> Please let us know your thoughts on this.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> lars@xxxxxxxxx
>> http://www.dhis2.org <https://www.dhis2.org/>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Muhammad Abdul Hannan Khan
> Team Leader
> Support to the National HMIS
> MIS, Director General of Health Service
> Ministry of Health and Family Welfare
>
> T +880-2- 58816459 <+880%202-58816459>, 58816412 ext 118
> <58%2081%2064%2012>
> F +88 02 58813 875
> M+88 01819 239 241
> M+88 01534 312 066
> E hannank@xxxxxxxxx
> S hannan.khan.dhaka
> B hannan-tech.blogspot.com
> L https://bd.linkedin.com/in/hannankhan
>
>
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>

References