[ale] OT: MySQL Blobs

[F. Grant Robertson]

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).

-G

-----Original Message-----
From: ale-admin at ale.org [mailto:ale-admin at ale.org]On Behalf Of George
To: ale at ale.org
Carless
Sent: Thursday, July 10, 2003 8:23 AM
To: ale at ale.org
Subject: Re: [ale] OT: MySQL Blobs


> I'm working on a media center for home and would like to store
> media files such as DivX and MP3 in MySQL as blobs.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.490 / Virus Database: 289 - Release Date: 6/16/2003

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