dhis2-users team mailing list archive

[JM Alcantara <jmalcantara1@xxxxxxxxx>]

Hello Lars
I hope you are well.
I fully agree with your assessment and the benefits are clear.
Best regards,
JM

> El 08/09/2017, a las 10:26, Lars Helge Øverland <lars@xxxxxxxxx> escribió:
> 
> 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 <mailto: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