From: jarednevans@yahoo.com
To: pgsql-sql@postgresql.org
Subject: Re: not really SQL but I need info on BLOBs
Date: 28 May 2004 09:40:39 -0700
Message-ID: <72cbb5b4.0405280840.48e8af69@posting.google.com> (raw)
References: <20040505151003.63773.qmail@web41004.mail.yahoo.com>
I did something similar- a web application for online employer picture
directory along with dynamic graphical output of the desk locations
throughout the company (using the GD package).
I kept the pictures in a separate directory and used links in the
database. I set up a DB trigger that took care of the respective
picture if an employer left. It worked great and was fantastic from a
performance perspective.
The only reason I could come up with keeping images in the DB as BLOBs
is if you developed a specialized function that would do actual image
analysis on the pictures themselves. For example, flagging certain
images after weeding out faces of terrorists in a picture of a crowd
of random people. But what do I know, I don't work at the Department
of Homeland Security :-)
Jared
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jarednevans@yahoo.com
Subject: Re: not really SQL but I need info on BLOBs
In-Reply-To: <72cbb5b4.0405280840.48e8af69@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox