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 <jmalcanta...@gmail.com>: > 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 <l...@dhis2.org> 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 > l...@dhis2.org > http://www.dhis2.org <https://www.dhis2.org/> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > 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)*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
