Use ini/appconfig file or sql server file to store user config?
- by h2g2java
I know that the preference for INI or appconfig XML is their human readability.
Let's say user preferences stored for my app are hierarchical and numbers about a thousand items and it would be really confusing for a user to edit an INI to change things anyway.
I have always been using a combination of INI with appconfig.
I am leaning towards using sql server db file, now. Every time the user changes a preference while using the app, it would be stored into the db file - that's my line of thought. I am also thinking that such a config db file could move around with the app too, just like an INI.
Before I do that, any advice
1. If there are any disadvantages against using a db file over INI or appconfig.
2. If a shop uses mysql or oracle, do you think your colleagues would lift up their pro-mysql or pro-oracle eyebrow questioning why you would use sql server technology in a mysql or oracle shop? I mean, I am just using it like an INI file or app.config anyway, right?