SQLite Myths | Fractaled Mind

The key details here are that the Rails app can handle a peak of 2.5k write requests per second. To put this in perspective, Nate Berkopec’s post in 2015 about scaling Rails applications provides some context from Twitter and Shopify when they were both monolithic Rails apps. Twitter in 2007 was handling 600 requests per second,1 and Shopify in 2013 was handling 833 requests per second.2 Both of these apps were running on client/server databases, and both of these apps were handling less than half the number of requests per second that this Rails app is handling. Plus, these are numbers for total requests, not just write requests. For this profiling, we are talking about pure writes.