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 по дате отправления: