PHP Classes

PHP Cache Database Results Library: Cache database query results in a Redis server

Recommend this page to a friend!
  Info   View files Example   View files View files (15)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog (1)    
Last Updated Ratings Unique User Downloads Download Rankings
2023-12-02 (1 month ago) RSS 2.0 feedNot yet rated by the usersTotal: 37 All time: 10,840 This week: 87Up
Version License PHP version Categories
database-cache-php-l 1.0.0Custom (specified...7Databases, Cache, PHP 7
Description 

Author

This package can cache database query results in a Redis server.

It can store the data of database query results as a Redis server with a given name.

Next time your application needs to retrieve the same database query results, this package can retrieve the cached results from the Redis server.

Picture of Leonardo Di Sarli
  Performance   Level  
Name: Leonardo Di Sarli <contact>
Classes: 10 packages by
Country: Brazil Brazil
Innovation award
Innovation award
Nominee: 4x

Winner: 1x

Example

<?php

require_once __DIR__ . '/../vendor/autoload.php';

use
DatabaseCache\Repository;

$redisConfig = [
   
'host' => 'localhost',
   
'port' => 6379,
];

$repository = new Repository($redisConfig);
$data = [
   
'name' => 'gabriel',
   
'email' => 'testegabs@teste.com',
];
$repository->setQuery(
   
'table:id',
   
json_encode($data)
);

$getData = $repository->getQuery('table:id');

print_r($getData);
echo
PHP_EOL;


Details

PHP Database Cache

Latest Version codecov CI Build Downloads Old Downloads PRs Welcome Packagist License (custom server)

PHP library for put all database result in cache

Installation

Release 7.0.0 Requires PHP 8.3

Release 6.0.0 Requires PHP 8.2

Release 5.0.0 Requires PHP 8.1

Release 4.0.0 Requires PHP 7.4

Release 3.0.0 Requires PHP 7.3

Release 2.0.0 Requires PHP 7.2

Release 1.0.0 Requires PHP 7.1

The recommended way to install is through Composer.

composer require not-empty/database-cache-php-lib

Usage

Setting a credential

use DatabaseCache\Repository;
$redisConfig = [
    'host' => 'localhost',
    'port' => 6379,
];
$repository = new Repository($redisConfig);
$data = [
    'name' => 'gabriel',
    'email' => 'testegabs@teste.com',
];
$repository->setQuery(
    'table:id',
    json_encode($data)
);
$getData = $repository->getQuery('table:id');
var_dump($data);

if you want an environment to run or test it, you can build and install dependences like this

docker build --build-arg PHP_VERSION=8.3-rc-cli -t not-empty/database-cache-php-lib:php83 -f contrib/Dockerfile .

Access the container

docker run -v ${PWD}/:/var/www/html -it not-empty/database-cache-php-lib:php83 bash

Verify if all dependencies is installed

composer install --no-dev --prefer-dist

and run

php sample/repository-sample.php

Development

Want to contribute? Great!

The project using a simple code. Make a change in your file and be careful with your updates! Any new code will only be accepted with all validations.

To ensure that the entire project is fine:

First you need to building a correct environment to install all dependences

docker build --build-arg PHP_VERSION=8.3-rc-cli -t not-empty/database-cache-php-lib:php83 -f contrib/Dockerfile .

Access the container

docker run -v ${PWD}/:/var/www/html -it not-empty/database-cache-php-lib:php83 bash

Install all dependences

composer install --dev --prefer-dist

Run all validations

composer check

Not Empty Foundation - Free codes, full minds


  Files folder image Files  
File Role Description
Files folder image.github (1 directory)
Files folder imagecontrib (4 files)
Files folder imagesample (1 file)
Files folder imagesrc (1 file)
Files folder imagetests (1 file)
Accessible without login Plain text file composer.json Data Auxiliary data
Accessible without login Plain text file composer.lock Data Auxiliary data
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file phpcs.xml Data Auxiliary data
Accessible without login Plain text file phpmd.xml Data Auxiliary data
Accessible without login Plain text file phpunit.xml Data Auxiliary data
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  .github  
File Role Description
Files folder imageworkflows (1 file)

  Files folder image Files  /  .github  /  workflows  
File Role Description
  Accessible without login Plain text file php.yml Data Auxiliary data

  Files folder image Files  /  contrib  
File Role Description
  Accessible without login Plain text file coverage-checker.php Example Example script
  Accessible without login Plain text file Dockerfile Data Auxiliary data
  Accessible without login Plain text file pre-commit Data Auxiliary data
  Accessible without login Plain text file setup.sh Data Auxiliary data

  Files folder image Files  /  sample  
File Role Description
  Accessible without login Plain text file repository-sample.php Example Example script

  Files folder image Files  /  src  
File Role Description
  Plain text file Repository.php Class Class source

  Files folder image Files  /  tests  
File Role Description
  Plain text file RepositoryTest.php Class Class source

 Version Control Unique User Downloads Download Rankings  
 100%
Total:37
This week:0
All time:10,840
This week:87Up