Swoole Coroutine PostgreSQL Doctrine DBAL Driver
A Doctrine\DBAL\Driver implementation on top of Swoole\Coroutine\PostgreSQL.
Getting started
Install
composer require leocavalcante/swoole-postgresql-doctrine-driver
Usage
Doctrine parameters, for both DBAL and ORM projects, accepts the driverClass option; it is where we can inject this project's driver:
use Doctrine\DBAL\{Driver, DriverManager};
$params = [
'dbname' => 'postgres',
'user' => 'postgres',
'password' => 'postgres',
'host' => 'db',
'driverClass' => Driver\Swoole\Coroutine\PostgreSQL\Driver::class,
'poolSize' => 8,
];
$conn = DriverManager::getConnection($params);
Yes, I deliberately used the Doctrine\DBAL\Driver namespace + Swoole\Coroutine\PostgreSQL namespace, so it is not confusing.
You are ready to rock inside Coroutines (Fibers):
Co\run(static function() use ($conn): void {
$results = [];
$wg = new Co\WaitGroup();
$start_time = time();
Co::create(static function() use (&$results, $wg, $conn): void {
$wg->add();
$results[] = $conn->executeQuery('select 1, pg_sleep(1)')->fetchOne();
$wg->done();
});
Co::create(static function() use (&$results, $wg, $conn): void {
$wg->add();
$results[] = $conn->executeQuery('select 1, pg_sleep(1)')->fetchOne();
$wg->done();
});
$wg->wait();
$elapsed = time() - $start_time;
$sum = array_sum($results);
echo "Two pg_sleep(1) queries in $elapsed second, returning: $sum\n";
});
You should be seeing Two pg_sleep(1) queries in 1 second, returning: 2 and the total time should not be 2 (the sum of pg_sleep(1)'s) because they ran concurrently.
real 0m1.228s
user 0m0.036s
sys 0m0.027s
Developing
Use Composer through Docker
docker-compose run --rm composer install
docker-compose run --rm composer test
It will build a development image with PHP, Swoole, Swoole's PostgreSQL extension and PCOV for coverage.
161 Oct 17, 2022
359 Jan 3, 2023
547 Dec 27, 2022
2 Sep 28, 2022
9.5k Jan 2, 2023
6 Jun 15, 2022
3k Dec 23, 2022
10 Aug 29, 2022
258 Dec 31, 2022
5 Nov 11, 2022
9 Nov 15, 2022
602 Dec 27, 2022
3 Aug 15, 2021
4 Aug 20, 2021
36 Jan 7, 2023
777 Dec 17, 2022
240 Dec 20, 2022
424 Dec 12, 2022