Thread: Large binary objects?

Large binary objects?

From
"Michael R. Jinks"
Date:
I've been asked to look into setting up a database for storing audio footage
with accompanying descriptive data, but as I look at the PostgreSQL specs
I don't find a "binary" data type.  Is that because this sort of thing can't
be done with PostgreSQL, or because I'm looking at it the wrong way?

TIA,
-m
--
Michael Jinks, IB
Systems Administrator, Chicago Center for Computational Psychology
finger mjinks@embley.spc.uchicago.edu for public key
A guiding voice for all humanity: http://www.yellow5.com/pokey/

Re: Large binary objects?

From
Mark Versaggi
Date:
Michael...

I'm a novice so this may not be just right, but I don't think you can store
binary stuff into a database.

What I did with files and descriptive data wat to upload the files seperatly and
use the database to hold all the descriptive info.

For example. I have fields 1 tru 10 each with descriptive info in them. Field 10
holds the name of the file I am refering to. Then I created an html page that
took all the info and placed it into a useable format. I linked the file name
from field 10 to the actual upload directory containing the true bianary file.

It's my creative way of doing things.

Mark Versaggi

"Michael R. Jinks" wrote:

> I've been asked to look into setting up a database for storing audio footage
> with accompanying descriptive data, but as I look at the PostgreSQL specs
> I don't find a "binary" data type.  Is that because this sort of thing can't
> be done with PostgreSQL, or because I'm looking at it the wrong way?
>
> TIA,
> -m
> --
> Michael Jinks, IB
> Systems Administrator, Chicago Center for Computational Psychology
> finger mjinks@embley.spc.uchicago.edu for public key
> A guiding voice for all humanity: http://www.yellow5.com/pokey/


Re: Large binary objects?

From
Bill Morrow
Date:
> "Michael R. Jinks" wrote:
>
> > I've been asked to look into setting up a database for storing audio footage
> > with accompanying descriptive data, but as I look at the PostgreSQL specs
> > I don't find a "binary" data type.  Is that because this sort of thing can't
> > be done with PostgreSQL, or because I'm looking at it the wrong way?
> >
> > TIA,

Have a look at "large objects", described in postgres_manual/lobj.html if you have
installed the online manual.

I have no personal experience with them, so can't speak to their efficiency or
reliability.

Bill