Image Question

Hi,
What is the better way to save image into a database ?
Just save the path into a field or save the image itself ?
I have 20 000 images (~ 10/12 Ko per image ) to save.

Stan

re: Image Question

Did someone say it was better to store them in a DB?


"Stan Sainte-Rose" <stan@cyber972.com> wrote in message
news:%23gvTeUy8DHA.4044@tk2msftngp13.phx.gbl...[color=blue]
> Hi,
> What is the better way to save image into a database ?
> Just save the path into a field or save the image itself ?
> I have 20 000 images (~ 10/12 Ko per image ) to save.
>
> Stan
>
>[/color]

re: Image Question

* "Stan Sainte-Rose" <stan@cyber972.com> scripsit:[color=blue]
> What is the better way to save image into a database ?
> Just save the path into a field or save the image itself ?
> I have 20 000 images (~ 10/12 Ko per image ) to save.[/color]

I would store them in the database.

;-)

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

Hi Stan,

I can't see any particular advantage to storing the images in the database
can you? I can think of a number of key reasons not to.

Tom

"Stan Sainte-Rose" <stan@cyber972.com> wrote in message
news:%23gvTeUy8DHA.4044@tk2msftngp13.phx.gbl...[color=blue]
> Hi,
> What is the better way to save image into a database ?
> Just save the path into a field or save the image itself ?
> I have 20 000 images (~ 10/12 Ko per image ) to save.
>
> Stan[/color]

re: Image Question

It guess, it would depend on the type of application.

For a web application, I think it would be best to store a image path to
a database, but actually store the image in a directory, and not bloat
your database.

For a desktop c/s application, I think it would best to store the image
in a database, then having to access a shared resource to access the
image.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

re: Image Question

Stan,

IMHO, here's some of the pros and cons of storing the image data in the
database as opposed to just a link the file:

Pro's
--------
1) Synchronization is easier if you store the data in the database because:
a) If you delete the image record, you don't have to worry about deleting
the file
b) If the file is moved, links in the database may be broken as a result
c) If you move the database (e.g. because you're changing the server), you
don't have to worry about moving the files too and maintaining all the links

2) You don't have to worry about duplicate file names for the image files

3) If your database is located on a network server, but the images are
scattered on client machines then maintaining links will be a nightmare.
Having the images as part of the database would be an advantage.



Con's
-------
If you corrupt your database, all images are lost, not just one or two (but
if you don't keep backups then well...)

If you use a database that stores the database as one file (e.g. Access),
then this one file may become pretty big, so copying it and backing it up
will be a bit more hassle because you may have to split it.


I would tend to go for storing the data in the database, not only because of
the benefits above, but because its easier to program as you don't have to
worry about all the file IO and directory permissions etc.

Hope this helps,

Trev.



"Stan Sainte-Rose" <stan@cyber972.com> wrote in message
news:%23gvTeUy8DHA.4044@tk2msftngp13.phx.gbl...[color=blue]
> Hi,
> What is the better way to save image into a database ?
> Just save the path into a field or save the image itself ?
> I have 20 000 images (~ 10/12 Ko per image ) to save.
>
> Stan
>
>[/color]

re: Image Question

Trev,

I'm happy to see that someone posted a thought process rather than just an
"opinion" but consider that we don't know anything about the images like how
often they may change, what they are used for, etc. To conclude something
with as little information as has been posted isn't typically a good idea...

Synchronization for instance... if you delete the record you have
effectively erased the image. Are we certain destroying the image is the
goal? Where is the original, if we're lucky in yet another folder on the
hard drive, if we're unlucky it's gone.

If images are duplicated (the "no image available" image for instance) then
you have stored (possibly) hundreds of copies of that image. Will the
system eventually have to support multiple formats? Do you want to store
..jpeg, .gif and .png in three separate columns?

Would you suggest the same thing if the guy was storing 20,000 video files?
What size of file would stop at and what if there was a combination of
20,000 images and 10,000 very large video files?

And as for "you don't have to worry about the file i/o" again we don't
really know if that is the entire purpose of the database of images right?
How do they get uploaded and are they available for download?

Tom


"Trev Hunter" <hunter_trev@hotmail.com> wrote...[color=blue]
> Stan,
>
> IMHO, here's some of the pros and cons of storing the image data in the
> database as opposed to just a link the file:
>
> Pro's
> --------
> 1) Synchronization is easier if you store the data in the database[/color]
because:[color=blue]
> a) If you delete the image record, you don't have to worry about deleting
> the file
> b) If the file is moved, links in the database may be broken as a result
> c) If you move the database (e.g. because you're changing the server), you
> don't have to worry about moving the files too and maintaining all the[/color]
links[color=blue]
>
> 2) You don't have to worry about duplicate file names for the image files
>
> 3) If your database is located on a network server, but the images are
> scattered on client machines then maintaining links will be a nightmare.
> Having the images as part of the database would be an advantage.
>
> Con's
> -------
> If you corrupt your database, all images are lost, not just one or two[/color]
(but[color=blue]
> if you don't keep backups then well...)
>
> If you use a database that stores the database as one file (e.g. Access),
> then this one file may become pretty big, so copying it and backing it up
> will be a bit more hassle because you may have to split it.
>
>
> I would tend to go for storing the data in the database, not only because[/color]
of[color=blue]
> the benefits above, but because its easier to program as you don't have to
> worry about all the file IO and directory permissions etc.
>
> Hope this helps,
>
> Trev.
>
>
>
> "Stan Sainte-Rose" <stan@cyber972.com> wrote in message
> news:%23gvTeUy8DHA.4044@tk2msftngp13.phx.gbl...[color=green]
> > Hi,
> > What is the better way to save image into a database ?
> > Just save the path into a field or save the image itself ?
> > I have 20 000 images (~ 10/12 Ko per image ) to save.
> >
> > Stan[/color][/color]

re: Image Question

* "Tom Leylan" <gee@iamtiredofspam.com> scripsit:[color=blue]
> I can't see any particular advantage to storing the images in the database
> can you? I can think of a number of key reasons not to.[/color]

Easier deployment may be a reason for storing everything in the
database. No "dangling" filenames/paths may be another reason.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

> I'm happy to see that someone posted a[color=blue]
> thought process rather than just an
> "opinion"[/color]

Cheers, but some of the first words in my post were "IMHO" ;)

