Cache Query Builder for Laravel

About

The cache-query-builder package allows you to increase the performance and low pressure to database request.

Tutorial how create composer package

Features

• cache query getting columns and values
• cache sub query / relationship
• set time individual by model
• methods to get and first values from cache
• methods to save, insert, delete to cache

Installation

Require the cirelramos/cache-query-builder package in your composer.json and update your dependencies:

composer require cirelramos/cache-query-builder

Configuration

set provider

'providers' => [
    // ...
    Cirelramos\Cache\Providers\ServiceProvider::class,
],

The defaults are set in config/cache-query.php. Publish the config to copy the file to your own config:

php artisan vendor:publish --provider="Cirelramos\Cache\Providers\ServiceProvider"

Note: this is necessary to you can change default config

Usage

To cache for query you need use extend Class

class Product extends CacheModel
{
}

To cache for query you need use methods: getFromCache or firstCache

        return Product::query()
            ->where('active', ModelConst::ENABLED)
            ->with($relations)
            ->getFromCache(['*'], $tags);

if you want purge cache can use methods: saveWithCache, insertWithCache, deleteWithCache

            $product = new Product();
            $product->saveWithCache();

            Product::insertWithCache($values);

            $product->deleteWithCache();

License

Released under the MIT License, see LICENSE.