Thread

1. Large binary objects?

   Michael R. Jinks <mjinks@uchicago.edu> — 2000-05-30T22:35:48Z

   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/
   
   

2. Re: Large binary objects?

   Mark Versaggi <mark@versaggi.com> — 2000-05-31T00:41:41Z

   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/
   
   
   

3. Re: Large binary objects?

   Bill Morrow <wmorrow@home.com> — 2000-05-31T01:57:55Z

   > "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