[color=blue]
> but consider that we don't know
> anything about the images like how
> often they may change, what they
> are used for, etc. To conclude something
> with as little information as has
> been posted isn't typically a good idea...[/color]


I admit, I was wrong to make so many assumptions about what the final
product will be doing and how it will do it. I based my assumptions on an
app that I recently wrote that stores documents of all types in a central
database. I was wrong to assume that the OP's application was similar
without more information. I did happen to notice your first post made the
opposite assumption that there isn't any advantage to storing the images in
the database though...


If ya have the time, let me explain my design (and hence my recommendations
based on these assumptions):

1) The Application will be used to store documents in a central location
(this can apply to a web server, email application, windows application
etc). This will involve users selecting a document from their local machine
and "uploading" it to the server.

2) When the user wants to view the file, they query the server. At this
point, if there is no record in the database, the user can't get the file,
so effectively there is no file anymore (even if there is a orphan file
somewhere on the server that had its record deleted).

3) If a user deletes a file from the server, it is deleted from the server,
not the location that they originally uploaded it from.


To respond to your comments:
[color=blue]
> Synchronization for instance...
> if you delete the record you have
> effectively erased the image. Are we
> certain destroying the image is the goal?[/color]

See point (3) and again, sorry for the assumption.
[color=blue]
> If images are duplicated (the
> "no image available" image for
> instance) then you have stored
> (possibly) hundreds of copies of that image.[/color]

I would expect a bit of common sense on the part of the database schema and
application design to handle these situations. To handle no image available,
store Null and have a default image elsewhere. To handle multiple copies of
the same image, implement the schema with a join table and implement the UI
so that the user gets prompted if a similar image exists (based on other
data about the image).
[color=blue]
> Do you want to store
> .jpeg, .gif and .png in
> three separate columns?[/color]

Again, a little bit of design intelligence would do here.

[color=blue]
> Would you suggest the same thing if the
> guy was storing 20,000 video files?[/color]

Probably not. They *did* state their requirements on this point in the
original post though. The reason why I wouldn't recommend it is because of
one of the con's mentioned in my first post (the part about maintaining a
large single file for backups etc.) would far outweigh the benefits of
storing in the database.
[color=blue]
> again we don't really know if that is
> the entire purpose of the database of
> images right? How do they get uploaded
> and are they available for download?[/color]

Again, my bad for making the assumptions.

[color=blue]
> To conclude something
> with as little information as
> has been posted isn't typically a good idea...[/color]

Point taken and I'll be more careful in the future. I hope you can do the
same before posting responses like your original one:
[color=blue]
> I can't see any particular
> advantage to storing the
> images in the database
> can you? I can think of
> a number of key reasons not to.[/color]


Thanks for the discussion. Hopefully I'll learn not to make assumptions like
this in the future.

Trev.




"Tom Leylan" <gee@iamtiredofspam.com> wrote in message
news:%23WEG6Z08DHA.1804@TK2MSFTNGP12.phx.gbl...[color=blue]
> Trev,
>
> I'm happy to see that someone posted a thought process rather than just an
> "opinion" but consider that we don't know anything about the images like[/color]
how[color=blue]
> often they may change, what they are used for, etc. To conclude something
> with as little information as has been posted isn't typically a good[/color]
idea...[color=blue]
>
> Synchronization for instance... if you delete the record you have
> effectively erased the image. Are we certain destroying the image is the
> goal? Where is the original, if we're lucky in yet another folder on the
> hard drive, if we're unlucky it's gone.
>
> If images are duplicated (the "no image available" image for instance)[/color]
then[color=blue]
> you have stored (possibly) hundreds of copies of that image. Will the
> system eventually have to support multiple formats? Do you want to store
> .jpeg, .gif and .png in three separate columns?
>
> Would you suggest the same thing if the guy was storing 20,000 video[/color]
files?[color=blue]
> What size of file would stop at and what if there was a combination of
> 20,000 images and 10,000 very large video files?
>
> And as for "you don't have to worry about the file i/o" again we don't
> really know if that is the entire purpose of the database of images right?
> How do they get uploaded and are they available for download?
>
> Tom
>[/color]
[color=blue]
>[/color]

re: Image Question

It might but that would depend upon "deployment" and it wasn't mentioned.
Nor was the database.

If a solution is faster, easier and more reliable it seems like a good
reason to use it but I'm not certain we know that putting 10,000 images in a
database is any of those things.


"Herfried K. Wagner [MVP]" <hirf-spam-me-here@gmx.at> wrote in message
news:uH4wQq08DHA.2432@TK2MSFTNGP10.phx.gbl...[color=blue]
> * "Tom Leylan" <gee@iamtiredofspam.com> scripsit:[color=green]
> > I can't see any particular advantage to storing the images in the[/color][/color]
database[color=blue][color=green]
> > can you? I can think of a number of key reasons not to.[/color]
>
> Easier deployment may be a reason for storing everything in the
> database. No "dangling" filenames/paths may be another reason.
>
> --
> Herfried K. Wagner [MVP]
> <http://www.mvps.org/dotnet>[/color]

re: Image Question

