dbTalk Databases Forums  

Single or Multiple Tables?

Go Back dbTalk Databases Forums Databases comp.databases Single or Multiple Tables?

comp.databases comp.databases


Discuss Single or Multiple Tables? in the comp.databases forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
arjuiut@gmail.com
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 04:12 AM





On Aug 13, 8:46 pm, --CELKO-- <jcelko... (AT) earthlink (DOT) net> wrote:
Quote:
From the spec you gave, I would tend to a single table for Resources
qua Resources with dates, sources, descriptions, media type, etc, that
includes a column for the names of the files that contain the actual
images, videos or documents. Then lock or encrypt the files so that
only the Admin can get to them to prevent tampering.

I never liked putting BLOB style data into SQL. It gets too
proprietary, you cannot query it anyway and next week someone invents
a new spiffy media that you cannot handle properly.
http://arjudba.blogspot.com


Reply With Quote
  #12  
Old   
arjuiut@gmail.com
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 04:12 AM





On Aug 13, 8:46 pm, --CELKO-- <jcelko... (AT) earthlink (DOT) net> wrote:
Quote:
From the spec you gave, I would tend to a single table for Resources
qua Resources with dates, sources, descriptions, media type, etc, that
includes a column for the names of the files that contain the actual
images, videos or documents. Then lock or encrypt the files so that
only the Admin can get to them to prevent tampering.

I never liked putting BLOB style data into SQL. It gets too
proprietary, you cannot query it anyway and next week someone invents
a new spiffy media that you cannot handle properly.
http://arjudba.blogspot.com


Reply With Quote
  #13  
Old   
arjuiut@gmail.com
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 04:12 AM


On Aug 13, 8:46 pm, --CELKO-- <jcelko... (AT) earthlink (DOT) net> wrote:
Quote:
From the spec you gave, I would tend to a single table for Resources
qua Resources with dates, sources, descriptions, media type, etc, that
includes a column for the names of the files that contain the actual
images, videos or documents. Then lock or encrypt the files so that
only the Admin can get to them to prevent tampering.

I never liked putting BLOB style data into SQL. It gets too
proprietary, you cannot query it anyway and next week someone invents
a new spiffy media that you cannot handle properly.
http://arjudba.blogspot.com


Reply With Quote
  #14  
Old   
Ian Oxley
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 08:09 AM


Thanks to everyone for their answers. I've now got a much clearer idea
of how to carry this forwards.

Reply With Quote
  #15  
Old   
Ian Oxley
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 08:09 AM


Thanks to everyone for their answers. I've now got a much clearer idea
of how to carry this forwards.

Reply With Quote
  #16  
Old   
Ian Oxley
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 08:09 AM


Thanks to everyone for their answers. I've now got a much clearer idea
of how to carry this forwards.

Reply With Quote
  #17  
Old   
Ed Prochak
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 12:54 PM


On Aug 14, 9:09 am, Ian Oxley <ijox... (AT) googlemail (DOT) com> wrote:
Quote:
Thanks to everyone for their answers. I've now got a much clearer idea
of how to carry this forwards.
And thank you for the feedback. It is good to know our replies are
helpful in some way.
Ed


Reply With Quote
  #18  
Old   
Ed Prochak
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 12:54 PM


On Aug 14, 9:09 am, Ian Oxley <ijox... (AT) googlemail (DOT) com> wrote:
Quote:
Thanks to everyone for their answers. I've now got a much clearer idea
of how to carry this forwards.
And thank you for the feedback. It is good to know our replies are
helpful in some way.
Ed


Reply With Quote
  #19  
Old   
Ed Prochak
 
Posts: n/a

Default Re: Single or Multiple Tables? - 08-14-2008 , 12:54 PM


On Aug 14, 9:09 am, Ian Oxley <ijox... (AT) googlemail (DOT) com> wrote:
Quote:
Thanks to everyone for their answers. I've now got a much clearer idea
of how to carry this forwards.
And thank you for the feedback. It is good to know our replies are
helpful in some way.
Ed


Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top