Agree. As a prelude we can put the export import through its paces. Would be great to have a volunteer mysql Guinea pig user that we could document a migration.
On 8 Sep 2017 9:27 am, "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-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
