Skip to content


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Write Through and Read Through caching library inspired by CacheMoney and cache_fu, support ActiveRecord 4.
Failed to load latest commit information.
gemfiles bump 2.1.3
lib bump 2.14
test Fix #21
.gitignore Simplify database_cleaner usage and bump version
.travis.yml bump 2.1.3 CHANGELOG
Gemfile Add rails version Gemfiles and reconfigure travis.yml bump 2.14
Rakefile Add test case.
second_level_cache.gemspec Fix #19


Gem Version Dependency Status Build Status Code Climate

SecondLevelCache is a write-through and read-through caching library inspired by Cache Money and cache_fu, support ActiveRecord 4.

Read-Through: Queries by ID, like current_user.articles.find(params[:id]), will first look in cache store and then look in the database for the results of that query. If there is a cache miss, it will populate the cache.

Write-Through: As objects are created, updated, and deleted, all of the caches are automatically kept up-to-date and coherent.


In your gem file:

gem "second_level_cache", "~> 2.1.4"

For ActiveRecord 3:

gem "second_level_cache", "~> 1.6"


For example, cache User objects:

class User < ActiveRecord::Base
  acts_as_cached(:version => 1, :expires_in => 1.week)

Then it will fetch cached object in this situations:

User.where(:status => 1).find(1)

Cache key:

user = User.find 1
user.second_level_cache_key  # We will get the key looks like "slc/user/1/0"

Expires cache:

user = User.find(1)

or expires cache using class method:


Disable SecondLevelCache:

User.without_second_level_cache do
  user = User.find 1
  # ...

Only SELECT * query will be cached:

# this query will NOT be cached"id, name").find(1)


  • SecondLevelCache cache by model name and id, so only find_one query will work.
  • Only equal conditions query WILL get cache; and SQL string query like User.where("name = 'Hooopo'").find(1) WILL NOT work.
  • SecondLevelCache sync cache after transaction commit:
# user and account's write_second_level_cache operation will invoke after the logger.
ActiveRecord::Base.transaction do "info"
end # <- Cache write 

# if you want to do something after user and account's write_second_level_cache operation, do this way:
ActiveRecord::Base.transaction do
end # <- Cache write "info"
  • If you are using SecondLevelCache with database_cleaner, you should set cleaning strategy to :truncation:
DatabaseCleaner.strategy = :truncation


In production env, we recommend to use Dalli as Rails cache store.

 config.cache_store = [:dalli_store, APP_CONFIG["memcached_host"], {:namespace => "ns", :compress => true}]


  • When you want to clear only second level cache apart from other cache for example fragment cache in cache store, you can only change the cache_key_prefix:
SecondLevelCache.configure.cache_key_prefix = "slc1"
  • When schema of your model changed, just change the version of the speical model, avoding clear all the cache.
class User < ActiveRecord::Base
  acts_as_cached(:version => 2, :expires_in => 1.week)
  • It provides a great feature, not hits db when fetching record via unique key(not primary key).
# this will fetch from cache
user = User.fetch_by_uniq_keys(nick_name: "hooopo")
post = Post.fetch_by_uniq_keys(user_id: 2, slug: "foo")

# this also fetch from cache
user = User.fetch_by_uniq_keys!(nick_name: "hooopo") # this will raise `ActiveRecord::RecordNotFound` Exception when nick name not exists.
  • You can use Rails's Eager Loading feature as normal. Even better, second_level_cache will transform the IN query into a Rails.cache.multi_read operation. For example:
Answer.includes(:question).limit(10).order("id DESC").each{|answer| answer.question.title}
Answer Load (0.2ms)  SELECT `answers`.* FROM `answers` ORDER BY id DESC LIMIT 10 # Only one SQL query and one Rails.cache.read_multi fetching operation.

Details for read_multi feature.



MIT License

Something went wrong with that request. Please try again.