creativelittledots / rememberable
Query caching for Laravel 5
Requires
- php: >=5.4.0
- illuminate/database: ~5.0
- illuminate/support: ~5.0
Requires (Dev)
- mockery/mockery: 0.9.*
- phpunit/phpunit: 4.2.*
README
Rememberable is an Eloquent trait for Laravel 5.0+ that brings back the remember()
query functions from Laravel 4.2. This makes it super easy to cache your query results for an adjustable amount of time.
// Get a the first user's posts and remember them for a day. User::first()->remember(1440)->posts()->get();
It works by simply remembering the SQL query that was used and storing the result. If the same query is attempted while the cache is persisted it will be retrieved from the store instead of hitting your database again.
Installation
Install using Composer, just as you would anything else.
composer require creativelittledots/rememberable
The easiest way to get started with Eloquent is to create an abstract App\Model
which you can extend your application models from. In this base model you can import the rememberable trait which will extend the same caching functionality to any queries you build off your model.
<?php namespace App; use Watson\Rememberable\Rememberable; use Illuminate\Database\Eloquent\Model as Eloquent; abstract class Model extends Eloquent { use Rememberable; }
Now, just ensure that your application models from this new App\Model
instead of Eloquent.
<?php namespace App; class Post extends Model { // }
Alternatively, you can simply apply the trait to each and every model you wish to use remember()
on.
Usage
Using the remember method is super simple. Just pass the number of minutes you want to store the result of that query in the cache for, and whenever the same query is called within that time frame the result will be pulled from the cache, rather than from the database again.
// Remember the number of users for an hour. $users = User::remember(60)->count();
Cache tags
If you want to tag certain queries you can add cacheTags('tag_name')
to your query. Please notice that cache tags are not supported by all cache drivers.
// Remember the number of users for an hour and tag it with 'user_queries' User::remember(60)->cacheTags('user_queries')->count();
Cache prefix
If you want a unique prefix added to the cache key for each of your queries (say, if your cache doesn't support tagging), you can add prefix('prefix')
to your query.
// Remember the number of users for an hour and prefix the key with 'users' User::remember(60)->prefix('users')->count();
Alternatively, you can add the $rememberCachePrefix
property to your model to always use that cache prefix.
Cache driver
If you want to use a custom cache driver (defined in config/cache.php) you can add cacheDriver('cacheDriver')
to your query.
// Remember the number of users for an hour using redis as cache driver User::remember(60)->cacheDriver('redis')->count();
Alternatively, you can add the $rememberCacheDriver
property to your model to always use that cache driver.
Model wide cache tag
You can set a cache tag for all queries of a model by setting the $rememberCacheTag
property with an unique string that should be used to tag the queries.
Relationships
Validating works by caching queries on a query-by-query basis. This means that when you perform eager-loading those additional queries will not be cached as well unless explicitly specified. You can do that by using a callback with your eager-loads.
$users = User::where("id", ">", "1") ->with(['posts' => function ($q) { $q->remember(10); }]) ->remember(10) ->take(5) ->get();
Always enable
You can opt-in to cache all queries of a model by setting the $rememberFor
property with the number of minutes you want to cache results for. Use this feature with caution as it could lead to unexpected behaviour and stale data in your app if you're not familiar with how it works.
Cache flushing
You can flush a single query by simple using:
User::flushCache();
This works for all queries:
User::where('active', 1)->flushCache();
Based on the architecture of the package it is possible to delete the cache for a both a single query and any tagged queries using cache tags, you are able to flush the cache for the tag:
User::flushCache('user_queries');
If you used the $rememberCacheTag
property you can use the method without a parameter and the caches for the tag set by $rememberCacheTag
are flushed:
User::flushCache();