"Trev Hunter" <hunter_trev@hotmail.com> wrote...[color=blue]
> Cheers, but some of the first words in my post were "IMHO" ;)[/color]

Clearly most replies are opinions but it is nice when people post the
rational behind. Situations are different and therefore perhaps the
conclusion.
[color=blue]
> I admit, I was wrong to make so many assumptions about what the final
> product will be doing and how it will do it. I based my assumptions on an
> app that I recently wrote that stores documents of all types in a central
> database. I was wrong to assume that the OP's application was similar
> without more information. I did happen to notice your first post made the
> opposite assumption that there isn't any advantage to storing the images[/color]
in[color=blue]
> the database though...[/color]

It is great that you have experience with it. I was going to suggest to the
OP that he seek out people doing this type of thing (whatever it is he is
doing) so that he didn't just get responses based upon people taking 15
seconds out to reply. I'll admit that believe he will be at least "as well
off" by keeping the images outside but I intended to ask him what he thought
the advantages might be for storing them in the database. I can't think of
many... that doesn't mean that we can't post "it will be easier" but is that
in fact a "fact"?

Perhaps... how does he get 10,000 images into the database attached to the
proper records?
[color=blue]
> 1) The Application will be used to store documents in a central location
> (this can apply to a web server, email application, windows application
> etc). This will involve users selecting a document from their local[/color]
machine[color=blue]
> and "uploading" it to the server.[/color]

I would have guessed from the short description that users wouldn't directly
upload files. So that's interesting.
[color=blue]
> 2) When the user wants to view the file, they query the server. At this
> point, if there is no record in the database, the user can't get the file,
> so effectively there is no file anymore (even if there is a orphan file
> somewhere on the server that had its record deleted).[/color]

I don't think I get this. But anyway, I would guess that a user could
select only from records in the database. If it isn't in the database then
it doesn't qualify for downloading and/or viewing. It doesn't matter if the
an image is sitting in folder... I have images sitting in folders on my
webserver, you can't get them :-)
[color=blue]
> 3) If a user deletes a file from the server, it is deleted from the[/color]
server,[color=blue]
> not the location that they originally uploaded it from.[/color]

Seems reasonable to me.
[color=blue]
> To respond to your comments:
>[color=green]
> > Synchronization for instance...
> > if you delete the record you have
> > effectively erased the image. Are we
> > certain destroying the image is the goal?[/color]
>
> See point (3) and again, sorry for the assumption.[/color]

We don't know that user routinely (if ever) keeps the images. Once
submitted they are "safely stored in the image archive" so what's the point?
Are the users working inhouse or subscribers to some service? I don't know
who owns the images.
[color=blue][color=green]
> > If images are duplicated (the
> > "no image available" image for
> > instance) then you have stored
> > (possibly) hundreds of copies of that image.[/color]
>
> I would expect a bit of common sense on the part of the database schema[/color]
and[color=blue]
> application design to handle these situations. To handle no image[/color]
available,[color=blue]
> store Null and have a default image elsewhere. To handle multiple copies[/color]
of[color=blue]
> the same image, implement the schema with a join table and implement the[/color]
UI[color=blue]
> so that the user gets prompted if a similar image exists (based on other
> data about the image).[/color]

Seems reasonable.
[color=blue][color=green]
> > Do you want to store
> > .jpeg, .gif and .png in
> > three separate columns?[/color]
>
> Again, a little bit of design intelligence would do here.[/color]

Perhaps but maybe I didn't explain it correctly. I can choose (from a
number of websites) to view movie trailers in one of three distinct formats
and often in low or high bandwidth versions. This means they have 6
different copies of the same film stored. If it is an image database such
that people can purchase and download the images it isn't hard to imagine
that a thumbnail would be required. Probably a larger image and possibly
another hi-definition version.

see: http://pro.corbis.com/

for information on image storage see:
http://sunsite.berkeley.edu/Imaging/Databases/
[color=blue][color=green]
> > Would you suggest the same thing if the
> > guy was storing 20,000 video files?[/color]
>
> Probably not. They *did* state their requirements on this point in the
> original post though. The reason why I wouldn't recommend it is because of
> one of the con's mentioned in my first post (the part about maintaining a
> large single file for backups etc.) would far outweigh the benefits of
> storing in the database.[/color]

I agree. That's why I'm doubtful that storing the 10K images directly in
the database is a good idea. To be sure, it might be a great idea I just
(so far) don't think so.
[color=blue][color=green]
> > To conclude something
> > with as little information as
> > has been posted isn't typically a good idea...[/color]
>
> Point taken and I'll be more careful in the future. I hope you can do the
> same before posting responses like your original one:[/color]

Sorry, I thought yours was the thoughtful response. Again I probably didn't
make myself clear on that. You gave "reasons" and so many times people just
post "opinions" never offering a basis for why they think what they think.

Which computer is best? <Blah Corp.> Oh that's great... why?
[color=blue][color=green]
> > I can't see any particular
> > advantage to storing the
> > images in the database
> > can you? I can think of
> > a number of key reasons not to.[/color][/color]

I see now... it was intended to be an invitation for discussion. Rather
than post "I think this... or that" I thought I might find out what the guy
with problem had thought about so far. He could be doing this for a large
corporation with a dedicated server and SQL Server or he could be putting
something together for the "dungeons and dragons" role-playing game he hosts
on a free internet site. I have no idea the kind of money or equipment (or
expertise) he has at his disposal.
[color=blue]
> Thanks for the discussion. Hopefully I'll learn not to make assumptions[/color]
like[color=blue]
> this in the future.[/color]

It isn't you Trev... it is the way people post stuff in general. That's one
of the reasons "which computer language is best" type questions generate so
much heat and so little light. Few people ask "what do you want to do with
it" before mentioning the language they know.

