Ruby's SQLite library and Rails SQLite adaptor have improved their capabilities and performance massively recently. It's now perfectly reasonable to use SQLite in a production application. I presented at Ruby Australia's Melbourne meetup on these improvements and why you should take a close look