Thanks all for the feedback on this issue! regards,
Lars On Fri, Sep 8, 2017 at 1:19 PM, Hannan Khan <hann...@gmail.com> 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 <l...@dhis2.org> > 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 >> 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 >> >> > > > -- > 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 hann...@gmail.com > 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 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