[ale] OT: MySQL Blobs

Christopher Fowler cfowler at outpostsentinel.com
Thu Jul 10 10:00:22 EDT 2003


On Thu, Jul 10, 2003 at 09:50:43AM -0400, F. Grant Robertson wrote:
> I've used it for storing jpgs... it's a clean solution but, it is a tad bit slower. 
> 
> Your going to have major problems storing video.. You could do it with Oracle, but mysql's maximum blob size (and 'packet' size as well) become serious limitations. You can have large DB's, just not really enormous rows. (unless something major has changed). You _might_ get away with mp3's.. but high quality or long files would give you fits as well. I can't remember what the magic number was but I seem to remember 8 or 16 megs.  
> 
> I was writing some code around this exact thing a while back, and what I came up with (I'm sure someoen had done it before but, it was original to me) was to not only store the path to the file, and it's ID3 information, but to also store an MD5 sum of it. That way, you can 'reindex' the files and eliminate duplicate entries. I had some alpha code working pretty well, at least the indexer side(perl).. never had time to play with an interface(most likely php).

Great points.  I'll have to take this route.  The next soultion is where I 
should store the database on files to eliminate any possible corruption on
power off of the device.  

Chris

_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale





More information about the Ale mailing list