Another thing that whoever is implementing BLOBS will have to be aware of
is making sure that access to individual BLOBS is controlled by the
'owning' table.

I don't know if an implementation has been settled on, but at one point it
was suggested that BLOBs be stored in a single table. I suspect this
approach would not work for the above reason.

Also, is there any reason why BLOBs need to be stored in a table at all?
Can lower level I/O routines to be used to chain groups of pages together?

Finally, is there a plan for the BLOB implementation that is available for
comment?


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: +61-03-5367 7422            |                 _________  \
Fax: +61-03-5367 7430            |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Tue, 27 Jul 1999 12:04:26 +1000
Philip Warner <pjw@rhyme.com.au>
BLOBS and security

Is there likley to be a way to use BLOBS via psql????


On Tue, 27 Jul 1999, Philip Warner wrote:

> Another thing that whoever is implementing BLOBS will have to be aware of
> is making sure that access to individual BLOBS is controlled by the
> 'owning' table.
> 
> I don't know if an implementation has been settled on, but at one point it
> was suggested that BLOBs be stored in a single table. I suspect this
> approach would not work for the above reason.
> 
> Also, is there any reason why BLOBs need to be stored in a table at all?
> Can lower level I/O routines to be used to chain groups of pages together?
> 
> Finally, is there a plan for the BLOB implementation that is available for
> comment?
> 
> 
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.C.N. 008 659 498)             |          /(@)   ______---_
> Tel: +61-03-5367 7422            |                 _________  \
> Fax: +61-03-5367 7430            |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                  |    --________--
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/
> 

A.J. (james@fsck.co.uk)
Sometimes you're ahead, somtimes you're behind.
The race is long, and in the end it's only with yourself.


Tue, 27 Jul 1999 13:12:43 +0100 (BST)
A James Lewis <james@fsck.co.uk>
Re: [HACKERS] BLOBS and security