← Back to team overview

dhis2-devs team mailing list archive

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

 

Hi Lars,
I think like the DHIS2 is a system that needs to be deployed on a large
scale, the choice to keep postgresql is ideal. In its recent version
Postgresql becomes more flexible when there is a lot of data. It becomes
very close to Oracle. the possibility of using the Json and its highly
developed GIS module is a major asset. I'm ok to keep Postgresql as DHIS2
DBMS.

Cheers,

2017-09-08 10:02 GMT+01:00 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
> 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
>
>
>
> _______________________________________________
> 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
>
>


-- 
Riddy NDOMA
"Codeur nocturne"
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/
*Vous servir est mon désire (Serving you is my desire)*

References