sqlcachedb

Using SQLite database for a persistant object cache. This packaged is designed to easily store large amounts of data directly into a SQLite3 database for retrival at a later date. It's not as fast as using memory based storage or file based storage.

Installation

npm install sqlcachedb --save

Usage

Current default cache lifetime is 6 hours, future versions will allow this to be modified.

Basic Example

var cache = require('sqlcachedb');
 
cache.setCache('url','https://github.com', function(){
 
    cache.getCache('url', function(err,data){
        console.log(data);
    });
 
});

setCache

Store a value into cache based on a key

var cache = require('sqlcachedb');
 
cache.setCache('test', Math.random(), function(){});
 
cache.setCache('test2', Math.random(), function(){});
 
cache.setCache('test3', Math.random(), function(){});

getCache

Retrieve a value from cache based on a key

var cache = require('sqlcachedb');
 
cache.setCache('url','https://github.com', function(){
 
    cache.getCache('url', function(err,data){
        console.log(data);
    });
 
});

getKeys

Gets all the keys from cache

var cache = require('sqlcachedb');
 
cache.setCache('test', Math.random(), function(){});
 
cache.setCache('test2', Math.random(), function(){});
 
cache.setCache('test3', Math.random(), function(){});
 
cache.getKeys(function(err, keys){
    console.log(keys);
})

getActiveKeys

Gets all the keys from cache updated within cache lifetime

var cache = require('sqlcachedb');
 
cache.setCache('test', Math.random(), function(){});
 
cache.setCache('test2', Math.random(), function(){});
 
cache.setCache('test3', Math.random(), function(){});
 
cache.getActiveKeys(function(err, keys){
    console.log(keys);
});

purgeKey

Remove data from cache based on key

var cache = require('sqlcachedb');
 
cache.setCache('test4', 'Houdini', function(){
 
    cache.getCache('test4',function(err, data){
        console.log('test4: '+data);
        
        cache.purgeKey('test4', function(err){
 
            cache.getCache('test4',function(err, data){
                console.log('test4: '+data);
            });
        });	
    });	
});

purgeCache

Remove all data from cache
var cache = require('sqlcachedb');
 
cache.purgeCache(function(){
    cache.getKeys(function(err, keys){
        console.log(keys);
    });
});

cleanCache

Remove all data from cache which has expired

var cache = require('sqlcachedb');
 
cache.cleanCache(function(){
    cache.getKeys(function(err, keys){
        console.log(keys);
    });
});

Note: This package is in Alpha stages, probably should not have been published to the repository in it's current state.

caveat emptor