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 <mailto: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
