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

From Michał Zaborowski
Subject Re: Picture with Postgres and Delphi
Date
Msg-id 3F5F7D32.5020305@wp.pl
Whole thread Raw
In response to Re: Picture with Postgres and Delphi  ("Darko Prenosil" <Darko.Prenosil@finteh.hr>)
Responses Re: Picture with Postgres and Delphi
Re: Picture with Postgres and Delphi
List pgsql-general
Darko Prenosil wrote:
>
> There is no need for manually storing files on filesystem, because large
> objects are doing that for You. I am storing whole binary files in
> blobs(synonym for large objects from some other platforms), and I do not
> remember that I had a single problem with that. Do not forget that libpq has
> great support for large objects, and you can store large object without
> actually storing them on server filesystem, so You do not need any file
> permissions on "upload directory" or something like that.
 >
   The pictures are prepared for web. Storing in files is faster from
that side. That system is calling db every 30 mins...

> If You are using Delphi, there is great project called "Zeos objects", and
> if I remember correctly it has support for large objects.
>
   Zeos are useing a lot of memory...

Regards,
   Michał Zaborowski (TeXXaS)


pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Picture with Postgres and Delphi
Next
From: Michał Zaborowski
Date:
Subject: Re: Picture with Postgres and Delphi