Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Here's the deal, I'm in charge of creating a website that will host small web apps. This apps will be photo contests, creatives sentences and other similar gibberish. The deal is, since apps we'll be constantly changing and some new ones will come up what's the best way to save the config specs for each one? Should I create new tables and fields as I need? Or should I serialize this data and put it on one field?

In this case instead of having a table apps, I was thinking having a table for each app, this way I could have a more modular way of dealing with apps, making changes more easy, or more painfull (in case of the changes apply to all the apps)

Or if I serialize everthing, then I would only have one table and I won't have the need to make changes to the table, but this option seems a bit lame to me.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Ever heard of the windows registry? Put something like thta into your databae. A hierarchy of folders for key/value pairs. Simple to do with some changes. Do NOT serialize anything more complex than primitive types - that will come back to haunt you - or hand crafted XML structures (i.e. classes that output XML that is cleear to read).

share|improve this answer

The questions to answer: - Are the applications related to each other, or to a common user? - Do the applications share data between each other? - Are there any common data and functions that are common to all?

If the answer to any of the question above is yes, then probably one application per table may not be the best approach since there will be lots of duplication that can be resolved in a more detailed design

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.