Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

[Lars Helge Øverland]

Thanks all for the feedback on this issue!

regards,

Lars


On Fri, Sep 8, 2017 at 1:19 PM, Hannan Khan  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 
> 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
>>  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 
>>
>>
>> ___
>> 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 
___
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

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

[Hannan Khan]

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  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
>  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 
>
>
> ___
> 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, 58816412 ext 118
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
___
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

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

[Bob Jolliffe]

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

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

[riddy ndoma]

Hi Lars,
I think like the DHIS2 is a system that needs to be deployed on a large
scale, the choice to keep postgresql is ideal. In its recent version
Postgresql becomes more flexible when there is a lot of data. It becomes
very close to Oracle. the possibility of using the Json and its highly
developed GIS module is a major asset. I'm ok to keep Postgresql as DHIS2
DBMS.

Cheers,

2017-09-08 10:02 GMT+01:00 JM Alcantara :

> Hello Lars
> I hope you are well.
> I fully agree with your assessment and the benefits are clear.
> Best regards,
> JM
>
> El 08/09/2017, a las 10:26, Lars Helge Øverland  escribió:
>
> 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
>  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 
>
> ___
> 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
>
>
>
> ___
> 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
>
>


-- 
Riddy NDOMA
"Codeur nocturne"
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/
*Vous servir est mon désire (Serving you is my desire)*
___
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

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

[JM Alcantara]

Hello Lars
I hope you are well.
I fully agree with your assessment and the benefits are clear.
Best regards,
JM

> El 08/09/2017, a las 10:26, Lars Helge Øverland  escribió:
> 
> 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 
>  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 
> 
> ___
> 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

___
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

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

[Antonia - Pro]

Hi Lars and community,
Even though we use MySQL and other DBMS for other projects, I think it's
best for DHIS2 to use and explicitly specify in the documentation that the
only supported DBMS is PostgreSQL.
At the beginning of our project we lost a lot of time testing DHIS 2 with
MySQL, only to discover that some of the problems we had were related to
the use of MySQL, which then resolved, starting to use PostgreSQL.
In my opinion, it is better to support a single DBMS that is well tested
and has all the necessary features (GIS etc.).

Regards,

Antonia


*Eng. Antonia Bezenchek*
CIO - ICT Engineer
*InformaPRO S.r.l.* via Guido Guinizelli, 98/100, Roma 00152, Italy
tel. +39 06 5882352 / +39 06 5502218, fax +39  06 62207168
cell. +39 366 4049561, P.IVA IT08095781004
www.informapro.it - *Follow us on* LinkedIn


2017-09-08 10:26 GMT+02:00 Lars Helge Øverland :

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

Re: [Dhis2-users] DHIS 2 to support PostgreSQL only?

[Martin Van Aken]

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

[Dhis2-users] DHIS 2 to support PostgreSQL only?

[Lars Helge Øverland]

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