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