Re: How to store fixed size images?

[Andreas Joseph Krogh <andreas@xxxxxxxxxx>]

På tirsdag 17. juni 2014 kl. 03:10:57, skrev sunpeng <bluevaley@xxxxxxxxx>:

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

andreas@xxxxxxxxxx

www.visena.com