yiisoft / mutex-db-pgsql
Yii Mutex Library - Postgres PDO Driver
Fund package maintenance!
Opencollective
yiisoft
Installs: 917
Dependents: 0
Suggesters: 0
Security: 0
Stars: 11
Watchers: 19
Forks: 4
Open Issues: 3
Requires
- php: ^7.4|^8.0
- ext-pdo: *
- yiisoft/mutex: ^1.1
Requires (Dev)
- phpunit/phpunit: ^9.5
- roave/infection-static-analysis-plugin: ^1.9
- spatie/phpunit-watcher: ^1.23
- vimeo/psalm: ^4.9
This package is auto-updated.
Last update: 2024-05-20 10:29:06 UTC
README
Yii Mutex Library - PostgreSQL PDO Driver
This library provides a PostgreSQL mutex implementation for yiisoft/mutex.
Requirements
- PHP 7.4 or higher.
PDO
PHP extension.
Installation
The package could be installed with Composer:
composer require yiisoft/mutex-pdo-pgsql
General usage
The package provides two classes implementing MutexInterface
and MutexFactoryInterface
from the yiisoft/mutex package:
/** * @var \PDO $connection Configured for PostgreSQL. */ $mutex = new \Yiisoft\Mutex\Pgsql\PgsqlMutex('mutex-name', $connection); $mutexFactory = new \Yiisoft\Mutex\Pgsql\PgsqlMutexFactory($connection);
There are multiple ways you can use the package. You can execute a callback in a synchronized mode i.e. only a single instance of the callback is executed at the same time:
$synchronizer = new \Yiisoft\Mutex\Synchronizer($mutexFactory); $newCount = $synchronizer->execute('critical', function () { return $counter->increase(); }, 10);
Another way is to manually open and close mutex:
$simpleMutex = \Yiisoft\Mutex\SimpleMutex($mutexFactory); if (!$simpleMutex->acquire('critical', 10)) { throw new \Yiisoft\Mutex\Exception\MutexLockedException('Unable to acquire the "critical" mutex.'); } $newCount = $counter->increase(); $simpleMutex->release('critical');
It could be done on lower level:
$mutex = $mutexFactory->createAndAcquire('critical', 10); $newCount = $counter->increase(); $mutex->release();
And if you want even more control, you can acquire mutex manually:
$mutex = $mutexFactory->create('critical'); if (!$mutex->acquire(10)) { throw new \Yiisoft\Mutex\Exception\MutexLockedException('Unable to acquire the "critical" mutex.'); } $newCount = $counter->increase(); $mutex->release();
The PgsqlMutex
supports the "wait for a lock for a certain time" functionality. Using the withRetryDelay()
method, you can override the number of milliseconds between each try until specified timeout times out:
$mutex = $mutex->withRetryDelay(100);
By default, it is 50 milliseconds - it means that we may try to acquire lock up to 20 times per second.
Documentation
If you need help or have a question, the Yii Forum is a good place for that. You may also check out other Yii Community Resources.
License
The Yii Mutex Library - PostgreSQL PDO Driver is free software. It is released under the terms of the BSD License.
Please see LICENSE
for more information.
Maintained by Yii Software.