PHPackages                             acet/qcache - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. acet/qcache

ActiveLibrary[Database & ORM](/categories/database)

acet/qcache
===========

Database query caching

2.1.0(4y ago)01191[1 issues](https://github.com/andy-ce-taylor/qcache/issues)GPL-3.0PHPPHP ^7.1

Since Jun 10Pushed 4y ago1 watchersCompare

[ Source](https://github.com/andy-ce-taylor/qcache)[ Packagist](https://packagist.org/packages/acet/qcache)[ RSS](/packages/acet-qcache/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (2)DependenciesVersions (40)Used By (0)

Qcache
======

[](#qcache)

#### Database query caching

[](#database-query-caching)

Qcache is a query caching library which works with MySQL, MSSQL and SQLite databases.

PHP scripts spend much of their time querying databases using SELECT statements. Qcache can replace those calls, making time-hungry database operations perform faster and more efficiently.

#### How it works

[](#how-it-works)

Qcache checks the tables used in a SELECT statement to see whether anything has changed since it last looked (*rows added*/*updated*/*dropped*).

If a change is detected or there is no cache entry corresponding to the SQL statement, the database is queried, the time is recorded and the result set is cached before being passed back to the calling program.

If no change is detected, there is no need for the database to repeat the operation using the exact same query and producing an identical result set, so a cached result can be returned to the calling program.

The result (whether from the cache or the database query) is passed back to the caller in object `Qcache::SqlResultSet` which mimics the functionality of the result sets used by most native databases (`fetch_row()`, `fetch_assoc()` etc.).

#### Requirements

[](#requirements)

Qcache requires the following:

- PHP 7.1+

#### Installation

[](#installation)

Qcache is installed via Composer.

Run the following to use the latest stable version:

```
    composer require acet/qcache

```

or if you want the latest master version:

```
    composer require acet/qcache:dev-master

```

You can also manually edit your composer.json file:

```
    {
        "require": {
           "acet/Qcache": "*"
        }
    }

```

#### Example

[](#example)

```

```

###  Health Score

28

—

LowBetter than 54% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity62

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~9 days

Recently: every ~66 days

Total

38

Last Release

1809d ago

Major Versions

0.0.4 → 1.0.02020-07-05

1.2.3 → 2.0.02021-01-04

PHP version history (2 changes)0.0.0PHP ^5.4 || ^7.0

2.0.0PHP ^7.1

### Community

Maintainers

![](https://www.gravatar.com/avatar/594ca862fcb2e5b8b89038fac79a05bf72d5aa5dd756bbfa84ade3c9fd9b55c1?d=identicon)[andy-ce-taylor](/maintainers/andy-ce-taylor)

---

Top Contributors

[![andy-ce-taylor](https://avatars.githubusercontent.com/u/24712509?v=4)](https://github.com/andy-ce-taylor "andy-ce-taylor (7 commits)")

---

Tags

databasemysqlsqlitesqlmssqlcachecachingquerysql serversqlite3

### Embed Badge

![Health badge](/badges/acet-qcache/health.svg)

```
[![Health](https://phpackages.com/badges/acet-qcache/health.svg)](https://phpackages.com/packages/acet-qcache)
```

###  Alternatives

[aura/sqlquery

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

4572.9M34](/packages/aura-sqlquery)[ezsql/ezsql

Advance database access library. Make interacting with a database ridiculously easy. An universal interchangeable CRUD system.

86946.7k](/packages/ezsql-ezsql)[jv2222/ezsql

Advance database access library. Make interacting with a database ridiculously easy. An universal interchangeable CRUD system.

87311.3k2](/packages/jv2222-ezsql)[atlas/query

Object-oriented query builders and performers for MySQL, Postgres, SQLite, and SQLServer.

41249.0k7](/packages/atlas-query)[opis/database

A database abstraction layer over PDO, that provides a powerful and intuitive query builder, bundled with an easy to use schema builder

10184.2k3](/packages/opis-database)[tommyknocker/pdo-database-class

Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies.

845.7k](/packages/tommyknocker-pdo-database-class)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)