Skip site navigation (1) Skip section navigation (2)

Re: Images in Database

From: Reshat Sabiq <sabiq(at)purdue(dot)edu>
To: aarni(dot)ruuhimaki(at)kymi(dot)com
Cc: Paulo Jorge de Oliveira Cantante de Matos <pocm(at)mega(dot)ist(dot)utl(dot)pt>,pgsql-novice(at)postgresql(dot)org
Subject: Re: Images in Database
Date: 2004-03-27 18:34:18
Message-ID: 4065C92A.5020101@purdue.edu (view raw or flat)
Thread:
Lists: pgsql-novice
I think unless the DB provides some image-searching capabilities, it's 
better to store them as paths to save the space. A lot of storage will 
be wasted otherwise. Isn't that so?

-- 
Sincerely,
Reshat.
---
If you see my certificate with this message, you should be able to send me encrypted e-mail. 
Please consult your e-mail client for details if you would like to do that.



Aarni Ruuhimäki wrote:

>Hi,
>
>Possible, and this is called BLOB data type. Binary large object.
>
>Some people use it with the possible cost in db size, the images as data in 
>the db. 
>
>Some prefer to store images as paths ie. text instead. 
>
>BR,
>
>Aarni
>
>On Friday 19 March 2004 14:06, you wrote:
>  
>
>>Hi all,
>>
>>Is it possible to have an image object in a database, like a gif, bmp,
>>jpeg, no matter which format?
>>
>>How? Couldn't find its datatype on the docs.
>>
>>Cheers,
>>    
>>
>
>  
>

In response to

Responses

pgsql-novice by date

Next:From: M. BastinDate: 2004-03-27 19:11:31
Subject: Re: Images in Database
Previous:From: Tom LaneDate: 2004-03-27 18:01:32
Subject: Re: problem (bug?) when killing client program

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group