Re: BLOB & JPEG images

Shannon R. Madsen (madsen_at_cs.umn.edu) wrote:
: Harshad Bahirsheth <harshad1_at_ix.netcom.com> writes:
 

: >What are the pros and cons of each case? I imagine this sort of thing is
: >done very commonly. Any comments would be greatly appreciated.
 

: In the systems we've been developing, we store a pathname in the
: database and the actual image data out in a file somewhere. This is
: useful since we're using this as part of a web application which needs
: to be able to convert images. It's more convenient to leave them in
: regular files, plus it keeps the size of our database down.
In our systems, we solve this problem by storing our images (100K-1M) in LONG RAW. Our interfaces are based on Forms 4.5 and Web-techs. At our Unix side, we made CGI which convert original TIFF to MIME-sd GIF. And we find very interesting thing - forms 4.5 can understand our TIFF and shows it as for oracle internal "picture" format.

: If, however, you wanted to move data around between separate
: databases, it might be better to store your image data as a BLOB.
 

: -Shannon
 

: --
: Shannon Robert Madsen madsen_at_cs.umn.edu
: =============================================================================
: http://www.cs.umn.edu/~madsen | "ad astra per aspera"
: =============================================================================
: GAT d(-) s+:- a21 C+++$ USBAILXH++++$ P+++$ L+ E+ W+++$ N+++$ o? K++
: w---$ O? M++$ V-- !PS !PE Y PGP+ t+++ 5++ X++ R- tv b++ DI++++ D+ !G e
: h++(-)* r%* y+

--
Evgeny N. Faddeenkov <fancy_at_cnit.nsu.ru>	+7-(383-2)-39-78-95 (ph)
		http://www.cnit.nsu.ru/~fancy/	+7-(383-2)-39-73-54 (fax)
		Novosibirsk State University