Why systemsettings as BLOB??

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 !

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 !

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