Take care,
Tom

re: Image Question

Hi Herfried,

You know I am busy with this.

The trouble I have now.
I cannot convert all formats to and from the database.
I have the idea that I loose information converting it from and to

Can you help me to overcome this or tell me what is wrong or right of above?

Cor

re: Image Question

Hi Stan,

I am busy with this so I cannot give you a complete answer.

I think it is very fine to use for thumbnails.
(Very fast processable)

For real images I am in doubt.

(If you want to know why see for that my question to Herfried)

Cor

re: Image Question

Wowww
I never thought my post will get this mass of replies...
I thank you for your opinions.. :)

Stan

re: Image Question

Cor,

I've recently implemented a solution to store all types of files in a
database (I've used Access, but the same principals should work for other
databases too). Let me know if I can be of assistance.

Trev.


"Cor" <non@non.com> wrote in message
news:OOjyPe68DHA.2760@TK2MSFTNGP09.phx.gbl...[color=blue]
> Hi Herfried,
>
> You know I am busy with this.
>
> The trouble I have now.
> I cannot convert all formats to and from the database.
> I have the idea that I loose information converting it from and to
>
> Can you help me to overcome this or tell me what is wrong or right of[/color]
above?[color=blue]
>
> Cor
>
>
>[/color]

re: Image Question

> Clearly most replies are opinions but it[color=blue]
> is nice when people post the
> rational behind.[/color]

Agreed. It's always nice to get a bit of an explanation for solutions to
problems.
[color=blue]
> but I intended to ask him what he thought
> the advantages might be for storing them in the database[/color]

Again, my bad for not asking the them to be a little more specific about the
requirements before posting my reply.
[color=blue]
> I can't think of many...[/color]

What advantages or disadvantages there may be depend on the requirements,
something that wasn't explained to either of us. I might have been wrong to
give pros and cons without the requirements (or providing my own explanation
for the pros and cons), but "I can't think of many..." is bordering on one
of those 15 second answers you mentioned (see why at *** below)
[color=blue]
> how does he get 10,000 images into the database attached to the
> proper records?[/color]

The same way he gets 10,000 records in the database to point to the correct
files (although a bit slower because of the data transfer).
[color=blue]
> I would have guessed from the short
> description that users wouldn't directly
> upload files. So that's interesting.[/color]

I don't know your experience with applications that do this, but I guess I
was swayed because I recently implemented a solution to upload files to a
central location and chose to go the database route.

[color=blue]
> I don't think I get this. But anyway, I
> would guess that a user could
> select only from records in the database.[/color]

Yes. The solution I implemented stored the documents on a server. To view a
list of the available documents, the user queries the database (not the file
system) for descriptions of the files. If there isn't any record for the
document, there is no way to get the document (unless you stored outside the
db and could get to the file going "behind the scenes" of my server
application).

I guess the two different types of applications that could be implemented
are as follows (regardless of where the files are stored):

1) Where the database complements the files - i.e. The user has a set of
files and then an auxiliary database designed to provide descriptions of the
files.

2) Where the database controls the files - i.e. The user has a set of files,
but wants to *copy* them to a central location. The database stores
descriptions of the files and provides the only index to the location of the
copied files.
[color=blue]
> If it isn't in the database then
> it doesn't qualify for downloading
> and/or viewing. It doesn't matter if the
> an image is sitting in folder... I have
> images sitting in folders on my
> webserver, you can't get them :-)[/color]

This depends on the pattern implemented (1 or 2). If pattern (1) is
implemented, then there is no point storing the files in the database and
copying them needlessly. If pattern (2) is implemented, then there are both
advantages and disadvantages to storing within the database. Depending on
the requirements, the disadvantages may outweigh the advantages, or vise
versa. In any case, pattern (2) requires that the files be copied - if they
are stored in the database or on the server's file system doesn't matter to
the user - as far as they are concerned, they copied the file and the only
way to get to it is by querying the database.

Pattern (2) also requires that the database and files be kept in sync all
the time. If you're worried about deleting an image, but loosing the actual
image data, then you shouldn't delete the row from the database - simply
mark a "Deleted" field as true or something.

[color=blue]
> That's why I'm doubtful that storing
> the 10K images directly in
> the database is a good idea.
> To be sure, it might be a great idea I just
> (so far) don't think so.[/color]

It depends on the requirements and how you weigh up the pros and cons based
on those requirements.
[color=blue]
> I see now... it was intended to be an
> invitation for discussion. Rather
> than post "I think this... or that"
> I thought I might find out what the guy
> with problem had thought about so far.[/color]

*** I see that now, but your post could easily have been taken for one of
those 15 second answers (as I took it by mistake). Maybe a direct question
would have been better...
[color=blue]
> It isn't you Trev... it is the way people post
> stuff in general.[/color]

It was partly me... I posted a response based on wide ranging assumptions.
That's another type of posting I'd like to see an end to.

[color=blue]
> That's one of the reasons
> "which computer language is best" type
> questions generate so
> much heat and so little light.[/color]

