sunbiz
(Saptarshi Purkayastha)
31 March 2010 13:29
1
I was looking at the systemsettings… and found that the value is stored as a BLOB. I was greatly surprised to see this… Any good reason to do this??
···
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Dear Saptarshi,
Do you mind if you can explain to me about BLOB value? What’s BLOB here?
Really thanks !
···
On Wed, Mar 31, 2010 at 8:29 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:
I was looking at the systemsettings… and found that the value is stored as a BLOB. I was greatly surprised to see this… Any good reason to do this??
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Hieu.HISPVietnam
Good Health !
sunbiz
(Saptarshi Purkayastha)
31 March 2010 18:33
3
Hi,
If you check the systemsetting table… the datatype for the value column is BLOB
A MySQL explanation is here: http://dev.mysql.com/doc/refman/5.0/en/blob.html
Using string key, string value seems like the standard way to store properties. Wanted to know if its been well thought-out to use BLOB here
···
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
On 31 March 2010 19:56, Hieu Dang Duy hieu.hispvietnam@gmail.com wrote:
Dear Saptarshi,
Do you mind if you can explain to me about BLOB value? What’s BLOB here?
Really thanks !
On Wed, Mar 31, 2010 at 8:29 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:
I was looking at the systemsettings… and found that the value is stored as a BLOB. I was greatly surprised to see this… Any good reason to do this??
Regards,
Saptarshi PURKAYASTHA
Director R & D, HISP India
Health Information Systems Programme
My Tech Blog: http://sunnytalkstech.blogspot.com
You Live by CHOICE, Not by CHANCE
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Hieu.HISPVietnam
Good Health !
Lars
(Lars Øverland)
3 April 2010 08:56
4
At the time we found it useful to be able to store complex objects and not only strings. Today I think we only use strings anyway so I guess we could change it. Except all current settings in the field will be lost…
Lars