RE: question on images and DB

From: Eve Pokua <gorgeous65_at_msn.com>
Date: Thu, 17 Sep 2009 15:34:13 +0100

research:

why don't you just store the image in the server side and give the relative path of image in the <src > ex
<td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>.
some big website (or image intensive ) store the images in different server then where there app is deployed.

From: gorgeous65_at_msn.com
To: users_at_glassfish.dev.java.net
Date: Thu, 17 Sep 2009 15:14:00 +0100
Subject: RE: question on images and DB

Hi,

Matter

I believe i might take your suggestion, even though images takes up more space.
I believe maintenance of the application would be easier. And syn data from the
DB which relates to the particular image would be easier.

i was reading this:

http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx

Hi

Hassan

Just put them in the filesystem. Storing large binaries in a relational
db is a pointless complication. IMO.

How so I manage this.

If I have 0ver 200 items I have to syn an image on a filesystem- store
the image in a folder and point each row of data I collect from the database
with an image. How is that possible?

To achive your suggestion I have to:

<td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>.
<td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>.

similar to the able.. But remember I am using displaytag. eg.:

<display:table name="test">
 <display:column property="id" title="ID" />
 <display:column property="name" />
 <display:column property="email" />
 <display:column property="status" />
 <display:column property="description" title="Comments"/>
<td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>.

</display:table>

If I was storing in a DB, I would do something like this:

<display:table name="test">
 <display:column property="id" title="ID" />
 <display:column property="name" />
 <display:column property="email" />
 <display:column property="status" />
 <display:column property="description" title="Comments"/>
<display:column property="image"/>

"image" would be a field within the DB which stores the image.

Makes it easy to syn.

What you think?

eve

eve

> Date: Thu, 17 Sep 2009 06:28:14 -0700
> From: glassfish_at_javadesktop.org
> To: users_at_glassfish.dev.java.net
> Subject: Re: question on images and DB
>
> Most DBs have a BLOB or CBLOB type that you can use for large binary object types. Since this is a GF forum and not an MSSQL forum you're better off reading the relevant documentation or tracking down an MSSQL support forum for more help on this.
>
> [b]<rant>[/b]Why do some people ask such random questions in this forum? Seriously weird.[b]</rant>[/b]
> [Message sent by forum member 'matterbury' (matterbury_at_abinitio.com)]
>
> http://forums.java.net/jive/thread.jspa?messageID=364417
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>

View your Twitter and Flickr updates from one place � Learn more! _________________________________________________________________ Get the best of MSN on your mobile http://clk.atdmt.com/UKM/go/147991039/direct/01/
--_c3a4d02f-7643-4fc6-9c5c-298dbc5af517_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style></style>
</head>
<body class='hmmessage'>
  
research: 
  
<DIV class=pad5x10>why don't you just store the image in the server side and give the relative path of image in the <src > ex <td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>. some big website (or image intensive ) store the images in different server then where there app is deployed. </DIV>
   
<HR id=stopSpelling>
From: gorgeous65_at_msn.com To: users_at_glassfish.dev.java.net Date: Thu, 17 Sep 2009 15:14:00 +0100 Subject: RE: question on images and DB 
<STYLE>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Verdana;}
</STYLE>
Hi, Matter   I believe i might take your suggestion, even though images takes up more space. I believe maintenance of the application would be easier. And syn data from the  DB which relates to the particular image would be easier.    i was reading this:   <A href="http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx">http://www.extremeexperts.com/sql/FAQ/StoreImages.aspx</A>   Hi   Hassan   Just put them in the filesystem. Storing large binaries in a relational db is a pointless complication. IMO.   How so I manage this.   If I have 0ver 200 items I have to syn an image on a filesystem- store the image in a folder and point each row of data I collect from the database with an image.  How  is that possible?   To achive your suggestion I have to:   <td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>. <td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>.   similar to the able.. But remember I am using displaytag. eg.:   <display:table name="test">   <display:column property="id" title="ID" />   <display:column property="name" />   <display:column property="email" />   <display:column property="status" />   <display:column property="description" title="Comments"/> <td width="9"><img src="images/mainTab_Inactive_left.gif" ></td>. </display:table>   If I was storing in a DB, I would do something like this:   <display:table name="test">   <display:column property="id" title="ID" />   <display:column property="name" />   <display:column property="email" />   <display:column property="status" />   <display:column property="description" title="Comments"/> <display:column property="image"/>   "image" would be a field within the DB which stores the image.   Makes it easy to syn.   What you think?   eve             eve   > Date: Thu, 17 Sep 2009 06:28:14 -0700 > From: glassfish@javadesktop.org > To: users@glassfish.dev.java.net > Subject: Re: question on images and DB > > Most DBs have a BLOB or CBLOB type that you can use for large binary object types. Since this is a GF forum and not an MSSQL forum you're better off reading the relevant documentation or tracking down an MSSQL support forum for more help on this. > > [b]<rant>[/b]Why do some people ask such random questions in this forum? Seriously weird.[b]</rant>[/b] > [Message sent by forum member 'matterbury' (matterbury@abinitio.com)] > > http://forums.java.net/jive/thread.jspa?messageID=364417 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net > For additional commands, e-mail: users-help@glassfish.dev.java.net > 
<HR>
View your Twitter and Flickr updates from one place � <A href="http://clk.atdmt.com/UKM/go/137984870/direct/01/">Learn more!</A> <hr />
Upgrade to Internet Explorer 8 Optimised for MSN. <a href='http://extras.uk.msn.com/internet-explorer-8/?ocid=T010MSN07A0716U' target='_new'>Download Now</a></body>
</html>
--_c3a4d02f-7643-4fc6-9c5c-298dbc5af517_--