@nithinbekal > SQlite [...] wasn't ideal for a production database out of the box. > SQLite is ready for production. > Now that [...] SQLite is a more robust choice, you don't have to worry about spinning up a PostgreSQL server.
As a backend developer, I always thought SQLite was only meant to be used for testing. What about concurrent access (multiple users at the same time)? Is that covered too? Can I really live without a database server? I find this hard to believe.
@cosmin sqlite on rails had had some massive improvements in the past year, and should easily handle smaller apps. In fact Basecamp's campfire app now uses sqlite.
Highly recommend this write-up by @fractaledmind and his railsconf talk to see how well it performs out of the box with rails now.