| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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,
>>
>>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M. Bastin | 2004-03-27 19:11:31 | Re: Images in Database |
| Previous Message | Tom Lane | 2004-03-27 18:01:32 | Re: problem (bug?) when killing client program |