I wouldn't know how likely it is to crash, but it will happen eventually, nothing is perfect :( ---- Andrei Cojocaru [EMAIL PROTECTED] ----- Original Message ----- From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]> To: "Andrei Cojocaru" <[EMAIL PROTECTED]> Cc: "Sameer Maggon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, May 20, 2002 9:54 AM Subject: Re: store JPG in MySQL DB
> > Hi Andrei > > > well, let's just say if it crashes it will mean longer recovery time, you > > are adding extra processing to the SQL server to handle data it wasn't meant > > to handle, storing it in the file system has the main advantage that if any > > Yeah, that "crash" thing really scares me. I guess you're right about > . And how likely that it might crash? > > > > > changes occurs you can change it faster + easier, besides a database is > > supposed to store essential data so you don't overload it with things that > > can be calculated or made pretty easily, and I'd say an image fits under > > that category. And last time I checked my local hard drive is faster than my > > network connection :) The choice is yours, but if you have heavy load, I > > wouldn't use it. > > ---- > > Andrei Cojocaru > > [EMAIL PROTECTED] > > ----- Original Message ----- > > From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]> > > To: "Andrei Cojocaru" <[EMAIL PROTECTED]> > > Cc: "Sameer Maggon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Monday, May 20, 2002 9:37 AM > > Subject: Re: store JPG in MySQL DB > > > > > > > > > > Hi Andrei > > > > > > > If I were you I would not store a binary file into the database, I'd > > store > > > > the information required to fetch it from somewhere else like the mySQL > > > > manual suggests > > > > > > But what difference does it make? Besides, I found storing it in the DB > > > more convenient than in the file system. In that case, you will have to > > > keep track ofboh the files in the file system, and their meta data in the > > > mysql tables. > > > > > > Please advise > > > > > > > > > > > > > ---- > > > > Andrei Cojocaru > > > > [EMAIL PROTECTED] > > > > ----- Original Message ----- > > > > From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]> > > > > To: "Sameer Maggon" <[EMAIL PROTECTED]> > > > > Cc: <[EMAIL PROTECTED]> > > > > Sent: Monday, May 20, 2002 12:26 AM > > > > Subject: Re: store JPG in MySQL DB > > > > > > > > > > > > > > > > > > For real-life example, check out http://cdbaza.ultracgis.com, and > > check > > > > > out the filename > > > > > of the thumbnails images. I'm SELECTing those images from the MySQL > > > > > database. > > > > > > > > > > That's how it's done: > > > > > > > > > > 1_ Create a table to store your JPGs, and the column that holds JPG > > data > > > > > should be declared as BLOB > > > > > > > > > > CREATE TABLE images ( > > > > > image_id INT UNSIGNED NOT NULL AUT_INCREMENT PRIMARY KEY, > > > > > image BLOB NOT NULL > > > > > ); > > > > > > > > > > > > > > > 2_ Now you are ready to load the JPG data into the image column. > > > > > I use Perl to open the JPG file and dump the contents into the > > table, > > > > > and the resulting query looks something like: > > > > > > > > > > INSERT INTO images SET image="here goes contents of the JPG file"; > > > > > > > > > > Perl code that does this job would look like: > > > > > > > > > > local ($/); > > > > > sysopen (JPG, "test.jpg", O_RDONLY) or die $!; > > > > > $dbh->do(qq|INSERT INTO images SET image=?|, undef, <JPG>); > > > > > close (JPG); > > > > > > > > > > Sorry if you don't know Perl, but you should be able to do similar > > > > > thing in any other language you might be using > > > > > > > > > > > > > > > > > > > > Good luck! > > > > > > > > > > -- > > > > > Sherzod > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > Before posting, please check: > > > > > http://www.mysql.com/manual.php (the manual) > > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > > To unsubscribe, e-mail > > > > <[EMAIL PROTECTED]> > > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
