shusseina wrote:
[...]
>How do I store images in my sqlite3
> database?  

There has been lots of discussion on ths very topic.  Much of it is 
recent (i.e., in the last month or two).  Search the list archives.

Now to your question.  Sqlite is inappropriate for production, and you 
probably shouldn't really be using it for development.  Use a real DB (I 
recommend PostgreSQL).

> Should the (database) column be of type BINARY?  

No.  Image data does not belong in the DB.  Put it in the filesystem 
instead, and just store the filename in a text field in the DB.

> Is there a
> Rails helper for uploading images via web page form?

There's the Paperclip plugin, and also attachment_fu.  I've never used 
either, but more people seem to like Paperclip.

> 
> Hope the above makes some sense to somebody.
> 
> Thanks
> Steve

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
[email protected]
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to