[thelist] media/image management

Chris W. Parker cparker at swatgear.com
Mon Jun 30 14:54:50 CDT 2003

Steve Lewis <mailto:nepolon at worlddomination.net> wrote:

> It occurs to me that you might be better off storing the MIME type
> instead.

Good idea. I'm on Linux so I think this can be achieved using the file command?

> It is useful to store a filename for the item 
> in your media table regardless of whether or not the actual media item 
> is in the database or on the filesystem because then you can provide a 
> meaningful/traditional filename to users who wish to download the item.

This is what will be stored in the 'url' field. To be more specific the entire path will be stored in that field, not just the filename.

> You would generally do well under most DB management systems to store
> the binary data in a separate table if you are storing them in the
> database for performance reasons.

I'm a bit confused by this. I said I *didn't* want to store the files within the database but rather on the servers filesystem instead. Are you suggesting I store the files within the database, or was I not clear? (I tend not to be.)


More information about the thelist mailing list