lol. I never heard anybody put it better. We've all seen too many of those
posts lately (and I've always tried to narrow my answer down to "base your
choice on your requirements").


Thanks again for the discussion.


Take care,

Trev.


"Tom Leylan" <gee@iamtiredofspam.com> wrote in message
news:eGD31V28DHA.3648@TK2MSFTNGP11.phx.gbl...[color=blue]
> "Trev Hunter" <hunter_trev@hotmail.com> wrote...[color=green]
> > Cheers, but some of the first words in my post were "IMHO" ;)[/color]
>
> Clearly most replies are opinions but it is nice when people post the
> rational behind. Situations are different and therefore perhaps the
> conclusion.
>[color=green]
> > I admit, I was wrong to make so many assumptions about what the final
> > product will be doing and how it will do it. I based my assumptions on[/color][/color]
an[color=blue][color=green]
> > app that I recently wrote that stores documents of all types in a[/color][/color]
central[color=blue][color=green]
> > database. I was wrong to assume that the OP's application was similar
> > without more information. I did happen to notice your first post made[/color][/color]
the[color=blue][color=green]
> > opposite assumption that there isn't any advantage to storing the images[/color]
> in[color=green]
> > the database though...[/color]
>
> It is great that you have experience with it. I was going to suggest to[/color]
the[color=blue]
> OP that he seek out people doing this type of thing (whatever it is he is
> doing) so that he didn't just get responses based upon people taking 15
> seconds out to reply. I'll admit that believe he will be at least "as[/color]
well[color=blue]
> off" by keeping the images outside but I intended to ask him what he[/color]
thought[color=blue]
> the advantages might be for storing them in the database. I can't think[/color]
of[color=blue]
> many... that doesn't mean that we can't post "it will be easier" but is[/color]
that[color=blue]
> in fact a "fact"?
>
> Perhaps... how does he get 10,000 images into the database attached to the
> proper records?
>[color=green]
> > 1) The Application will be used to store documents in a central location
> > (this can apply to a web server, email application, windows application
> > etc). This will involve users selecting a document from their local[/color]
> machine[color=green]
> > and "uploading" it to the server.[/color]
>
> I would have guessed from the short description that users wouldn't[/color]
directly[color=blue]
> upload files. So that's interesting.
>[color=green]
> > 2) When the user wants to view the file, they query the server. At this
> > point, if there is no record in the database, the user can't get the[/color][/color]
file,[color=blue][color=green]
> > so effectively there is no file anymore (even if there is a orphan file
> > somewhere on the server that had its record deleted).[/color]
>
> I don't think I get this. But anyway, I would guess that a user could
> select only from records in the database. If it isn't in the database[/color]
then[color=blue]
> it doesn't qualify for downloading and/or viewing. It doesn't matter if[/color]
the[color=blue]
> an image is sitting in folder... I have images sitting in folders on my
> webserver, you can't get them :-)
>[color=green]
> > 3) If a user deletes a file from the server, it is deleted from the[/color]
> server,[color=green]
> > not the location that they originally uploaded it from.[/color]
>
> Seems reasonable to me.
>[color=green]
> > To respond to your comments:
> >[color=darkred]
> > > Synchronization for instance...
> > > if you delete the record you have
> > > effectively erased the image. Are we
> > > certain destroying the image is the goal?[/color]
> >
> > See point (3) and again, sorry for the assumption.[/color]
>
> We don't know that user routinely (if ever) keeps the images. Once
> submitted they are "safely stored in the image archive" so what's the[/color]
point?[color=blue]
> Are the users working inhouse or subscribers to some service? I don't[/color]
know[color=blue]
> who owns the images.
>[color=green][color=darkred]
> > > If images are duplicated (the
> > > "no image available" image for
> > > instance) then you have stored
> > > (possibly) hundreds of copies of that image.[/color]
> >
> > I would expect a bit of common sense on the part of the database schema[/color]
> and[color=green]
> > application design to handle these situations. To handle no image[/color]
> available,[color=green]
> > store Null and have a default image elsewhere. To handle multiple copies[/color]
> of[color=green]
> > the same image, implement the schema with a join table and implement the[/color]
> UI[color=green]
> > so that the user gets prompted if a similar image exists (based on other
> > data about the image).[/color]
>
> Seems reasonable.
>[color=green][color=darkred]
> > > Do you want to store
> > > .jpeg, .gif and .png in
> > > three separate columns?[/color]
> >
> > Again, a little bit of design intelligence would do here.[/color]
>
> Perhaps but maybe I didn't explain it correctly. I can choose (from a
> number of websites) to view movie trailers in one of three distinct[/color]
formats[color=blue]
> and often in low or high bandwidth versions. This means they have 6
> different copies of the same film stored. If it is an image database such
> that people can purchase and download the images it isn't hard to imagine
> that a thumbnail would be required. Probably a larger image and possibly
> another hi-definition version.
>
> see: http://pro.corbis.com/
>
> for information on image storage see:
> http://sunsite.berkeley.edu/Imaging/Databases/
>[color=green][color=darkred]
> > > Would you suggest the same thing if the
> > > guy was storing 20,000 video files?[/color]
> >
> > Probably not. They *did* state their requirements on this point in the
> > original post though. The reason why I wouldn't recommend it is because[/color][/color]
of[color=blue][color=green]
> > one of the con's mentioned in my first post (the part about maintaining[/color][/color]
a[color=blue][color=green]
> > large single file for backups etc.) would far outweigh the benefits of
> > storing in the database.[/color]
>
> I agree. That's why I'm doubtful that storing the 10K images directly in
> the database is a good idea. To be sure, it might be a great idea I just
> (so far) don't think so.
>[color=green][color=darkred]
> > > To conclude something
> > > with as little information as
> > > has been posted isn't typically a good idea...[/color]
> >
> > Point taken and I'll be more careful in the future. I hope you can do[/color][/color]
the[color=blue][color=green]
> > same before posting responses like your original one:[/color]
>
> Sorry, I thought yours was the thoughtful response. Again I probably[/color]
didn't[color=blue]
> make myself clear on that. You gave "reasons" and so many times people[/color]
just[color=blue]
> post "opinions" never offering a basis for why they think what they think.
>
> Which computer is best? <Blah Corp.> Oh that's great... why?
>[color=green][color=darkred]
> > > I can't see any particular
> > > advantage to storing the
> > > images in the database
> > > can you? I can think of
> > > a number of key reasons not to.[/color][/color]
>
> I see now... it was intended to be an invitation for discussion. Rather
> than post "I think this... or that" I thought I might find out what the[/color]
guy[color=blue]
> with problem had thought about so far. He could be doing this for a large
> corporation with a dedicated server and SQL Server or he could be putting
> something together for the "dungeons and dragons" role-playing game he[/color]
hosts[color=blue]
> on a free internet site. I have no idea the kind of money or equipment[/color]
(or[color=blue]
> expertise) he has at his disposal.
>[color=green]
> > Thanks for the discussion. Hopefully I'll learn not to make assumptions[/color]
> like[color=green]
> > this in the future.[/color]
>
> It isn't you Trev... it is the way people post stuff in general. That's[/color]
one[color=blue]
> of the reasons "which computer language is best" type questions generate[/color]
so[color=blue]
> much heat and so little light. Few people ask "what do you want to do[/color]
with[color=blue]
> it" before mentioning the language they know.
>
> Take care,
> Tom
>
>[/color]

