CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Intermediate:
storing a picture file in a BLOB

 



$0.05$
Novice

Mar 27, 2002, 3:00 PM

Post #1 of 8 (3589 views)
storing a picture file in a BLOB Can't Post

in mysql, is it possible to store an image file (*.jpg, *.gif) into a BLOB?

and if so, how??


$0.05$
Novice

Mar 28, 2002, 5:33 AM

Post #2 of 8 (3583 views)
Re: [$0.05$] storing a picture file in a BLOB [In reply to] Can't Post

well, is there any way to store an image file in a mysql database?


Paul
Enthusiast

Mar 28, 2002, 9:20 AM

Post #3 of 8 (3581 views)
Re: [$0.05$] storing a picture file in a BLOB [In reply to] Can't Post

Patience is a virtue :)

Yep it can be done but why would you want to?

VBulletin does it I think. Seems a bit of a waste of time.


Jasmine
Administrator

Mar 28, 2002, 10:48 AM

Post #4 of 8 (3576 views)
Re: [$0.05$] storing a picture file in a BLOB [In reply to] Can't Post

And a quick search at [url=http://google.com]Google turned up this tutorial with examples: [url=http://www.james.rcpt.to/programs/mysql/]http://www.james.rcpt.to/programs/mysql/


Jasmine
Administrator

Mar 28, 2002, 10:50 AM

Post #5 of 8 (3574 views)
Re: [RedRum] storing a picture file in a BLOB [In reply to] Can't Post

[ RedRum ] - there are certain instances where storing images in a db is useful. For example, storing images in the db would permit a logged in user access only to the files they have permission to access.

Surely someone will say that htaccess will work fine, but let's say that you have a variety of user levels, and each level has a access to increasingly more images or higher quality images. Would you create a subdirectory for each group of images and make the users get that dumb browser popup window for each subdirectory? Or would you copy all images from a lesser level to the higher level? Smile

I don't know how vBulletin uses their stored images, if only certain groups or levels of user can view images, then it makes sense. If they're just storing their global icons or images that anyone can see, well, I agree that it doesn't seem overly useful Smile


(This post was edited by Jasmine on Mar 28, 2002, 10:55 AM)


Paul
Enthusiast

Mar 28, 2002, 11:01 AM

Post #6 of 8 (3570 views)
Re: [Jasmine] storing a picture file in a BLOB [In reply to] Can't Post

Just beware that tables have a 2GB limit


PerlKid
stranger

Mar 28, 2002, 11:09 AM

Post #7 of 8 (3568 views)
Re: [RedRum] storing a picture file in a BLOB [In reply to] Can't Post

that all depends on your operating system... http://www.mysql.com/doc/T/a/Table_size.html
--Philip
FuzzyLogic at PerlMad dot com


$0.05$
Novice

Mar 28, 2002, 12:53 PM

Post #8 of 8 (3563 views)
Re: [RedRum] storing a picture file in a BLOB [In reply to] Can't Post

thanks a lot guys

ill take a look at all that stuff right now Smile

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives