Re: How to store fixed size images?

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to store fixed size images?
Date: 2014-06-17 08:27:57
Message-ID: VisenaEmail.f7.6e526a63e1a0772d.146a8ef3eaa@tc7-on
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

På tirsdag 17. juni 2014 kl. 03:10:57, skrev sunpeng <bluevaley(at)gmail(dot)com
<mailto:bluevaley(at)gmail(dot)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
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com> www.visena.com
<https://www.visena.com> <https://www.visena.com>  

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sameer Kumar 2014-06-17 09:15:53 Re: HOT standby with ONLY WAL shipping?
Previous Message Michael Paquier 2014-06-17 02:30:49 Re: Creating Table Copy