Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Best way to store and retrieve photo from PostGreSQL

  • From: Jean-Christophe Roux <jcxxr(at)yahoo(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Cc: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-general(at)postgresql(dot)org
  • Subject: Re: Best way to store and retrieve photo from PostGreSQL
  • Date: Sun, 25 Feb 2007 12:47:08 -0500
  • Message-id: <45E1CB9C(dot)2050604(at)yahoo(dot)com>
Hello Tomas,

Tomas Vondra wrote:



Store the pictures in the filesystem and only the path, description and
other metadata in the database. My suggestion ;-)


Andreas
Anyway, I do recommend storing images in the database, using a 'bytea' column for the binary data (and load them only if reallly needed, using proper projection). You can do some benchmarks, but I've never head
Would you say the same if the images were each 30MB+ and there were thousands of them, possibly needing to be stored on several hardwares? 
Thanks
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group