after gathering feedback from the community we have decided to support PostgreSQL only as database platform for DHIS 2 starting from version 2.29 (i.e. the next release).
This will allow us to utilize some of the sophisticated features specific to PostgreSQL in order to make a better system. As example, this will help us to improve the analytics and data import/export functionality.
The minimum version required will be PostgreSQL version 9.0. We do however recommend migrating to PostgreSQL 10 as it provides performance improvements and new features which may be utilized in near-future DHIS 2 releases.
Good decision. I assume this means H2 will also no longer be a fallback? So dhis2 live will also require PG?
Knut
···
On Nov 9, 2017 3:32 PM, “Lars Helge Øverland” lars@dhis2.org wrote:
Hi all,
after gathering feedback from the community we have decided to support PostgreSQL only as database platform for DHIS 2 starting from version 2.29 (i.e. the next release).
This will allow us to utilize some of the sophisticated features specific to PostgreSQL in order to make a better system. As example, this will help us to improve the analytics and data import/export functionality.
The minimum version required will be PostgreSQL version 9.0. We do however recommend migrating to PostgreSQL 10 as it provides performance improvements and new features which may be utilized in near-future DHIS 2 releases.
We will continue to use H2 for internal purposes (unit testing) for a
while, and the system will still start and mostly work on H2. However there
will gradually be more features requiring PostgreSQL, and we hope to
replace Live with a Docker image in near future.
As part of the move to PostgreSQL we will also require the PostGIS
extension.
Lars
···
On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <knutst@gmail.com> wrote:
Good decision. I assume this means H2 will also no longer be a fallback?
So dhis2 live will also require PG?
Very good Lars! Looking at the move to postgresql 10 (presumably one
or two more versions down the line), have you been considering the
native partitioning support for dealing with huge datavalue tables?
This looks like it might be very suited to our classic problem of
large amounts of historic data..
···
On 9 November 2017 at 20:47, Lars Helge Øverland <lars@dhis2.org> wrote:
On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <knutst@gmail.com> wrote:
Good decision. I assume this means H2 will also no longer be a fallback?
So dhis2 live will also require PG?
We will continue to use H2 for internal purposes (unit testing) for a while,
and the system will still start and mostly work on H2. However there will
gradually be more features requiring PostgreSQL, and we hope to replace Live
with a Docker image in near future.
As part of the move to PostgreSQL we will also require the PostGIS
extension.
Lars
--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@dhis2.org http://www.dhis2.org