BYTEA or LO? - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject BYTEA or LO?
Date
Msg-id 20110531190923.7f53fa91@anubis.defcon1
Whole thread Raw
Responses Re: BYTEA or LO?  ("ktm@rice.edu" <ktm@rice.edu>)
List pgsql-novice
Hi list,

I need to read/write pictures to my DB and I wonder which column type
would be the best? (and DON'T feed the troll: I won't put them onto the FS),
client will be written in Python.

I formerly tested BYTEA (7.dontremember) and found that I needed to transcode
my pictures into Base64 format to be able to do so (long and add 33% to the
size); this is what I'd like to avoid.

Pictures will be written (rare), read (often) and deleted (rare), but
may be, one day, this program could have a web interface.

So what would be the best to my needs?

JY
--
You can build a throne out of bayonets, but you can't sit on it for very long.
        -- Boris Yeltsin

pgsql-novice by date:

Previous
From: Mark Wimer
Date:
Subject: Re: Create GEOM Column
Next
From: "ktm@rice.edu"
Date:
Subject: Re: BYTEA or LO?