Re: How to store fixed size images?

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: How to store fixed size images?
Дата
Msg-id VisenaEmail.f7.6e526a63e1a0772d.146a8ef3eaa@tc7-on
обсуждение исходный текст
Ответ на How to store fixed size images?  (sunpeng <bluevaley@gmail.com>)
Список pgsql-general
På tirsdag 17. juni 2014 kl. 03:10:57, skrev sunpeng <bluevaley@gmail.com>:
We have many small size(most fixed size) images, how to store them? There are two options:
1. Store images in folders, managed by os file system, only store path in postgresql
2. Store image as bytea in postgresql
How do you usually store images?
Thanks!
 
The images we store might be quite large so we use OID (Large Objects) and use the java.sql.Blob API of the pgjdbc-ng driver to avoid having to deal with large byte-arrays.
 
--
Andreas Jospeh Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Creating Table Copy
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: HOT standby with ONLY WAL shipping?