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

	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	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 (3000 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 (2994 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 (2992 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 (2987 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 (2985 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? 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 (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 (2981 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 (2979 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 (2974 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

Announcements     PerlGuru Announcements Perl Programming Help     Frequently Asked Questions     Beginner     Intermediate     Advanced     Regular Expressions     mod_perl     DBI     Win32 Programming Help Fun With Perl     Perl Quizzes - Learn Perl the Fun Way     Perl Golf     Perl Poetry Need a Custom or Prewritten Perl Program?     I need a program that...     I Need a Programmer for Freelance Work     Throw Down The Gauntlet General Discussions     General Questions     Feedback     Tutorial/Article Suggestions for The Learning Cent     Internet Security Other Programming Languages     Javascript     PHP

Search this forum this category all forums for All words Any words Whole Phrase (options)

Powered by Gossamer Forum v.1.2.0

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