# Deployment question: has anyone deployed w. sqlite? **URL:** \ **Category:** Rails\ **Created:** [July 9, 2010, 5:32pm UTC](https://www.ruby-forum.com/t/deployment-question-has-anyone-deployed-w-sqlite/191327 "2010-07-09T17:32:24Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Lille](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@Lille](https://www.ruby-forum.com/u/Lille)\ **Post date:** [July 9, 2010, 5:32pm UTC](https://www.ruby-forum.com/t/deployment-question-has-anyone-deployed-w-sqlite/191327/1 "2010-07-09T17:32:24Z")
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 ---
**Author:** ![Lille](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@Lille](https://www.ruby-forum.com/u/Lille)\ **Post date:** [July 9, 2010, 6:16pm UTC](https://www.ruby-forum.com/t/deployment-question-has-anyone-deployed-w-sqlite/191327/2 "2010-07-09T18:16:56Z")
> 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 ---
**Author:** ![Lille](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@Lille](https://www.ruby-forum.com/u/Lille)\ **Post date:** [July 9, 2010, 6:36pm UTC](https://www.ruby-forum.com/t/deployment-question-has-anyone-deployed-w-sqlite/191327/3 "2010-07-09T18:36:16Z")
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 H. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > Otherwise… find somewhere that has the sqlite ruby gem installed and go > For more options, visit this group at > [http://groups.google.com/group/rubyonrails-talk?hl=en](http://groups.google.com/group/rubyonrails-talk?hl=en). – Sent from my mobile device ---
**Author:** ![Lille](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@Lille](https://www.ruby-forum.com/u/Lille)\ **Post date:** [July 9, 2010, 10:24pm UTC](https://www.ruby-forum.com/t/deployment-question-has-anyone-deployed-w-sqlite/191327/4 "2010-07-09T22:24:28Z")
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 ---
**Author:** ![Lille](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@Lille](https://www.ruby-forum.com/u/Lille)\ **Post date:** [July 9, 2010, 11:02pm UTC](https://www.ruby-forum.com/t/deployment-question-has-anyone-deployed-w-sqlite/191327/5 "2010-07-09T23:02:41Z")
On Fri, Jul 9, 2010 at 3:42 PM, Philip H. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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 D. [destiney.com](http://destiney.com) | [gregdonald.com](http://gregdonald.com) ---
**Author:** ![Lille](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@Lille](https://www.ruby-forum.com/u/Lille)\ **Post date:** [July 10, 2010, 1:40pm UTC](https://www.ruby-forum.com/t/deployment-question-has-anyone-deployed-w-sqlite/191327/6 "2010-07-10T13:40:39Z")
Thank you all for your comments. @Phillip, @Marnen - I didn’t know about the sqlite concurrency factor, thanks… ---
**Author:** ![Lille](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@Lille](https://www.ruby-forum.com/u/Lille)\ **Post date:** [July 9, 2010, 10:43pm UTC](https://www.ruby-forum.com/t/deployment-question-has-anyone-deployed-w-sqlite/191327/7 "2010-07-09T22:43:22Z")
> > 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