Hi Lars, Make a lot of sense, and would free time in your team to provide more value (seems you are not lacking ideas). I would say go for it, with maybe dedicated documentation about how to move (even if it's basically using the import/export feature "as is", may be worth a couple of hours to write a step by step guide).
Martin On Fri, Sep 8, 2017 at 10:26 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-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- *Martin Van Aken - **Freelance Enthusiast Developer* Mobile : +32 486 899 652 Follow me on Twitter : @martinvanaken <http://twitter.com/martinvanaken> Call me on Skype : vanakenm Hang out with me : mar...@joyouscoding.com Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken Company website : www.joyouscoding.com
_______________________________________________ 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
