Re: Best way to store and retrieve photo from PostGreSQL

From: Jean-Christophe Roux <jcxxr(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to store and retrieve photo from PostGreSQL
Date: 2007-02-25 17:47:08
Message-ID: 45E1CB9C.2050604@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Tomas,

Tomas Vondra wrote:
>
>> Store the pictures in the filesystem and only the path, description and
>> other metadata in the database. My suggestion ;-)
>>
>>
>> Andreas

> Anyway, I do recommend storing images in the database, using a 'bytea'
> column for the binary data (and load them only if reallly needed, using
> proper projection). You can do some benchmarks, but I've never head

Would you say the same if the images were each 30MB+ and there were
thousands of them, possibly needing to be stored on several hardwares?
Thanks

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2007-02-25 17:49:23 Re: Best way to store and retrieve photo from PostGreSQL
Previous Message Alain Roger 2007-02-25 17:43:24 Re: Best way to store and retrieve photo from PostGreSQL