Comparing SQLite based Rails cache stores – Oldmoe's blog

If you are running a production Rails application using SQLite then you are probably using SQLite as a cache store as well. Compared to something like Redis or Memcached, SQLite offers a potentially much larger caching space and a significantly higher read performance, which is what matters most when we are dealing with caching. One other important advantage of SQLite based caching is that it also benefits from the features provided by the filesystem or volume manager underneath it, like for example transparent compression.In this article we will be looking at two SQLite based cache stores for Rails, Litecache, which is a part of the Litestack library of SQLite based data components and SolidCache, which is the new ActiveRecord Based cache store for Rails and one that can be configured to use SQLite.