Re: Storing images in SQL database?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 5 Oct 2004 13:38:04 -0500
Message-ID: <uzn31ggil.fsf@standardandpoors.com>

On Tue, 05 Oct 2004, recneps.w.divad_at_elcaro.moc wrote:
>
>
> Galen Boyer wrote:

>> On Tue, 05 Oct 2004, andy_at_andyh.co.uk wrote:
>>
>>> As for it being harder to use in a web environment,
>> I'd like to hear the explanation of this.

>
> Compare:
>
> [img src="/srv/www/htdocs/image.png"]
>
> with
>
> [img src="SELECT IMAGE FROM IMAGE_TABLE"]
>
> One of them probably won't work.

But, you already have access to the database, so use that layer and issue:

   select picture from tbl where id = ?;

where the table is:

   create table image_tbl(
    id number
   ,picture blob);

What's the issue?

-- 
Galen Boyer

Received on Tue Oct 05 2004 - 13:38:04 CDT