RE: [jug-discussion] storing blobs on file system or in db

2005-03-29 Thread Richard Hightower
Davidson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 4:46 PM To: jug-discussion@tucson-jug.org Subject: Re: [jug-discussion] storing blobs on file system or in db Andrew Huntwork wrote: I'm writing this web app that allows users to upload documents, such as word docs, images, etc

RE: [jug-discussion] storing blobs on file system or in db

2005-03-29 Thread Richard Hightower
blobs on file system or in db Interesting question. You could consider a shared file system. I hesitate recommending that documents be stored in a database. You don't need the transactional capabilities (correct?), and a RDMBS is not really a great blob storage device (yes, they can do it, but I

RE: [jug-discussion] storing blobs on file system or in db

2005-03-29 Thread Richard Hightower
:39 AM To: 'jug-discussion@tucson-jug.org' Subject: RE: [jug-discussion] storing blobs on file system or in db We did both. We stored the file in the DB. Then when the file is retrieved from the db, we write the file to the filesystem. The app would check for the file on the file system first

[jug-discussion] storing blobs on file system or in db

2005-03-16 Thread Andrew Huntwork
I'm writing this web app that allows users to upload documents, such as word docs, images, etc, and then to download those documents again on request. the documents are not searched, interpretted, processed, version controlled, or anything else. just upload and download. i wonder if there's

RE: [jug-discussion] storing blobs on file system or in db

2005-03-16 Thread Landon Clark
. -Original Message- From: Andrew Huntwork [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 3:21 PM To: jug-discussion@tucson-jug.org Subject: [jug-discussion] storing blobs on file system or in db I'm writing this web app that allows users to upload documents, such as word docs

Re: [jug-discussion] storing blobs on file system or in db

2005-03-16 Thread Randolph Kahle
Interesting question. You could consider a shared file system. I hesitate recommending that documents be stored in a database. You don't need the transactional capabilities (correct?), and a RDMBS is not really a great blob storage device (yes, they can do it, but I don't reach for an RDBMS to

Re: [jug-discussion] storing blobs on file system or in db

2005-03-16 Thread Andrew Huntwork
it looks like the clear consensus is file system. that's what 2 of my co-workers said before i asked here, but now i actually basically believe them. I still have my doubts though...if someone has done this the db way and actually seen real scalability problems, i'd love to hear about it.

RE: [jug-discussion] storing blobs on file system or in db

2005-03-16 Thread Landon Clark
-Original Message- From: Andrew Huntwork [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 4:40 PM To: jug-discussion@tucson-jug.org Subject: Re: [jug-discussion] storing blobs on file system or in db it looks like the clear consensus is file system. that's what 2 of my co-workers said

Re: [jug-discussion] storing blobs on file system or in db

2005-03-16 Thread Drew Davidson
Andrew Huntwork wrote: I'm writing this web app that allows users to upload documents, such as word docs, images, etc, and then to download those documents again on request. the documents are not searched, interpretted, processed, version controlled, or anything else. just upload and

Re: [jug-discussion] storing blobs on file system or in db

2005-03-16 Thread Bryan . ONeal
I have, but then again I was using a @!#$!$ MS DBS at the time ;) On Wed, 16 Mar 2005, Andrew Huntwork wrote: it looks like the clear consensus is file system. that's what 2 of my co-workers said before i asked here, but now i actually basically believe them. I still have my doubts

[jug-discussion] storing blobs on file system or in db

2005-03-16 Thread John D. Mitchell
Andrew == Andrew Huntwork [EMAIL PROTECTED] writes: [...] I'm writing this web app that allows users to upload documents, such as word docs, images, etc, and then to download those documents again on request. the documents are not searched, interpretted, processed, version controlled, or

Re: [jug-discussion] storing blobs on file system or in db

2005-03-16 Thread Jeffrey Peacock
Taking into account all the responses I've seen so far (down to J. D. Mitchell) there is relatively little consideration being given to the transactional issues. I suggest that before you settle on a solution where performance is the priority you need to examine the issue of "What is the