what kind of data can go into a mysql database? - Page 2

Sam Granger · 02-23-2008, 11:26 PM

Storing files in DB? I'm no expert so I might be mistaken with what I'm about to say, sorry if I am.

Connecting to the DB server, logging in, getting data from sql and outputting it in a file each time to download uses a lot more server resources than just going to a static file to download.

stewart · 02-24-2008, 12:01 AM

Sorry, but no. And also last I knew, storing and receiving binary data is just a bit different than retrieving a 255 character string.

Speeple · 02-25-2008, 04:23 PM

This looks interesting from the perspective of using MySQL to store large sets of binary data:
Scalable BLOB Streaming Infrastructure for MySQL

flyingbuddha · 02-25-2008, 04:58 PM

I once used to build databases that stored files, instead of references, the problem I experienced was when you stored several large files, you start to weigh the db down and it can become unweildy, though saying that, I stored them in longtext fields, not blob's, don't know if that makes a difference?

Nor · 02-25-2008, 05:03 PM

So you telling me I can read a image file and put the image data into a query and if I use the correct query the image will be fine displaying?

flyingbuddha · 02-27-2008, 09:24 AM

Nor, you could do a:

PHP Code:


			
$data = file_get_contents('image.jpg')

and store $data in the record, then using the correct headers, output the data in a script - that way the image will be output. All you need to do then is call that script using <img src="script.php"...

Nor · 02-29-2008, 04:04 PM

I see :), thanks.

EyeDentify · 03-04-2008, 10:51 AM

And if you store binary data in a BLOB column remember to use base64_encode() and base64_decode() on that data.

Though the data will be larger when encoded it keeps it somewhat safe from corruption. At least what i have read on PHP.

/EyeDentify