re: Image Question

Hi Trev,

I would have been so lucky if Herfried would give an answer on this. :-))

But I am lucky with your answer anyway you understand, but why I did wanted
Herfried to answer was because of another reason. (He gives mostly greath
answers, but when it is about databases I told him he can better skip that a
while untill he real knows it).

My problem is, that I very good know how to get a Jpeg it a database, but I
want to cut those images also in a format that is more properiate for my
needs.

And I also heard Herfried saying that when you translate a gif to a bytearea
that you then lose half of your pixel information. (I believe that about
media Herfried knows it very well) And there is not alone Jpeg and Gif, so I
am in doubt if I gonna do that, so I stopped it a short while untill I see
some better documentation.

(On MSDN it is only in C# as far as I could see and very slight (encoding is
the keyword)).

I know very good how to put and get blobs in a database (Access, SQL
whatever) by the way.

It is the "correct" conversion from real quality images to Bitmaps and back
that botters me.

But a lot of thanks for your offer again, I remember it me when I start
again.

(I started with some greath help from Fergus, he gave me the start and then
I developped from that much further (not the database part, that I did know
already)).

Cor

re: Image Question

No problem Cor. I thought it may have been a problem with the BLOBS. I
haven't got much experience with image conversion, so can't be of any use to
you. I would point you in the direction of
microsoft.public.dotnet.framework.drawing though...

Best of luck,

Trev.


"Cor" <non@non.com> wrote in message
news:OyEyW478DHA.2832@tk2msftngp13.phx.gbl...[color=blue]
> Hi Trev,
>
> I would have been so lucky if Herfried would give an answer on this. :-))
>
> But I am lucky with your answer anyway you understand, but why I did[/color]
wanted[color=blue]
> Herfried to answer was because of another reason. (He gives mostly greath
> answers, but when it is about databases I told him he can better skip that[/color]
a[color=blue]
> while untill he real knows it).
>
> My problem is, that I very good know how to get a Jpeg it a database, but[/color]
I[color=blue]
> want to cut those images also in a format that is more properiate for my
> needs.
>
> And I also heard Herfried saying that when you translate a gif to a[/color]
bytearea[color=blue]
> that you then lose half of your pixel information. (I believe that about
> media Herfried knows it very well) And there is not alone Jpeg and Gif, so[/color]
I[color=blue]
> am in doubt if I gonna do that, so I stopped it a short while untill I see
> some better documentation.
>
> (On MSDN it is only in C# as far as I could see and very slight (encoding[/color]
is[color=blue]
> the keyword)).
>
> I know very good how to put and get blobs in a database (Access, SQL
> whatever) by the way.
>
> It is the "correct" conversion from real quality images to Bitmaps and[/color]
back[color=blue]
> that botters me.
>
> But a lot of thanks for your offer again, I remember it me when I start
> again.
>
> (I started with some greath help from Fergus, he gave me the start and[/color]
then[color=blue]
> I developped from that much further (not the database part, that I did[/color]
know[color=blue]
> already)).
>
> Cor
>
>[/color]

re: Image Question

* "Tom Leylan" <gee@iamtiredofspam.com> scripsit:[color=blue]
> It might but that would depend upon "deployment" and it wasn't mentioned.
> Nor was the database.
>
> If a solution is faster, easier and more reliable it seems like a good
> reason to use it but I'm not certain we know that putting 10,000 images in a
> database is any of those things.[/color]

It depends on the circumstances.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

* "Cor" <non@non.com> scripsit:[color=blue]
> You know I am busy with this.
>
> The trouble I have now.
> I cannot convert all formats to and from the database.
> I have the idea that I loose information converting it from and to
>
> Can you help me to overcome this or tell me what is wrong or right of above?[/color]

Mhm... Why not store the files as BLOBs?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

Herfried,
[color=blue][color=green]
> > The trouble I have now.
> > I cannot convert all formats to and from the database.
> > I have the idea that I loose information converting it from and to
> >
> > Can you help me to overcome this or tell me what is wrong or right of[/color][/color]
above?[color=blue]
>
> Mhm... Why not store the files as BLOBs?
>[/color]
1. The question was, do you have the routine to convert all image formats to
blobs,
2. Do you kow if you loose image information from converting to and from
blobs.

Cor

re: Image Question

* "Cor" <non@non.com> scripsit:[color=blue]
> 1. The question was, do you have the routine to convert all image formats to
> blobs,[/color]

Yes. Simply store the whole file.
[color=blue]
> 2. Do you kow if you loose image information from converting to and from
> blobs.[/color]

You won't loose information when storing the whole image file.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

Hi Herfried,

Not that it is really important but now you make me curious.
(I told you that I did know very few about imaging, it is something more but
not what I wanted it to be)

