dhis2-users team mailing list archive

["Smith, Rebecca A." <rs3524@xxxxxxxxxxxxxxxxx>]

Thanks Iuri and Lars! This is very helpful.

-----Original Message-----
From: Iuri Fanti [mailto:iuri.fanti@xxxxxxxxx] 
Sent: Wednesday, December 02, 2015 12:24 PM
To: Lars Helge Øverland
Cc: Smith, Rebecca A.; dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] MySQL for DHIS

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
@-`-,--