PHPackages                             dhuny/mysqlj - 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. dhuny/mysqlj

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

dhuny/mysqlj
============

Make dynamic pages Progressive ready

117PHP

Since Sep 10Pushed 7y agoCompare

[ Source](https://github.com/dhuny/mysqlj)[ Packagist](https://packagist.org/packages/dhuny/mysqlj)[ RSS](/packages/dhuny-mysqlj/feed)WikiDiscussions master Synced 3d ago

READMEChangelogDependenciesVersions (1)Used By (0)

mysqlj
======

[](#mysqlj)

A php / mysql library to convert mysqli into a multi-level reusable static query cache for HTML5 service workers and offline data usage

Installation
============

[](#installation)

Install the latest version with (Type composer without the $ sign on bash)

$ composer require dhuny/mysqlj:dev-master

Basic Usage
===========

[](#basic-usage)

Include the following codes in your PHP

require 'vendor/autoload.php';

use dhuny\\mysqlj\\mysqlj;

use dhuny\\mysqlj\\mysqlj\_result;

use dhuny\\mysqlj\\mysqlj\_cache;

use dhuny\\mysqlj\\filterfiles;

Application of the Library
==========================

[](#application-of-the-library)

Replace your mysqli library connection with a mysqlj one. i.e. Replace

$conn = new mysqli($hostname\_conn,$username\_conn,$password\_conn,$database\_conn);

by

$conn = new mysqlj($hostname\_conn,$username\_conn,$password\_conn,$database\_conn);

Use of MySQLj
=============

[](#use-of-mysqlj)

The mySQLj is a library that reads the DB queries and converts it into an apprpriate Web SQL database \[or easily modifyiable to IndexedDB\]. The Converted DB is saved in a js file bearing the same name as the php file. The JS file can then be recalled by the server to load the data from file rather than re-querying the DB server or pass that to the client to create a Multi level reusable static query cache for HTML5 service workers and offline data storage.

Testing the codes
=================

[](#testing-the-codes)

To Test the codes, pull same using composer \[composer require dhuny/mysqlj:dev-master\]. The vendor/dhuny/mysqlj/ contains some sample codes for testing purposes. Cut Connections folder, cache\*.php and existing\*.php. Paste them in the root folder of your project. Download and install Oracle Sample Employees Database [https://github.com/datacharmer/test\_db](https://github.com/datacharmer/test_db)Open Connections/ conn and set up your DB connections

Run Cache\*.php to test code.

This code is still experimental and currently in use as part of a research work referenced under IEEE Explore as \[\]. Library may be currently inappropriate for production as only a few mysqli classes were extended.

Notes
=====

[](#notes)

For queries, bugs and contributions the author can be contacted via

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity40

Maturing project, gaining track record

 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.

### Community

Maintainers

![](https://www.gravatar.com/avatar/67cc8420d2ecaf04cd842ff5f3d64d2d64540bc1dc241da34ce9bb2c11b137c2?d=identicon)[Dhuny](/maintainers/Dhuny)

---

Top Contributors

[![dhuny](https://avatars.githubusercontent.com/u/42516995?v=4)](https://github.com/dhuny "dhuny (7 commits)")

### Embed Badge

![Health badge](/badges/dhuny-mysqlj/health.svg)

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

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

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