Re: How to display a BLOB object in VIEW

I agree with your points that storing files as files on disk is better than putting them into a database column; there are many articles written on this topic that agree with this assessment. However, I must disagree with this one point:

On Jan 20, 2011, at 16:22, euromark wrote:

> - a) 33% more space needed (base64encoded)

There's no reason to store them base-64 encoded (or encoded in any way) in the database; they're just stored as blobs -- binary data -- and I don't know of a reason why the database engine wouldn't just natively store that, taking up roughly the same amount of space as it would to store it as a regular file.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php