On 2009-11-26, Jean-Yves F. Barbier <12ukwn(at)gmail(dot)com> wrote:
> Hi list,
>
> I'm asking myself what solution for storing pictures is the best:
>
> * using a BYTEA column type, and having no intrinsic compression gain
> because a picture it almost every time already compressed,
>
> * using a TEXT column type, and store a Base64(picture) in it; it should
> take benefits of intrinsic compression (?).
use bytea and convert to/from base64 if you can't use the binary
interface and find the text interface inconvenient.
this will make the data over 1/3 bigger.