|
|
Posted by sTony on 11/10/06 09:42
"Steve" <no.one@example.com> wrote in message
news:M6R4h.115$MX1.87@newsfe03.lga...
> | I had a thought, which can be dangerous, haha. Is is possible to store
> each
> | table definition in it's own file, and then simply have one file that
> | references all of the others? Like includes in other languages? If this
is
> | possible, it would have many advantages for me and my website. Anyone?
>
> look...is there *any* reason anyone would care about your db setup files
but
> you or an administrator? do not comment a bunch of crap in your db setup
> files. you should have actual DOCUMENTATION that lays out the table design
> of every table and also describes the relationships they possibly have to
> one another. further, you should have that documentation describe the
> overall strategy of the purpose of what you're storing and how your
> structure supports that end. anything else is less than adequate...and
> trying to do ANY of this directly in your db setup is utterly a misgiving.
> that is, unless this site is solely for your own amusement.
>
> hth,
>
> me
>
>
Thanks for the input, and although it is well received, I must point out
that the website I'm building is meant to be polymorphic, and it is being
designed to grow in unforseen directions. In order to accomodate this
growth, there does needs to be solid documentation, so as to cut down on
design errors, which there will also undoubtably be, and also to promote
understanding of what the table is, and what its reason for being is. The
reason for the seperation of the files is so that people can edit/add the
tables needed for the websites expansion and improvement, without having to
sort through or understand all of the tables of the website. Knowing this,
do you still think its a mistake to put the comments in the database
definition files? I really want your opinion. The database aspects are
giving me more troubles than anything else. It just seems so foreign to me
still, and I expect that a guru could easily find more than one problem with
my databases structure. Anyhow, I appreciate the advice, and I'm eager for
more.
Thanks,
sTony.
Navigation:
[Reply to this message]
|