[ale] OT: MySQL Blobs

[Christopher Fowler]

On Thu, Jul 10, 2003 at 01:23:25PM +0100, George Carless wrote:
> > 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.
> 
> This is generally a fairly horrific idea.  Why not just store pointers to
> the files (i.e. their locations) in the database?  Storing binary files in
> blobs like this is something which most of us go through because of the
> 'cool'(/geek) factor, before realising that it's a nasty performance hit
> for (in most cases) no gain.


Valid point.  Soring the pathname is a great idea.  The idea is to eventullay
store the databased on a protected spot safe from power loss on the box. 
I do not want to store any files on a R/W filesystem that requires a flush
and unmount on shutdown.  

Keep the ideas coming.


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