: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 fi
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 c
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,
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 cor
> "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 contr
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
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 download.
-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
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.
Tha
>if there's a general rule on whether one should stick
> such things into a db or onto the file system.
Where to stick uploads always tends to spark debate from both sides. (I
see there are already a bunch of replies. ;-)
Personally, the debaute leaves me thinking that either [religion] has
it's
Yes, I agree also with metadata in the db. Good point.
Randy
On Mar 16, 2005, at 3:28 PM, [EMAIL PROTECTED] wrote:
I personally prefer to put the file on the FS and place the link (file
location) into the DB. As for clustering problems, have you looked
into
cluster file systems like AFS?
On Wed,
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
btw, the application uses a database for a lot of other things anyway,
and i'll definitely be storing at least metadata for the documents in
the db.
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
I personally prefer to put the file on the FS and place the link (file
location) into the DB. As for clustering problems, have you looked into
cluster file systems like AFS?
On Wed, 16 Mar 2005, Andrew Huntwork wrote:
> I'm writing this web app that allows users to upload documents, such as
> w
s say.
-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
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
16 matches
Mail list logo
