README
sequelize-redis-cache
Small fluent interface for caching sequelize database query results in redis more easily. Simply put, this is a wrapper around sequelize retrieval methods that will automatically check in the configured redis instance for a value (based on a hash of the query and model name), then retrieve from the database and persist in redis if not found. It is promise based, so it will resemble sequelize for the most part, and be co/koa friendly.
Installation
npm install sequelize-redis-cache
Usage
var initCacher = require('sequelize-redis-cache');
var redis = require('redis');
var Sequelize = require('sequelize');
var rc = redis.createClient(6379, 'localhost');
var db = new Sequelize('cache_tester', 'root', 'root', { dialect: 'mysql' });
var cacher = initCache(db, rc);
var cacheObj = cacher('sequelize-model-name')
.ttl(5);
cacheObj.find({ where: { id: 3 } })
.then(function(row) {
console.log(row); // sequelize db object
console.log(cacheObj.cacheHit); // true or false
});
Check the tests out for more info, but it's pretty simple. The currently supported methods are:
find findOne findAll findAndCountAll all min max sum
Notes
This library does not handle automatic invalidation of caches, since it currently does not handle inserts/updates/deletes/etc. I'd be in favor of someone submitting a patch to accommodate that, although I think that would be a significant undertaking.
License
MIT - Rekt