Re^2: mapping complex structures to mysql tables

Sorry, I can't provide any real life details about the data (I have signed a very tight NDA and the company I work for is very picky about that), but I can assure you that this configuration variables are needed and can't be simplified. Also, this settings define how a specific part of the website works and the number and types of settings vary dynamically, and each section could have different settings, that's why hardcoding is out of the question

Currently, the site currently works as yout suggested solution (I have defined a class that sets all this configuration variables) but my boss wants the possibility that anyone can access and edit the settings without the need to know and/or modify any piece of perl code and he wants that information to be in MySQL.

Comment on Re^2: mapping complex structures to mysql tables

Replies are listed 'Best First'.
Re^3: mapping complex structures to mysql tables by GrandFather (Saint) on May 09, 2013 at 11:44 UTC
The significant part of my "solution" was: store the configuration in existing relevant tables, or should add configuration tables specific to the site area as required so if "the site currently works as yout suggested solution" then you have no problem. If "boss wants the possibility that anyone can access and edit the settings" that implies to me that you need to add some sort of administrative access configuration panel to your site. Allowing configuration by direct access to raw configuration data is a recipe for major disaster! True laziness is hard work	[reply]
Re^4: mapping complex structures to mysql tables by niubi (Initiate) on May 09, 2013 at 16:37 UTC
I certainly know the implications of allowing people access to editing settings (like the one you mention), but that is irrelevant to the problem I want to solve (that is, store complex data structures in MySQL in a way that is easy to edit the settings stored), that's why I haven't mentioned those issues. I also know that this solution is not optimal (I already discussed this several times with my boss), but it is THE solution my boss wants and he is the one that pays me, so I do what he says :)	[reply]