PHPackages                             wpjscc/reactphp-mysql-pool-server - 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. wpjscc/reactphp-mysql-pool-server

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

wpjscc/reactphp-mysql-pool-server
=================================

v1.0.1(2y ago)13MITPHP

Since Nov 4Pushed 2y ago1 watchersCompare

[ Source](https://github.com/wpjscc/reactphp-mysql-pool-server)[ Packagist](https://packagist.org/packages/wpjscc/reactphp-mysql-pool-server)[ RSS](/packages/wpjscc-reactphp-mysql-pool-server/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (2)Dependencies (2)Versions (3)Used By (0)

reactphp-mysql-pool-server
==========================

[](#reactphp-mysql-pool-server)

```
                                server pool
                                    |-------------------------mysql server
                                    |
                                    |
                                    |
            +-----------------------+-------------------------+
            |                                                 |
            |                                                 |
    +----------------+                              +-----------------+
    |       |        |                              |         |       |
    |       |        |                              |         |       |
    |   connect pool |                              |    connect pool |
    |       |        |                              |         |       |
    |       |        |                              |         |       |
    |       |        |                              |         |       |
    |       app      |                              |        app      |
    +----------------+                              +-----------------+

```

install
-------

[](#install)

```
composer require wpjscc/reactphp-mysql-pool-server -vvv

```

server pool
-----------

[](#server-pool)

```
require "vendor/autoload.php";

use Wpjscc\MySQLServer\Server;
use Wpjscc\MySQL\Pool;

new Server(3308, new Pool(
    getenv('MYSQL_URI') ?: 'username:password@host/databasename?timeout=5',
    [
        'min_connections' => 2, // 10 connection
        'max_connections' => 10, // 10 connection
        'max_wait_queue' => 70, // how many sql in queue
        'wait_timeout' => 5, // wait time include response time
        'keep_alive' => 60
    ]
));

```

connect pool
------------

[](#connect-pool)

```
require "vendor/autoload.php";

use Wpjscc\MySQL\Pool;
use Wpjscc\MySQLServer\Factory;
use React\MySQL\QueryResult;
use React\EventLoop\Loop;

$pool = new Pool(
    '127.0.0.1:3308',
    [
        'min_connections' => 2, // 10 connection
        'max_connections' => 10, // 10 connection
        'max_wait_queue' => 70, // how many sql in queue
        'wait_timeout' => 5,// wait time include response time
        'keep_alive' => 10
    ],
    new Factory()
);

query($pool);
queryStream($pool);

function query($pool) {
    for ($i=0; $i < 90; $i++) {
        $pool->query('select * from blog')->then(function (QueryResult $command) use ($i) {
            echo "query:$i\n";
            if (isset($command->resultRows)) {
                // this is a response to a SELECT etc. with some rows (0+)
                // print_r($command->resultFields);
                // print_r($command->resultRows);
                echo count($command->resultRows) . ' row(s) in set' . PHP_EOL;
            } else {
                // this is an OK message in response to an UPDATE etc.
                if ($command->insertId !== 0) {
                    var_dump('last insert ID', $command->insertId);
                }
                echo 'Query OK, ' . $command->affectedRows . ' row(s) affected' . PHP_EOL;
            }
        }, function ($error) {
            // the query was not executed successfully
            echo 'Error: ' . $error->getMessage() . PHP_EOL;
        });

    }
}

function queryStream($pool){
    for ($i=0; $i < 90; $i++) {
        (function($pool,$i){
            $stream = $pool->queryStream('select * from blog');

            $stream->on('data', function ($data) use ($i) {
                // echo "queryStream:$i\n";
                // print_r($data);
            });
            $stream->on('error', function ($err) {
                echo 'Error: ' . $err->getMessage() . PHP_EOL;
            });
            $stream->on('end', function () use ($i) {
                echo 'Completed.'.$i . PHP_EOL;
            });

        })($pool, $i);

    }
}

$pool->translation(function ($connection) {
    React\Async\await($connection->query("INSERT INTO blog_test (content) VALUES ('hello world success')"));
    return \React\Promise\resolve('hello world');
})->then(function($result){
    var_dump($result);
}, function($error){
    var_dump($error->getMessage());
});

```

###  Health Score

21

—

LowBetter than 18% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity5

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity44

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.

###  Release Activity

Cadence

Every ~18 days

Total

2

Last Release

908d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/76907477?v=4)[wpjscc](/maintainers/wpjscc)[@wpjscc](https://github.com/wpjscc)

---

Top Contributors

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

### Embed Badge

![Health badge](/badges/wpjscc-reactphp-mysql-pool-server/health.svg)

```
[![Health](https://phpackages.com/badges/wpjscc-reactphp-mysql-pool-server/health.svg)](https://phpackages.com/packages/wpjscc-reactphp-mysql-pool-server)
```

###  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)