Download the PHP package geeky/query-cache-builder without Composer
On this page you can find all versions of the php package geeky/query-cache-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download geeky/query-cache-builder
More information about geeky/query-cache-builder
Files in geeky/query-cache-builder
Package query-cache-builder
Short Description This package is caching every single query per request, to make sure that you will never duplicate your query again.
License MIT
Informations about the package query-cache-builder
Laravel Query Cache Builder
If you are using Barryvdh's Debug Bar and you're seeing tons of duplicate queries, and you simply have no time to track them all down.
The package is caching all duplicates queries and it makes sure that you will never be executed the same query again, by overriding the method runSelect
exsists in Illuminate\Database\Query\Builder
that runs in every select query in Laravel, and we're going to cache every query by it's SQL and it's Bindings.
So instead of excuting a query, we will cache it as a key and it's results as a value.
If a query excutes, we will check if the query executed once before so we will retrieve the cached value or we will excute the query then cache it.
Installation
1- Install using composer:
composer require geeky/query-cache-builder
2- Add a custom Cache Driver. We're doing this so that we don't mess with any existing Cache logic you might already be using. In ~/config/cache.php
add below cache stores array :
3- If you don't use auto-discovery, add the ServiceProvider to the providers array in config/app.php
Geeky\Database\CacheBuilderServiceProvider::class
4- Copy the package config to your local config with the publish command:
php artisan vendor:publish --provider="Geeky\Database\CacheBuilderServiceProvider"
This will publish the cachebuilder
config file that gives you the ability to enable cahcing queries and the time you want to cache them.
Note: In case you used an array cache driver
the quires will be cached in-memory Cache store that just stores everything inside an array. This is typically wiped at the end of each request,as once the application gives a response, this is naturally freed from memory. so it doesn't matter if you edit the minutes to 0 or any integer number.
Usage
Use the CacheQueryBuilder trait
in any model you want to use this feature.
Use the below command if you want to flush the cache of our custom store
php artisan cache-builder:clear