Using TEXT columns for binary content

Поиск
Список
Период
Сортировка
От Mircea Sarbu
Тема Using TEXT columns for binary content
Дата
Msg-id NDBBLPEDOLMDDGLHIECACECAHNAA.msarbu@agora.ro
обсуждение исходный текст
Ответы Re: Using TEXT columns for binary content
Список pgsql-general
Hello,

I work with Postgresql 7.2 using Python and Zope as frontend. I have to deal
with some binary content (just pictures) so I considered the options: BLOB and
BYTEA.

BLOB doesn't works for me (because I have no control on the web hosting
environment).

BYTEA seems to be very slow. So far I know, bytea implies tree steps of
processing: string-literal parser, bytea input function and my own encoding
function (of course, a very lazy one...).

I tried a third way: to use simple TEXT columns for storing the pictures. Using
Python library functions for base64 encoding and decoding everything works fine
(and very fast).

My question is:

There are some hidden drawbacks for this approach? (I don't need any further
processing on the binary content)

Thanks for your advice,

Mircea


В списке pgsql-general по дате отправления: