Download the PHP package efureev/swoole-doctrine-dbal-pgsql-driver without Composer
On this page you can find all versions of the php package efureev/swoole-doctrine-dbal-pgsql-driver. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download efureev/swoole-doctrine-dbal-pgsql-driver
More information about efureev/swoole-doctrine-dbal-pgsql-driver
Files in efureev/swoole-doctrine-dbal-pgsql-driver
Download efureev/swoole-doctrine-dbal-pgsql-driver
More information about efureev/swoole-doctrine-dbal-pgsql-driver
Files in efureev/swoole-doctrine-dbal-pgsql-driver
Vendor efureev
Package swoole-doctrine-dbal-pgsql-driver
Short Description Coroutine-safe PostgreSQL connection pool for Doctrine DBAL on Swoole (hooked pdo_pgsql) with an optional Symfony bundle
License MIT
Package swoole-doctrine-dbal-pgsql-driver
Short Description Coroutine-safe PostgreSQL connection pool for Doctrine DBAL on Swoole (hooked pdo_pgsql) with an optional Symfony bundle
License MIT
FAQ
After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.
Example:
Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories.
In this case some credentials are needed to access such packages.
Please use the auth.json textarea to insert credentials, if a package is coming from a private repository.
You can look here for more information.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?
Informations about the package swoole-doctrine-dbal-pgsql-driver
English | Русский
swoole-doctrine-dbal-pgsql-driver
A PostgreSQL connection pool for Doctrine DBAL on Swoole: one physical connection per coroutine,
a coroutine-safe Doctrine\DBAL\Connection wrapper, and a Symfony bundle that moves DoctrineBundle
connections onto the pool with three lines of configuration.
| What you get | How |
|---|---|
| A bounded number of connections per worker at any concurrency | a pool with a semaphore on Swoole\Coroutine\Channel: a connection is leased lazily on the coroutine's first query and returned on kernel.terminate / Coroutine::defer |
| Transactions invisible to neighbouring coroutines | CoroutineSafeConnection: nesting level, rollback-only flag and isolation live on the coroutine's lease, not in the wrapper's shared field |
| Nothing lost, nothing leaked | on release: always ROLLBACK an unfinished transaction, then DISCARD ALL; lost connections are destroyed, a Statement from another coroutine is rejected |
| Real DBAL exceptions | the transport is PDO pgsql under the Swoole hook: SQLSTATE, UniqueConstraintViolationException, DeadlockException, ConnectionLost work exactly as without a pool |
Requirements
| PHP | ≥ 8.5 (ZTS is the production build for Swoole) |
| ext-swoole | ≥ 6.2 built with --enable-swoole-pgsql; SWOOLE_HOOK_PDO_PGSQL in hook_flags (part of SWOOLE_HOOK_ALL) |
PDO pgsql driver |
Swoole's coroutine one (php --ri swoole → coroutine_pgsql => enabled). The stock ext-pdo_pgsql may stay loaded — it must load before swoole so that Swoole re-registers the driver |
| doctrine/dbal | ^4.4 |
| Symfony (optional) | ^8.1 with doctrine/doctrine-bundle ^3 |
The official phpswoole/swoole:6.2.x-php8.5[-zts] images are built with pgsql support.
Installation
Symfony: quick start
Verify: bin/console debug:config swoole_doctrine_pool prints the defaults,
bin/console debug:container database_connection shows CoroutineSafeConnection.
If your Swoole runtime dispatches the swoole.* events, the rest is automatic: the connection goes back
to the pool on kernel.terminate, pools are closed on swoole.worker_stop. Without them —
see docs/symfony.md.
Without Symfony
Details: docs/standalone.md.
Things to remember
- A lease lives until the end of the request (
kernel.terminate, an explicit$connection->close(), or the end of the coroutine), not until the end of an SQL statement — that is what keepslastInsertId()and transactions on one session. Consequentlysizeis also the cap on concurrent DB requests per worker. - A child coroutine (
go()inside a handler) gets its own connection and is outside the parent's transaction. - Do not touch the database before the worker starts: a pool inherited across fork is discarded with a warning.
size × number of workersmust fit into Postgresmax_connections.- The package makes DBAL coroutine-safe. The ORM UnitOfWork is still the state of one
EntityManager: concurrent coroutines need an EntityManager per coroutine. reset_on_release: rollback_onlysaves a round-trip, butSET, advisory locks and temp tables survive the request. The default isdiscard.
Documentation
| Document | Contents |
|---|---|
| docs/index.md | table of contents |
| docs/getting-started.md | requirements, installation, wiring, first load check |
| docs/use-cases.md | 15 scenarios: HTTP handlers, transactions, ORM, parallel queries, daemons, console, multiple databases, shutdown, warm-up, failover, metrics, large results, session state, tests, limits |
| docs/configuration.md | every swoole_doctrine_pool.* key and what it means; sizing for high load |
| docs/symfony.md | what the bundle does, listeners, url:/DATABASE_URL, monolog |
| docs/standalone.md | usage without Symfony |
| docs/architecture.md | components, lease, acquire/release, data-safety guarantees |
| docs/events.md | PSR-14 events |
| docs/stats.md | PoolStats, metrics hook, alerts |
| docs/testing.md | testing an application with the pool; the package's own tests |
| docs/troubleshooting.md | symptom → cause |
| UPGRADE-3.0.md | migration from v2 (Russian) |
| CHANGELOG.md | change history (Russian) |
| tests/Integration/README.md | how the integration tests run |
Development
Integration image matrix: phpswoole/swoole:6.2.3-php8.5-zts (default),
SWOOLE_IMAGES="phpswoole/swoole:6.2.3-php8.5" composer integration — NTS.
License
MIT
All versions of swoole-doctrine-dbal-pgsql-driver with dependencies
PHP Build Version
Package Version
Requires
php Version
>=8.5
ext-pdo Version *
ext-swoole Version >=6.2
doctrine/dbal Version ^4.4
psr/event-dispatcher Version ^1.0
psr/log Version ^3.0
ext-pdo Version *
ext-swoole Version >=6.2
doctrine/dbal Version ^4.4
psr/event-dispatcher Version ^1.0
psr/log Version ^3.0
The package efureev/swoole-doctrine-dbal-pgsql-driver contains the following files
Loading the files please wait ...