Skip site navigation (1) Skip section navigation (2)

BYTEA or LO?

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: BYTEA or LO?
Date: 2011-05-31 17:09:23
Message-ID: 20110531190923.7f53fa91@anubis.defcon1 (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: ktm@rice.eduDate: 2011-05-31 18:40:02
Subject: Re: BYTEA or LO?
Previous:From: Mark WimerDate: 2011-05-31 16:54:55
Subject: Re: Create GEOM Column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group