I have a gif file

I load that as an image
I stream that to a bytearea (Here I can not loose data I think)
I save that as a blob (that is the part where I am sure to loose no data)
I read that as a blob (no problem as far as I can see it are bytes)
I stream that to an image (I think that here is also no problem)
I save that as a png

And then there is no data lost?

Same question with the difference the last sentence because the previous
sounds to me impossible.

I save that as a gif

Is in the last situation is every bit from the created gif file the same as
the original?

Cor

re: Image Question

* "Cor" <non@non.com> scripsit:[color=blue]
> Not that it is really important but now you make me curious.
> (I told you that I did know very few about imaging, it is something more but
> not what I wanted it to be)
>
> I have a gif file
>
> I load that as an image
> I stream that to a bytearea (Here I can not loose data I think)
> I save that as a blob (that is the part where I am sure to loose no data)
> I read that as a blob (no problem as far as I can see it are bytes)
> I stream that to an image (I think that here is also no problem)
> I save that as a png[/color]

Why do you want to save it as a PNG?
[color=blue]
> And then there is no data lost?
>
> Same question with the difference the last sentence because the previous
> sounds to me impossible.
>
> I save that as a gif[/color]

Why? Just save the byte array to a GIF file.
[color=blue]
> Is in the last situation is every bit from the created gif file the same as
> the original?[/color]

Yes.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

Hi Herfried,

Thanks,

Do you have for me managed code sample for this?
[color=blue]
> Why? Just save the byte array to a GIF file.
>[/color]
Because I never saw that posibility, so maybe I do something to much.

Cor

re: Image Question

Cor:

If saving binary data in a blob could result in lost or modified data it
would be virtually useless. I can't imagine a "database" that decided on
your behalf what was and was not "information."

Tom

"Cor" <non@non.com> wrote in message
news:emRsAuF9DHA.440@TK2MSFTNGP10.phx.gbl...[color=blue]
> Herfried,
>[color=green][color=darkred]
> > > The trouble I have now.
> > > I cannot convert all formats to and from the database.
> > > I have the idea that I loose information converting it from and to
> > >
> > > Can you help me to overcome this or tell me what is wrong or right of[/color][/color]
> above?[color=green]
> >
> > Mhm... Why not store the files as BLOBs?
> >[/color]
> 1. The question was, do you have the routine to convert all image formats[/color]
to[color=blue]
> blobs,
> 2. Do you kow if you loose image information from converting to and from
> blobs.
>
> Cor[/color]

re: Image Question

* "Cor" <non@non.com> scripsit:[color=blue]
> Do you have for me managed code sample for this?[/color]

That's a question for the ASP.NET group. Currently, I don't have a
sample.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

Hi Herfried,
[color=blue]
> That's a question for the ASP.NET group. Currently, I don't have a
> sample.
>[/color]

Reading a gif file in a byte area?

You asked me why I did not do that, and than I said I did not know how to do
that with managed code.

And no

:-)

So serious, was it late yesterday Herfried?

Cor

re: Image Question

Hi Tom,
[color=blue]
> If saving binary data in a blob could result in lost or modified data it
> would be virtually useless. I can't imagine a "database" that decided on
> your behalf what was and was not "information."[/color]

No for showing a picture on a form or a thumbnail it can be very effective.
I did not check it, however my idea was that an 32Mb Tiff picture would not
fit easy as a field in a database.

But if you have expieriences with putting that kind of pictures in a
database I would glad hear about those expiriences.

Cor

re: Image Question

Cor,

I did mention that I didn't know too much about Image conversion, but here
are a few conditions under which you may loose data:

1) Changing from a "lossless" format to a "lossy" format (e.g. Gif to Jpeg -
Gif stores an exact replication of the image data, but JPEG compression
results in smaller sizes because it discards data that it thinks isn't
important)

2) Changing the color depth of the image (e.g. 24 bit PNG to 8 bit gif - Gif
only stores 256 colors, PNG can store 8 bit or 24 bit (or higher) images.

3) Changing between formats where the destination format doesn't support
transparent colors.

4) Changing between a vector format to a bitmap format (e.g. wmf to gif)

5) Changing the resolution of the image.

6) Changing from a specialized format that stores data other than image data
(e.g. photographers name) or a format that can hold multiple images (e.g.
Icon) to another format that doesn't support these features.


These should be the only types of conditions that you could "loose" data.
You shouldn't be loosing any by storing it in a BLOB (assuming there's no
bugs in your database code ;)

From what I understand from your conversion, changing from GIF to PNG
shouldn't cause you to loose any data (although the PNG compression could
result in fewer bytes in some cases)

A better group for this might be microsoft.public.dotnet.framework.drawing
or a more generic image convcersion group as you problem seems to be with
changing image formats, not the storing of data in BLOBS or other files.


Hope this helps,

Trev.




"Cor" <non@non.com> wrote in message
news:O17VgFI9DHA.3404@TK2MSFTNGP09.phx.gbl...[color=blue]
> Hi Herfried,
>
> Not that it is really important but now you make me curious.
> (I told you that I did know very few about imaging, it is something more[/color]
but[color=blue]
> not what I wanted it to be)
>
> I have a gif file
>
> I load that as an image
> I stream that to a bytearea (Here I can not loose data I think)
> I save that as a blob (that is the part where I am sure to loose no data)
> I read that as a blob (no problem as far as I can see it are bytes)
> I stream that to an image (I think that here is also no problem)
> I save that as a png
>
> And then there is no data lost?
>
> Same question with the difference the last sentence because the previous
> sounds to me impossible.
>
> I save that as a gif
>
> Is in the last situation is every bit from the created gif file the same[/color]
as[color=blue]
> the original?
>
> Cor
>
>[/color]

