Re: Picture with Postgres and Delphi - Mailing list pgsql-general

From Network Administrator
Subject Re: Picture with Postgres and Delphi
Date
Msg-id 1063210245.3f5f4d057b7e7@webmail.vcsn.com
Whole thread Raw
In response to Picture with Postgres and Delphi  ("Edwin Quijada" <listas_quijada@hotmail.com>)
Responses Re: Picture with Postgres and Delphi  (Dennis Gearon <gearond@fireserve.net>)
Re: Picture with Postgres and Delphi  (Jonathan Bartlett <johnnyb@eskimo.com>)
Re: Picture with Postgres and Delphi  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Picture with Postgres and Delphi  (Michał Zaborowski <listy.mailowe@wp.pl>)
List pgsql-general
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@yahoo.com>:

> --- Jonathan Bartlett <johnnyb@eskimo.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

pgsql-general by date:

Previous
From: Kaare Rasmussen
Date:
Subject: 7.4 defaulting to ipv6 ?
Next
From: Alessandro GARDICH
Date:
Subject: message type 0x50