sjdskl/dbpool

There is no license information available for the latest version (0.4) of this package.

db link pool

0.4 2018-03-13 09:09 UTC

Requires

• php: >=7.0
• catfan/medoo: ^V1.5.5
• symfony/console: ^3.2

Requires (Dev)

• phpunit/phpunit: ^4.0

Unknown License

• skl

• db
• mysql
• pool

README

Based on multi threads Database link pools

1. pthreads extension
2. php >= 7.2

Featrues

1. DB Driver used catfan/medoo, you can call its method at client just like local call
2. Chain Call
3. very easy to use

$client = DbPool\Client\DbPoolClient::getInstance('127.0.0.1', AF_INET, 1122);
for($i = 0; $i < 10; $i ++) {
    $res = $client->query('select * from test.bairong where id=' . ($i + 1) . ' limit 1;')->fetchAll(\PDO::FETCH_ASSOC)->excute();
    print_r($res);
}

$res = $client->select('bairong', ['id', 'realname', 'phone'], ['id[<=]' => 10])->excute();

1. Two link code you can run up server

$server = new \DbPool\Server\DbPoolServer('127.0.0.1', AF_INET, 1122);

//$server = new \DbPool\Server\DbPoolServer('/tmp/skl.sock', AF_UNIX);

$server->loop();

5.Support Transcation

$client->action(function() use ($client) {
    $client->update('bairong', ['realname' => '你大爷xxxx'], [
        'id' => 1,
    ])->excute();
    //true -> ommit，false -> rollback, just like medoo
    return true;
});

6.Support DB Link Heartbeat

public static $HeartBeatTime = 600;
public static $HeartBeatCheckTime = 60;

7.Custom Message Event
8.Support AES And RSA Encrypt