images in db

[Jenna Fox]

Another option, which Rails has a lot of good documentation on, is to  
create a row in your database which represents the image file, and  
contains all the related meta data as well as a unique id number, and  
then just keep the actual images in the filesystem named #.jpeg or  
some such thing, where the # is the row ID number. This is very  
common, and good practice for speed as well, because it allows you to  
eliminate variable width columns in the table in many cases, which  
gives your database server software an advantage in being able to  
accurately guess where the next row begins, and skip through without  
parsing all the data in every row leading up to it.


On 06/02/2009, at 10:14 AM, Cornelius Jaeger wrote:

> cheers john
>
> hm, seems strange eh, you'd think this is something that is just  
> possible.
> many thanks for the link, i'll work it tonight.
> alternatively i'll have to copy the image to the file system after  
> all and serve it from the webserver.
>
> cheers
>
> cornelius
>
> On 03.02.2009, at 21:32, John Beppu wrote:
>
>> Roland just showed you how to inline it.
>>
>> Here's a little article on the technique he's using:
>>
>> http://jimbojw.com/wiki/index.php?title=Data_URIs_and_Inline_Images
>>
>> However, as Jenna said, this technique doesn't work in IE.  Her  
>> first suggestion is probably the path of least resistance.
>>
>> --beppu
>>
>> On Tue, Feb 3, 2009 at 5:35 AM, Cornelius Jaeger <cjlists at visualfood.ch 
>> > wrote:
>> Hi Jenna, Roland
>>
>> Thanks for your responses.
>> How can I get the image inline in the html, rather than downloading  
>> it to the user?
>> I'm not at all sure how to use markaby to stream the image data  
>> into something the img tag will understand.
>> Many Thanks for helping
>>
>> Cornelius
>>
>>
>>
>>
>> On 03.02.2009, at 01:58, Jenna Fox wrote:
>>
>> Make a controller with a get method to retrieve the image, then,  
>> have some code like this in it, supposing image_data is a string or  
>> something:
>>
>> headers['Content-Type'] = 'image/png'
>> headers['Content-Length'] = image_data.length.to_s
>> return image_data
>>
>>
>> On 03/02/2009, at 10:58 AM, Cornelius Jaeger wrote:
>>
>> hi all
>>
>> just working on my first camping hack and new to ruby as well.
>> i've figured some things out and uploading images into the  
>> database, but i'm not sure how to get the data displayed in the  
>> browser.
>> i'd like to stream it straight from the db, not copy it to the fs  
>> first.
>> obviously img(:src => file_data) doesn't work.
>> any pointers or reading assignments would be v. welcome.
>> many thanks
>>
>> cornelius
>> _______________________________________________
>> Camping-list mailing list
>> Camping-list at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/camping-list
>>
>> _______________________________________________
>> Camping-list mailing list
>> Camping-list at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/camping-list
>>
>> _______________________________________________
>> Camping-list mailing list
>> Camping-list at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/camping-list
>>
>> _______________________________________________
>> Camping-list mailing list
>> Camping-list at rubyforge.org
>> http://rubyforge.org/mailman/listinfo/camping-list
>
> _______________________________________________
> Camping-list mailing list
> Camping-list at rubyforge.org
> http://rubyforge.org/mailman/listinfo/camping-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://rubyforge.org/pipermail/camping-list/attachments/20090206/0832a35d/attachment.html>