better to store in DB, config files should be a backup option...even with status.net, moved all configs in the db, but config file is a backup...
thanks for opinion nicky! On Mon, Dec 13, 2010 at 2:34 PM, nickybourque <689...@bugs.launchpad.net>wrote: > I suppose it depends. There are a handful of instances where it is > advantageous to store datastructures as blobs, but I don't think that > PHP has something like Perl's Storable. Regardless, it's very resource > intensive, and not a very good way to go in all but that limited set > of cases. > > Why not just store config data in files? > > > > > On Mon, Dec 13, 2010 at 2:20 PM, rejon <j...@rejon.org> wrote: > > more info about data serialization, which is basically a complete hack > > of a way to add non-thinking to database design: > > > > http://php.net/manual/en/function.serialize.php > > > > -- > > You received this bug notification because you are a member of Aiki > > Framework Developers, 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. > > > > > > > > -- > You received this bug notification because you are a direct subscriber > of the bug. > https://bugs.launchpad.net/bugs/689904 > > Title: > replace serialized data in aiki configs > -- Jon Phillips http://rejon.org/ http://fabricatorz.com/ chat/skype: kidproto | irc: rejon +1.415.830.3884 (sf/global) +86.187.1003.9974 (china) +65.8330.5807 (singapore) -- 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 : aikiframework.admins@lists.launchpad.net Unsubscribe : https://launchpad.net/~aikiframework.admins More help : https://help.launchpad.net/ListHelp
