how i can show a image stored in a blob field in my database mysql ?
this is my controller http://www.pastie.org/556814
http://www.railsbrain.com/api/rails-2.3.2/doc/index.html?a=M000196&name=send_data
-Rob
Rob Biedenharn http://agileconsultingllc.com Rob@AgileConsultingLLC.com
Ricardo wrote:
how i can show a image stored in a blob field in my database mysql ?
This is a FAQ, and the answer is "save yourself years of torture and agony by using Paperclip, and never again think of storing an image inside a blob". There are just so many reasons that is wrong, beginning with the simple fact that your web server will serve image files directly from your hard drive, and both of them are tuned to do this efficiently, unlike Ruby and MySQL.
I agree with Philip - definately try Paperclip and avoid using BLOB columns for file attachments.
I did some work recently on getting Paperclip to work with BLOBs; if you do need to store files in a database table for some reason (e.g. legacy data, security, etc.) then you might want to read this: http://patshaughnessy.net/2009/5/29/paperclip-sample-app-part-3-saving-file-attachments-in-a-database-blob-column
- pat
