← Back to team overview

dhis2-users team mailing list archive

Re: DHIS 2 to support PostgreSQL only?

 

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" <lars@xxxxxxxxx> 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
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References