re: Image Question

* "Cor" <non@non.com> scripsit:[color=blue][color=green]
>> That's a question for the ASP.NET group. Currently, I don't have a
>> sample.[/color]
>
> Reading a gif file in a byte area?
>
> You asked me why I did not do that, and than I said I did not know how to do
> that with managed code.[/color]

Sorry, misread your post. Have a look at the 'MemoryStream' class.
You can create a memory stream from a byte array and then use
'Image.FromImage' to construct an image from the data. Alternatively,
you can use the 'BinaryWriter' to write the byte array to disk.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

Cor,

"Lossy compression" that you voluntarily choose to use is one thing...
having the database decide that it will "lose data" by dropping some bytes
from a binary stream is quite another. A blob "must" return whatever you
store in it unchanged. Keep in mind it doesn't know why you are storing the
data, it doesn't know it is an image destined for a web page.

One of the problems you encounter when very large binary fields are stored
is a maintenance issue. Not a big deal if you mostly add images but (as far
as I know) if you update and delete images a lot the database becomes filled
with old versions of the data which have to be purged periodically.

Tom

"Cor" <non@non.com> wrote in message
news:OpU5AJM9DHA.2460@TK2MSFTNGP09.phx.gbl...[color=blue]
> Hi Tom,
>[color=green]
> > If saving binary data in a blob could result in lost or modified data it
> > would be virtually useless. I can't imagine a "database" that decided[/color][/color]
on[color=blue][color=green]
> > your behalf what was and was not "information."[/color]
>
> No for showing a picture on a form or a thumbnail it can be very[/color]
effective.[color=blue]
> I did not check it, however my idea was that an 32Mb Tiff picture would[/color]
not[color=blue]
> fit easy as a field in a database.
>
> But if you have expieriences with putting that kind of pictures in a
> database I would glad hear about those expiriences.
>
> Cor[/color]

re: Image Question

Hi Herfried,
[color=blue]
> Sorry, misread your post. Have a look at the 'MemoryStream' class.
> You can create a memory stream from a byte array and then use
> 'Image.FromImage' to construct an image from the data. Alternatively,
> you can use the 'BinaryWriter' to write the byte array to disk.[/color]

Here a link with some answers that are given in this newsgroup on that.

http://groups.google.com/groups?hl=e...languages.vb.*

But you told me to do it this way and that I did find very intresting[color=blue]
>Why? Just save the byte array to a GIF file.[/color]

I could not make the URL shorter.

:-))))))))

Cor

re: Image Question

* "Cor" <non@non.com> scripsit:[color=blue][color=green]
>> Sorry, misread your post. Have a look at the 'MemoryStream' class.
>> You can create a memory stream from a byte array and then use
>> 'Image.FromImage' to construct an image from the data. Alternatively,
>> you can use the 'BinaryWriter' to write the byte array to disk.[/color]
>
> Here a link with some answers that are given in this newsgroup on that.[/color]

I know you already know the answer to your question!

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

re: Image Question

Hi Trev,

The meaning of this thread is not the information, but the way we give
answers in this newsgroup.

But thanks for the information, because it added something again to mine and
I it makes things I was not sure of more sure because you read the same.
(It interest me, so it is not spoiled information)

And when I next time have a question like this, I take your advice and go
directly to Bob Powell in the drawing group.

And read my last answer to Herfried. Than all comes more clear.

:-)

Cor
[color=blue]
> I did mention that I didn't know too much about Image conversion, but here
> are a few conditions under which you may loose data:
>
> 1) Changing from a "lossless" format to a "lossy" format (e.g. Gif to[/color]
Jpeg -[color=blue]
> Gif stores an exact replication of the image data, but JPEG compression
> results in smaller sizes because it discards data that it thinks isn't
> important)
>
> 2) Changing the color depth of the image (e.g. 24 bit PNG to 8 bit gif -[/color]
Gif[color=blue]
> only stores 256 colors, PNG can store 8 bit or 24 bit (or higher) images.
>
> 3) Changing between formats where the destination format doesn't support
> transparent colors.
>
> 4) Changing between a vector format to a bitmap format (e.g. wmf to gif)
>
> 5) Changing the resolution of the image.
>
> 6) Changing from a specialized format that stores data other than image[/color]
data[color=blue]
> (e.g. photographers name) or a format that can hold multiple images (e.g.
> Icon) to another format that doesn't support these features.
>
> These should be the only types of conditions that you could "loose" data.
> You shouldn't be loosing any by storing it in a BLOB (assuming there's no
> bugs in your database code ;)
>
> From what I understand from your conversion, changing from GIF to PNG
> shouldn't cause you to loose any data (although the PNG compression could
> result in fewer bytes in some cases)
>
> A better group for this might be microsoft.public.dotnet.framework.drawing
> or a more generic image convcersion group as you problem seems to be with
> changing image formats, not the storing of data in BLOBS or other files.
>
> Hope this helps,
>
> Trev.
>[/color]

re: Image Question

> And read my last answer to Herfried. Than all comes more clear.

lol. Guess I didn't pick up on the subtleness in your other posts ;)

Trev.



"Cor" <non@non.com> wrote in message
news:u3V2KkM9DHA.488@TK2MSFTNGP12.phx.gbl...[color=blue]
> Hi Trev,
>
> The meaning of this thread is not the information, but the way we give
> answers in this newsgroup.
>
> But thanks for the information, because it added something again to mine[/color]
and[color=blue]
> I it makes things I was not sure of more sure because you read the same.
> (It interest me, so it is not spoiled information)
>
> And when I next time have a question like this, I take your advice and go
> directly to Bob Powell in the drawing group.
>
> And read my last answer to Herfried. Than all comes more clear.
>
> :-)
>
> Cor[/color]