Public bug reported:
Serialized data is evil! its inefficient and much better to just use a
proper data type IMO. Since we rely so heavily on database and needing
mysql, we should be super clean about ONLY using sql IMO.
I changed on config and borked scale! So, I had to fire up a stupid
commandline client and enter this:
update aiki_config SET
config_data='a:8:{s:4:"site";s:7:"default";s:3:"url";s:24:"http://scalejournal.org/";s:13:"default_chmod";s:4:"0775";s:11:"pretty_urls";s:1:"1";s:16:"default_language";s:7:"english";s:19:"default_time_format";s:9:"d
- m - Y";s:8:"site_dir";s:3:"ltr";s:19:"language_short_name";s:2:"en";}'
WHERE config_id=1 AND config_type='global_settings';
That is insane because I had to hand edit and count the characters of
the string. Databases are used to store data, not have a data structure
inside a storage system.
This is a high necessary fix.
If anything, we should provide easy access to creating proper fields on
the db.
** Affects: aikiframework
Importance: High
Assignee: Bassel Safadi (bassel)
Status: Confirmed
** Affects: openclipart
Importance: High
Status: Confirmed
** Affects: ppl
Importance: High
Status: New
** Affects: scalejournal
Importance: High
Status: Confirmed
** Also affects: openclipart
Importance: Undecided
Status: New
** Also affects: scalejournal
Importance: Undecided
Status: New
** Changed in: openclipart
Status: New => Confirmed
** Changed in: scalejournal
Status: New => Confirmed
** Changed in: openclipart
Importance: Undecided => High
** Changed in: scalejournal
Importance: Undecided => High
** Changed in: openclipart
Milestone: None => 2.9
** Changed in: scalejournal
Milestone: None => 2010.12
** Also affects: ppl
Importance: Undecided
Status: New
** Changed in: ppl
Importance: Undecided => High
** Changed in: ppl
Milestone: None => 0.2
--
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/689904
Title:
replace serialized data in aiki configs
Status in Aiki Framework:
Confirmed
Status in openclipart:
Confirmed
Status in PPL:
New
Status in Scale Journal:
Confirmed
Bug description:
Serialized data is evil! its inefficient and much better to just use a proper
data type IMO. Since we rely so heavily on database and needing mysql, we
should be super clean about ONLY using sql IMO.
I changed on config and borked scale! So, I had to fire up a stupid commandline
client and enter this:
update aiki_config SET
config_data='a:8:{s:4:"site";s:7:"default";s:3:"url";s:24:"http://scalejournal.org/";s:13:"default_chmod";s:4:"0775";s:11:"pretty_urls";s:1:"1";s:16:"default_language";s:7:"english";s:19:"default_time_format";s:9:"d
- m - Y";s:8:"site_dir";s:3:"ltr";s:19:"language_short_name";s:2:"en";}' WHERE
config_id=1 AND config_type='global_settings';
That is insane because I had to hand edit and count the characters of the
string. Databases are used to store data, not have a data structure inside a
storage system.
This is a high necessary fix.
If anything, we should provide easy access to creating proper fields on the db.
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
