- Notifications
You must be signed in to change notification settings - Fork3
Create a Laravel Paginator or LengthAwarePaginator from a Redis sorted set
License
ge-tracker/laravel-redis-paginator
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
Ever wanted to display paginated sorted sets at scale? A great example of this would be a leaderboard for a game, or for a website with a large userbase. This package will create a LaravelLengthAwarePaginator from a Redis sorted set. As a sorted set, by definition, is always sorted, it allows a large number of records to be paginated, with very little overhead.
You can install the package via composer:
composer require ge-tracker/laravel-redis-paginator
Initialise the paginator by using dependency injection or the providedRedisPaginator facade. The example below will interact with theleaderboard sorted set. We leverage Laravel's Redis interface, which will honour any prefixing and clustering options that you have configured on your application.
Here is an example of a paginated sorted set in action:
publicfunctionindex(LaravelRedisPaginator$redisPaginator){$users =$redisPaginator->perPage(25)->paginate('leaderboard');returnview('leaderboard',compact('users'));}
ThesortAsc andsortDesc methods allow you to choose the order of the returned results. The default sorting is in ascending order.
$usersAsc =$redisPaginator->sortAsc()->paginate('leaderboard');$usersDesc =$redisPaginator->sortDesc()->paginate('leaderboard');
You may want to display the user's rank in the sorted set, as well as a link to jump to the page that contains their name. This can be achieved by using therank() method. AMemberRank object will be returned which contains thescore,rank, andpage properties:
publicfunctionshow(User$user,LaravelRedisPaginator$redisPaginator){$memberRank =$redisPaginator->rank('user:' .$user->id,'leaderboard');dump($memberRank->score,$memberRank->rank,$memberRank->page);}
For those of you who prefer facades over dependency injection, that option is also available:
publicfunctionindex(){$users = RedisPaginator::perPage(25)->paginate('leaderboard');returnview('leaderboard',compact('users'));}
The current page can be set by using thepage() method, or by using the method parameters. Under the hood, the package uses Laravel's defaultPaginator's page resolution, which means that the page can also be specified via the query string.
// Using the fluent interface$users =$redisPaginator->page(5)->paginate('leaderboard');// Using method parameters$users =$redisPaginator->paginate('leaderboard','page',5);// https://www.example.com/leaderboard?page=5$users =$redisPaginator->paginate('leaderboard');
Given that Redis an in-memory data structure store, and not a relational database, it is very likely that the real data relating to your paginated data (leaderboard?) is not wholly stored in Redis. This data will need to be loaded once you have fetched your paginated results, and this package will handle that for you.
In this example, we assume that you have stored your data in the following format:
| member | score | Eloquent ID |
|---|---|---|
| user:1 | 100 | 1 |
| user:2 | 200 | 2 |
| user:3 | 300 | 3 |
First, create a Redis resolver. This can be placed anywhere your application, such asapp/RedisResolvers/UserResolver.php.
The$modelKey property should correspond to the key that you are using to generate your Redis members. This will generally beid oruuid. The$scoreField property defines the field that will be mapped onto your Eloquent model, or merged into your results array.
<?phpnamespaceApp\RedisResolvers;useApp\User;useGeTracker\LaravelRedisPaginator\Resolvers\AbstractResolver;class UserResolverextends AbstractResolver{// Defaults shown below, can be omittedprotected$modelKey ='id';protected$scoreField ='score';/** * Load Eloquent models */protectedfunctionresolveModels(array$keys) {return User::whereIn('id',$keys)->get(); }/** * Resolve a key from Redis to an Eloquent incrementing ID or UUID */protectedfunctionresolveKey($key) {return (int)str_replace('user:','',$key); }}
TheresolveKey() method will take a single key (Redis member), and allow you to transform it. In the example above, we are strippinguser: from the string, before casting it to an integer.
You can then defineresolveModels() that accepts an array of resolved keys to be queried.
Finally, we must set our model resolver before running the query:
$users =$this->paginator ->setModelResolver(new \App\RedisResolvers\UserResolver()) ->paginate('leaderboard');
We can now access our full User model, as well as the score that has been loaded from Redis:
echo$users[0]->name .' ->' .$users[0]->score;
composertestPlease seeCHANGELOG for more information on what has changed recently.
Please seeCONTRIBUTING for details.
If you discover any security related issues, please emailjames@ge-tracker.com instead of using the issue tracker.
The MIT License (MIT). Please seeLicense File for more information.
About
Create a Laravel Paginator or LengthAwarePaginator from a Redis sorted set
Resources
License
Contributing
Security policy
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
Uh oh!
There was an error while loading.Please reload this page.