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

From Darko Prenosil
Subject Re: Picture with Postgres and Delphi
Date
Msg-id 003a01c37713$11c939b0$ae96bfd5@darko
Whole thread Raw
In response to Picture with Postgres and Delphi  ("Edwin Quijada" <listas_quijada@hotmail.com>)
Responses Re: Picture with Postgres and Delphi
List pgsql-general
----- Original Message -----
From: "Edwin Quijada" <listas_quijada@hotmail.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, September 09, 2003 6:54 PM
Subject: [GENERAL] Picture with Postgres and Delphi


> Hi !! Everybody
> I am developing app using Delphi and I have a question:
> I have to save pictures into my database. Each picture has 20 o 30k aprox.
> What is the way more optimus?
> That 's table will have 500000 records around. Somebody said the best way
to
> do that was encoder the picture to field bytea but I dont know about this.
> Another way is save the path to the picture file but I dont like so much
> because I need to write to disk by OS and have permission to write a
> directory to OS.
> What do u think??

You may choose between Bytea or large objects.
I had some problems with bytea on earlier version of pg (7.2 I think), but
last time I checked (7.3), all worked fine.
However, I use large objects.
The only disadvantage of large objects I see is that You can't dump them
into textual dump. You must use binary dumps.

Regards !


pgsql-general by date:

Previous
From: "Darko Prenosil"
Date:
Subject: Re: Picture with Postgres and Delphi
Next
From: Tom Lane
Date:
Subject: Re: Kill -9 Postmaster and Temporary Tables