Hi, I''d like to make a demo version of my app available, but I''m not ready to get into database stuff, yet. Has anyone ever deployed with sqlite (what I used to develop my app)? If so, what hosting service(s) would you recommend? Thanks, Lille -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Philip Hallstrom
2010-Jul-09 16:14 UTC
Re: deployment question: has anyone deployed w. sqlite?
> I''d like to make a demo version of my app available, but I''m not ready > to get into database stuff, yet. Has anyone ever deployed with sqlite > (what I used to develop my app)? If so, what hosting service(s) would > you recommend?Well, if it''s a demo, and you''re not really into database stuff... I would be inclined to setup a developer account on heroku and let it use PostgreSQL. Unless you''ve done some sqlite-only stuff it shouldn''t matter what the database is. Otherwise... find somewhere that has the sqlite ruby gem installed and go crazy. -philip -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
I would second Heroku. I just manually deployed my first app (ubuntu server/nginx/passenger) after using heroku for some time -- be good to yourself, unless you really must deploy it yourself, try heroku. On 7/9/10, Philip Hallstrom <philip-LSG90OXdqQE@public.gmane.org> wrote:>> I''d like to make a demo version of my app available, but I''m not ready >> to get into database stuff, yet. Has anyone ever deployed with sqlite >> (what I used to develop my app)? If so, what hosting service(s) would >> you recommend? > > Well, if it''s a demo, and you''re not really into database stuff... I would > be inclined to setup a developer account on heroku and let it use > PostgreSQL. Unless you''ve done some sqlite-only stuff it shouldn''t matter > what the database is. > > Otherwise... find somewhere that has the sqlite ruby gem installed and go > crazy. > > -philip > > -- > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- Sent from my mobile device -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Marnen Laibow-Koser
2010-Jul-09 20:24 UTC
Re: deployment question: has anyone deployed w. sqlite?
Lille wrote:> Hi, > > I''d like to make a demo version of my app available, but I''m not ready > to get into database stuff, yet.Then you''re not ready to make a demo version available. You can''t write DB-driven apps if you''re afraid of the DB.> Has anyone ever deployed with sqlite > (what I used to develop my app)? If so, what hosting service(s) would > you recommend?Don''t do that. SQLite is not suitable for production Web apps, since it doesn''t handle concurrency issues very well. (And I agree that Heroku totally rocks.)> > Thanks, > > Lille-- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Philip Hallstrom
2010-Jul-09 20:42 UTC
Re: Re: deployment question: has anyone deployed w. sqlite?
>> Has anyone ever deployed with sqlite >> (what I used to develop my app)? If so, what hosting service(s) would >> you recommend? > > Don''t do that. SQLite is not suitable for production Web apps, since it > doesn''t handle concurrency issues very well.Just to play devil''s advocate... sqlite is fine for production web apps that are almost entirely read only. SQLite falls over when trying to handle concurrent writes though. So.. if your app doesn''t get any writes, or gets so few it doesn''t matter... or... is a demo app only viewed under controlled situations... it may work fine. But still... I''d recommend something else. Hate to have a couple of demos going on and have it slow down on you. -philip -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Greg Donald
2010-Jul-09 21:00 UTC
Re: Re: deployment question: has anyone deployed w. sqlite?
On Fri, Jul 9, 2010 at 3:42 PM, Philip Hallstrom <philip-LSG90OXdqQE@public.gmane.org> wrote:> Just to play devil''s advocate... sqlite is fine for production web apps that are almost > entirely read only. SQLite falls over when trying to handle concurrent writes though.This has been my experience as well. So long as you have a really fast disk to speed along the write locks, you can use sqlite forever. -- Greg Donald destiney.com | gregdonald.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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Thank you all for your comments. @Phillip, @Marnen - I didn''t know about the sqlite concurrency factor, thanks... On Jul 9, 5:00 pm, Greg Donald <gdon...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Fri, Jul 9, 2010 at 3:42 PM, Philip Hallstrom <phi...-LSG90OXdqQE@public.gmane.org> wrote: > > Just to play devil''s advocate... sqlite is fine for production web apps that are almost > > entirely read only. SQLite falls over when trying to handle concurrent writes though. > > This has been my experience as well. So long as you have a really > fast disk to speed along the write locks, you can use sqlite forever. > > -- > Greg Donald > destiney.com | gregdonald.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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.