Re: [fw-db] Getting JPEGs from DB

Sort of like your argument against a Zend_Validate_Unique?  ;-D

-Matt

On Thu, Oct 23, 2008 at 9:33 AM, Bill Karwin <bill@karwin.com> wrote:

On Oct 23, 2008, at 8:22 AM, Matthew Ratzloff wrote:

You really don't want to do this.  Store the files on the file system and keep data about them in the database instead.  Use a rewrite map or, better, a series of rewrite rules to serve the files directly from your web server instead of using passthrough.  That will bypass your problem entirely and be much more scalable.

There are good reasons for storing images in a BLOB column in the database.
There are also good reasons for storing images on the filesystem and referencing them by filename.

You shouldn't make unequivocal statements that either solution is _always_ better or _always_ worse, without understanding the application that the developer is designing.

Thirty lashes with a wet noodle!  :-)

Regards,
Bill Karwin