dhis2-users team mailing list archive

[Iuri Fanti <iuri.fanti@xxxxxxxxx>]

Hi,

we tried to use MySQL, but it didn't work when we had to use
OptionsSet values in DataElements for single events without
registration. The OptionSet resulted empty, evidently because of some
problem fetching data from MySQL.

Iuri

2015-12-02 17:14 GMT+01:00 Lars Helge Øverland <larshelge@xxxxxxxxx>:
> Hi Rebecca,
>
> in order to use MySQL there is nothing else you need to do (beyond changing
> the database connection config properties like you say).
>
> Now MySQL is far less tested with DHIS 2 compared to Postgres so you are
> more likely to come across bugs and upgrade issues on MySQL.
>
> There is also a fair chance that we will create Postgres-only features at
> some point in the future (as an example, using features from the PostGIS
> spatial data extension).
>
> So MySQL works, but Postgres would be preferred.
>
>
> best regards,
>
> Lars
>
>
>
> On Wed, Dec 2, 2015 at 4:29 PM, Smith, Rebecca A. <rs3524@xxxxxxxxxxxxxxxxx>
> wrote:
>>
>> Hi all,
>>
>>
>>
>> We have a partner who would strongly prefer to use MySQL instead of
>> Postgres as the DHIS 2.21 database. The DHIS documentation notes that MySQL
>> can be used but doesn’t give much detail beyond the connection strings.
>>
>>
>>
>> Does anyone in this group have experience with using MySQL for DHIS? Has
>> it been reliable? Do you have to do any manual configuration that you
>> wouldn’t do with Postgres?
>>
>>
>>
>> Thanks,
>>
>> Becky
>>
>>
>>
>>
>>
>> Becky Smith
>>
>> Development-Operations Specialist
>>
>> ICAP at Columbia University
>>
>> Tel: 212.304.7115
>>
>> Email: rs3524@xxxxxxxxxxxxxxxxx
>>
>>
>>
>>
>> _______________________________________________
>> 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
>>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://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
>



-- 
"The best argument against democracy is a five-minute conversation
with the average voter." - Winston Churchill
@-`-,--