Postgres Pro
Downloads
Home   >   mailing lists

Re: How to store fixed size images? - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Re: How to store fixed size images?
Date
Msg-id VisenaEmail.f7.6e526a63e1a0772d.146a8ef3eaa@tc7-on
Whole thread Raw
In response to How to store fixed size images?  (sunpeng <bluevaley@gmail.com>)
List pgsql-general
Tree view
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
 
Attachment

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Creating Table Copy
Next
From: Sameer Kumar
Date:
Subject: Re: HOT standby with ONLY WAL shipping?