Should I be using XML to store configuration values in a database?


Theo
25/12/2015 9:47 am
HOME ยป Programming Languages

There are a couple of answers on SE comparing single-row table vs. name-value-pair table used for config settings, but I haven't seen anyone arguing for using XML (or JSON) as a name-value pair model.

Option A

UserID     AppID     ParamID    Value
1          1         10         5.40
1          1         11         John Smith
2          1         10         4.40
2          1         11         Jane Smith

Option B

UserID     AppID     Settings
1          1        
<params><param><ID>10</ID><value>5.40</value></param><param><ID>11</ID><value>John
Smith</value></param></params>
2          1        
<params><param><ID>10</ID><value>4.40</value></param><param><ID>11</ID><value>Jane
Smith</value></param></params>

Option A is plain key-value pair solution, and Option B uses only one serialized XML settings per user/app.

Is there any value in using XML instead of a plain key-value pair?


Related to : Should I be using XML to store configuration values in a database?
Should I be using XML to store configuration values in a database?
25/12/2015 9:47 am by Theo in Programming Languages

There are a couple of answers on SE comparing single-row table vs. name-value-pair table used for config settings, but I haven't seen anyone arguing for using XML (or JSON) as a name-value pair model.

Option A

UserID     AppID     ParamID    Value
1          1         10
Which approach would be better for persisting these overridable configuration keys and values? A simple key-value store, or a graph database?
30/11/2014 1:05 am by ivoidwarranties in Programming Languages

I'm creating a system where there are config keys and values. So for example:

config.key = 10

Is an example of a configuration key and a value. These keys can also have overrides based on "dimensions". So for example, if we wanted to apply config.key


Best way to store the configuration values/settings in Windows Phone 8
by digiram in Programming Languages

Since there is no default configuration file In a WP8 app, what is the best way to store the configuration values, e.g. WCF service URL, User Name and Password. I want these values to be available and updatable when phone restarts and app is closed.


Thanks in advance.


Why store lookup values (combobox values) in the database instead of having them on the html page?
by Guilherme Costa in Programming Languages

What are the typical arguments in support of storing combo-box values (static lookup values (strings etc.) for an application) in database vs storing them right into the html page itself ?


is it better to store platform configuration in database or a file?
by rcpratt in Programming Languages

currently we are developing an app in which we use database table to store platform settings, like maximum file size, maximum users number, support email, etc.


it means that each time we add a platform setting we have to add a column to this table.


in my previous projects


Configuration values in a relational database?
by Andrew Forbes in Programming Languages

Lets suppose I'm building a web application and wonder where to store configuration values (e.g. key-value pairs). It is expected that those pairs will be looked up by keys.


What are the advantages and disadvantages of storing those values in a relational database in comparison to sto


What are the pros and cons for using a database to store configuration information compared to a File System
by Jouni in Programming Languages

Suppose you are tasked with writing a web application that must store configuration information in some format. What are the benefits and drawbacks for storing these configuration information in a relational database compared to storing the information in a file? Configuration options may include


How to keep values in sync between an XML configuration file and a database table?
by Jerome in Programming Languages

I'm structuring in a hierarchical way in levels. By example.


Category 7
Objective 7.1 [GeneralExpectation=']
A [Expectation=']
B [Expectation=']
C [Expectation=']
Objective 7.2 [GeneralExpectation=']
A [Ex
How to Store the values in database
by yhelothar in Programming Languages
Hi to all,
I'm new to the android. How to store the values in database from the text box.Any one Can you help me...........

Store RGB values in database
by JustinDSN in Programming Languages

I never had to do this before and never even thought about this before. How can i or what is the best way of storing RGB values in the database.


I thought of couple of options. The most obvious one being 3 byte columns to store the R,G and the B.(I dont want to go this route)
Ano


Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2014 © bighow.org All Rights Reserved .