PHPackages jardisadapter/dbconnection - 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. jardisadapter/dbconnection ActiveLibrary[Database & ORM](/categories/database) jardisadapter/dbconnection ========================== PDO connection factory with read/write splitting, round-robin load balancing, and automatic health checks v1.0.0(2mo ago)075↓50%2proprietaryPHPPHP >=8.2CI passing Since Mar 18Pushed 1mo agoCompare [ Source](https://github.com/jardisAdapter/dbConnection)[ Packagist](https://packagist.org/packages/jardisadapter/dbconnection)[ Docs](https://github.com/jardisAdapter/dbConnection)[ RSS](/packages/jardisadapter-dbconnection/feed)WikiDiscussions main Synced 1mo ago READMEChangelog (1)Dependencies (10)Versions (6)Used By (2) Jardis DbConnection =================== [](#jardis-dbconnection) [![Build Status](https://github.com/jardisAdapter/dbConnection/actions/workflows/ci.yml/badge.svg)](https://github.com/jardisAdapter/dbConnection/actions/workflows/ci.yml/badge.svg)[![License: PolyForm Shield](https://camo.githubusercontent.com/d8fb46c82be4c5312bf3e372ac734dfdf6a8b328e9c2b2856af671adbb0600a5/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4c6963656e73652d506f6c79466f726d253230536869656c642d626c75652e737667)](LICENSE.md)[![PHP Version](https://camo.githubusercontent.com/a68b290dcc313d698dc138a1111aa83eee2f143605449d7e8b5416ea6f88558f/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048502d253345253344382e322d3737374242342e737667)](https://www.php.net/)[![PHPStan Level](https://camo.githubusercontent.com/c51bda247654363d3e30bc352674dd761a9557803a14af0226eb411d6dc0006b/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5048505374616e2d4c6576656c253230382d627269676874677265656e2e737667)](phpstan.neon)[![PSR-12](https://camo.githubusercontent.com/34b10db0caa29bacd49bda5c437a8de95385f036f3230b31fa605326e18da22c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f436f64652532305374796c652d5053522d2d31322d626c75652e737667)](phpcs.xml)[![Coverage](https://camo.githubusercontent.com/a421b9299f5ee580e853b0dbf74ea8f870e6ea5318843157d00c7181a7710a68/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f436f7665726167652d38392e34392532352d677265656e2e737667)](https://github.com/jardisAdapter/dbConnection) > Part of the **[Jardis Business Platform](https://jardis.io)** — Enterprise-grade PHP components for Domain-Driven Design PDO connection factory with read/write splitting, round-robin load balancing, and automatic health checks. Create typed connections for MySQL, PostgreSQL, or SQLite via `ConnectionFactory`, then compose them into a `ConnectionPool` for replica-aware query routing. Health checks run `SELECT 1` with a configurable TTL cache so failover is fast and non-intrusive. --- Features -------- [](#features) - **Read/Write Splitting** — Route writes to the primary and reads to replicas automatically - **Round-Robin Load Balancing** — Distributes read queries evenly across all configured readers - **Health Checks** — `SELECT 1` validation with positive and negative result caching - **Transaction Support** — `beginTransaction()`, `commit()`, `rollback()`, `inTransaction()` on every connection - **Reconnect** — `reconnect()` rebuilds the PDO connection from config on failure - **MySQL / PostgreSQL / SQLite** — Dedicated factory methods per driver with typed config - **External PDO Wrapping** — `fromPdo()` integrates existing connections without refactoring - **ConnectionPool Stats** — `getStats()` exposes reads, writes, and failover counts at runtime --- Installation ------------ [](#installation) ``` composer require jardisadapter/dbconnection ``` Quick Start ----------- [](#quick-start) ``` use JardisAdapter\DbConnection\Factory\ConnectionFactory; $factory = new ConnectionFactory(); // Create a MySQL connection and run a query $connection = $factory->mysql( host: 'localhost', user: 'app_user', password: 'secret', database: 'mydb' ); $pdo = $connection->pdo(); $users = $pdo->query('SELECT * FROM users')->fetchAll(); ``` Advanced Usage -------------- [](#advanced-usage) ``` use JardisAdapter\DbConnection\Factory\ConnectionFactory; use JardisAdapter\DbConnection\ConnectionPool; use JardisAdapter\DbConnection\Config\ConnectionPoolConfig; $factory = new ConnectionFactory(); // Primary writer + two read replicas $pool = new ConnectionPool( writer: $factory->mysql('primary.db', 'user', 'secret', 'mydb'), readers: [ $factory->mysql('replica1.db', 'user', 'secret', 'mydb'), $factory->mysql('replica2.db', 'user', 'secret', 'mydb'), ], config: new ConnectionPoolConfig(validateConnections: true) ); // Writes go to the primary $pool->getWriter()->pdo()->exec('INSERT INTO orders (total) VALUES (99.99)'); // Reads are distributed round-robin across replicas $orders = $pool->getReader()->pdo()->query('SELECT * FROM orders')->fetchAll(); // Inspect pool activity $stats = $pool->getStats(); // ['reads' => 1, 'writes' => 1, 'failovers' => 0, 'readers' => 2] // Transactions on a dedicated connection $conn = $factory->postgres('localhost', 'user', 'secret', 'mydb'); $conn->beginTransaction(); try { $conn->pdo()->exec('UPDATE accounts SET balance = balance - 100 WHERE id = 1'); $conn->pdo()->exec('UPDATE accounts SET balance = balance + 100 WHERE id = 2'); $conn->commit(); } catch (\Throwable $e) { $conn->rollback(); throw $e; } // Wrap an existing PDO from a legacy system $legacy = $factory->fromPdo($existingPdo); ``` PDO Connection Options ---------------------- [](#pdo-connection-options) All driver factory methods accept an `options` array passed directly to the PDO constructor. This is useful for long-running processes (RoadRunner, Swoole, FrankenPHP) where persistent connections avoid reconnect overhead per request: ``` use PDO; $connection = $factory->mysql( host: 'localhost', user: 'app_user', password: 'secret', database: 'mydb', options: [ PDO::ATTR_PERSISTENT => true, PDO::ATTR_TIMEOUT => 5, ] ); ``` > **Note:** Persistent connections are reused across requests within the same worker process. Ensure your database server is configured for the expected number of concurrent connections (workers × connections per worker). These options apply per connection — in a `ConnectionPool`, each connection can have its own settings. Documentation ------------- [](#documentation) Full documentation, guides, and API reference: **[docs.jardis.io/adapter/dbconnection](https://docs.jardis.io/adapter/dbconnection)** License ------- [](#license) This package is licensed under the [PolyForm Shield License 1.0.0](LICENSE.md). Free for all use except building competing frameworks or developer tooling. --- **[Jardis](https://jardis.io)** · [Documentation](https://docs.jardis.io) · [Headgent](https://headgent.com) ### Health Score 43 — FairBetter than 91% of packages Maintenance89 Actively maintained with recent releases Popularity13 Limited adoption so far Community10 Small or concentrated contributor base Maturity50 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 ~20 days Total 2 Last Release 61d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/e07a1b668e9e01ee6d1b85de7b3be1c2513f68aae9494b2011d1592104d5daa0?d=identicon)[jardis](/maintainers/jardis) --- Top Contributors [![Headgent](https://avatars.githubusercontent.com/u/245725954?v=4)](https://github.com/Headgent "Headgent (1 commits)") --- Tags databasepdoadapterConnectionDomain Driven DesignHeadgentJardisAdapter ### Code Quality TestsPHPUnit Static AnalysisPHPStan Code StylePHP\_CodeSniffer Type Coverage Yes ### Embed Badge ![Health badge](/badges/jardisadapter-dbconnection/health.svg) ``` [![Health](https://phpackages.com/badges/jardisadapter-dbconnection/health.svg)](https://phpackages.com/packages/jardisadapter-dbconnection) ``` ### Alternatives [doctrine/dbal Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. 9.7k578.4M5.6k](/packages/doctrine-dbal)[ifsnop/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k5.5M69](/packages/ifsnop-mysqldump-php)[nette/database 💾 Nette Database: layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle. 5656.7M234](/packages/nette-database)[dibi/dibi Dibi is Database Abstraction Library for PHP 5013.8M120](/packages/dibi-dibi)[atlas/pdo Provides a PDO instance decorator with convenience methods, and a connection manager. 18258.0k8](/packages/atlas-pdo) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)