Hello.
Design your database first, following good old fashioned normalisation techniques. The process of drawing out the structure and refining it will aid you in creating new fields and extending the structure, as well as improving your understanding of what you're trying to acheive.
Following correct normalisation techniques will allow you to extend the structure without causing impact on the rest of the structure.
It can be a drag, of course, but having a clearly defined and extensible structure before you even begin coding will put a step closer towards succeeding with what you're trying to do.
Don't worry about the how to begin with, the actual db used should be a secondary consideration in many respects. Just draw out what you want to do on paper, then refine refine refine. You will have a much better idea of what you're trying to acheive when you finally get around to coding and won't be surprised by anything that people might throw at you.
Goodbye.
Design your database first, following good old fashioned normalisation techniques. The process of drawing out the structure and refining it will aid you in creating new fields and extending the structure, as well as improving your understanding of what you're trying to acheive.
Following correct normalisation techniques will allow you to extend the structure without causing impact on the rest of the structure.
It can be a drag, of course, but having a clearly defined and extensible structure before you even begin coding will put a step closer towards succeeding with what you're trying to do.
Don't worry about the how to begin with, the actual db used should be a secondary consideration in many respects. Just draw out what you want to do on paper, then refine refine refine. You will have a much better idea of what you're trying to acheive when you finally get around to coding and won't be surprised by anything that people might throw at you.
Goodbye.