On Fri, Aug 04, 2000 at 07:55:52AM +0100, Peter Mount wrote:
> See below...
> Peter: I dissagree. There are dozens of instances where you would use a
> single BLOB but refer to it in more than one table. If you have a 1Mb blob
> refered to in 3 different tables, you don't want to store 3 instances of it.
> Say you were implementing some form of DIP system (Document Image
> Processing), then you only want one copy of the document stored, so that if
> that document changes, then every instance is changed.
But Peter, the relational way to avoid redundant storage should apply. For
every other type, one does this by storing the data in one place, with
a unique ID, and using the ID to refer to the data item, and joining when
you need the item itself.
So, once large data items are promoted to first class types, they should
act just like every other first class type. Otherwise, we violate the
principle of least surprise. Having software that tries to second guess
the developer is always frustrating.
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
In response to
pgsql-hackers by date
|Next:||From: Thomas Lockhart||Date: 2000-08-04 14:57:24|
|Subject: OT: Dumb mail question|
|Previous:||From: The Hermit Hacker||Date: 2000-08-04 14:43:17|
|Subject: Re: comparing rows|
pgsql-general by date
|Next:||From: Bruce Momjian||Date: 2000-08-04 15:47:26|
|Subject: Re: [HACKERS] pg_dump/restore to convert BLOBs to LZTEXT (optiona l!)|
|Previous:||From: luc00||Date: 2000-08-04 10:23:17|
|Subject: app development general technics ?|