Re: Picture with Postgres and Delphi

I'd actually like to get some comments on this too because for compatibility and
throughput issues, I would think that storing the file path in the database
instead of the actually file would be "better". I've done one application like
this in the past that very worked well. I'm getting ready to do the final
e-commerce integration on a new site and if there is an advantage to storing the
files in the database (in this case about 300 jpeg images for a t-shirt site)
I'll try that out. I'll have to research that base64 encoding part because I'll
only every do text dumps.

Keith-

Quoting Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>:

> --- Jonathan Bartlett <johnnyb(at)eskimo(dot)com> wrote:
> > I'm a big fan of bytea. In every case where I've
> > done the filesystem
> > method I wished I hadn't.
>
> For the education of me and maybe others too, why was
> that? i.e. what problems did you run into, that bytea avoids?
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com