← Back to team overview

dhis2-users team mailing list archive

Re: DHIS 2 to support PostgreSQL only?

 

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


-- 
*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 : martin@xxxxxxxxxxxxxxxx
Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken
Company website : www.joyouscoding.com

References