Evan
That's interesting about storing files as BLOB's and the bit about
viruses checking. How do the mechanics of the virus checking work? Are
there any virus checkers that can check while everything's stored in
the db? Sounds interesting.
Cheers Mark
On Monday, August 18, 2003, at 03:24 PM, Evan Schnell wrote:
Erez Efrati wrote:
I am dealing as well with the file upload issue:
2) I could always store those files in the database but then I would
have to access them through an action, is this wise?
Yes.
I'm a strong proponent of storage in a database. Not only is a BLOB
the ultimate quarantine but it saves you the headache of keeping
meta-data and and the file content in synch. Most RDBMs implement
BLOBs as files so there is very little performance hit when you
perform the upload. When users perform the download you will need an
action to 'proxy' the bytes from the database to the response. If you
write good java.io code, set the content type on the response and
return null from the execute method this is pretty straightforward and
fast enough for most applications.
Downloads will be a little slower this way but it's rare for system
requirements to necessitate repeated file download. If _each_ file is
going to be downloaded more than a few hundred times/day you might
want to write it to directory served by your _web_ server.
Don't forget virus protection. If users can upload and download MS
Office documents you will need to virus check them after they are
uploaded but before anyone else can download them.
Regards, Evan.
--
Evan Schnell, Project Lead
nVISIA, Twin Cities "Enterprise Architecture and Construction"
http://www.nvisia.com
7701 France Ave. S, Edina, MN 55435
Voice: 952.837.2577 -- Fax: 952.837.2578
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]