|P is for Practical|
mapping complex structures to mysql tablesby niubi (Initiate)
|on May 08, 2013 at 18:09 UTC||Need Help??|
niubi has asked for the
wisdom of the Perl Monks concerning the following question:
I have a big perl website that has lots of configuration settings that are stored in lots of variables in a perl module (most of them are stored in several hash of hashes).
My boss wants to move all this configuration settings to a mysql database, the problem is that doing all this by hand is difficult and not recommended, as new settings are added/modified frequently (and also duplicated when a new section is added to the website).
I've suggested my boss to use XML, YAML or just plain Storable module to save all this settings to a text file, but he refuses these options, he doesn't want text files and want to store all these variables in MySQL.
My question is: is there anything (cpan module, etc) I can use to map these complex structures into MySQL tables and viceversa? (the most important goal for me is to easily read all the data from the tables to initialise all the settings variables I have)
Any help will be really appreciated. Thanks!