Laravel query builder cache

Install version 1 of this perhaps? https://github.com/renoki-co/laravel-eloquent-query-cache/tree/1.0

Be aware that its for eloquent, not the query builder

@hameti the query builder is extendable via macro's so you can do something like this:

The cacheKey is based on the raw query + the bindings to make sure select * from user where id = 1 and select * from user where id = 2 are both considered different cache entries.

Add to your AppServiceProvider

\Illuminate\Database\Query\Builder::macro('getViaCache', function ($ttl) {
    $queryCacheKey = 'query:'.md5($this->toSql() . serialize($this->getBindings()));

    return \Cache::remember($queryCacheKey, $ttl, function() {
        return $this->get();
    });
});

Testing:

\DB::enableQueryLog();
dd(
    \DB::table('users')->where('id', '>', 1)->limit(2)->getViaCache(10),
    \DB::getQueryLog()
);

Notes You can fill up your cache quite quickly this way so be careful with it. You can easily create your own version with countViaCache() or pluckViaCache() variants.