Merging database???
Posted: Thu Aug 16, 2007 12:59 am
I HAVE TWO TABLES ARTICLE AND STORY BOTH HAVING DIFFERENT STRUCTURE
However as insisted by experts if i do merge them and make one table then i will have many values as NULL in the db. And secondly i can have another field whose having 1/0 implies it being an article or story.
For example a field has default value 0 in article then i will have to put a default value (wen posted from form) to be NULL as that field will not be applicable to story
Is this type of discrimination and having a lot of db values as null fine?
If i can merge then the search will be easy... I can have a tags field for both articles and stories which will be something like keyword similar to that in FLICKR!
So pls explain should i merge?... Now that i will have only one db...
what abt the site security if i have 2 db or 1 db... i feel having one form sql injected will only affect that db [though the structure is complicated to work with] but other one would be safe is that the case?
However as insisted by experts if i do merge them and make one table then i will have many values as NULL in the db. And secondly i can have another field whose having 1/0 implies it being an article or story.
For example a field has default value 0 in article then i will have to put a default value (wen posted from form) to be NULL as that field will not be applicable to story
Is this type of discrimination and having a lot of db values as null fine?
If i can merge then the search will be easy... I can have a tags field for both articles and stories which will be something like keyword similar to that in FLICKR!
So pls explain should i merge?... Now that i will have only one db...
what abt the site security if i have 2 db or 1 db... i feel having one form sql injected will only affect that db [though the structure is complicated to work with] but other one would be safe is that the case?