Recommendation on bytea or blob for binary data like images

Поиск
Список
Период
Сортировка
От leon@oss.minimetria.com
Тема Recommendation on bytea or blob for binary data like images
Дата
Msg-id 42165.70.34.104.163.1125688546.squirrel@webmail.oss.minimetria.com
обсуждение исходный текст
Ответы Re: Recommendation on bytea or blob for binary data like images  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hi, I'd like to know what the official recommendation is on which binary
datatype to use for common small-binary size use.

I'm working with the Open For Business (www.ofbiz.org) framework, which by
default maps binary data, such as shipping label images, into OID field
types. In general, the data is far less than a gigabyte in size. Is it
strongly recommended by the postgresql community to store things like this
in bytea format as of 8.0?

Thanks,

Leon Torres
leon@oss.minimetria.com
Open Source Strategies
http://opensourcestrategies.com





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

Предыдущее
От: "Owen Jacobson"
Дата:
Сообщение: Re: Turn off auto-commit
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Recommendation on bytea or blob for binary data like images