PHPackages swlib/swpdo - 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. swlib/swpdo ActiveLibrary[Database & ORM](/categories/database) swlib/swpdo =========== Swoole Coroutine SQL component like PDO 1.0.0-alpha(8y ago)6112.6k↓42%31Apache-2.0PHPPHP >=7.0 Since Apr 8Pushed 7y ago4 watchersCompare [ Source](https://github.com/swlib/swpdo)[ Packagist](https://packagist.org/packages/swlib/swpdo)[ RSS](/packages/swlib-swpdo/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (1)Dependencies (2)Versions (2)Used By (1) SwPDO ===== [](#swpdo) [![Latest Version](https://camo.githubusercontent.com/446da8400d5c334053cd7807fa1a41d6d33e5f29a26499b9054b726bb7cf0b5f/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f72656c656173652f73776c69622f737770646f2e7376673f7374796c653d666c61742d737175617265)](https://github.com/swlib/swpdo/releases)[![Build Status](https://camo.githubusercontent.com/f608d047d55038321d30db522255f6b7b08c975eba2d14b3df64055d6eb845d2/68747470733a2f2f7472617669732d63692e6f72672f73776c69622f737770646f2e7376673f6272616e63683d6d6173746572)](https://github.com/swlib/swpdo/releases)[![Php Version](https://camo.githubusercontent.com/c197ef1e57a32c886b2a54d02ead7dbc035f18b3f39a642703b9372eef7819f9/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d2533453d372e312d627269676874677265656e2e7376673f6d61784167653d32353932303030)](https://secure.php.net/)[![Swoole Version](https://camo.githubusercontent.com/5f51ec804098b72ea73375ef1e26431790778149effa36ffe807f0e251d34d8c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f73776f6f6c652d2533453d322e312e322d627269676874677265656e2e7376673f6d61784167653d32353932303030)](https://github.com/swoole/swoole-src)[![SwPDO License](https://camo.githubusercontent.com/1c419f89412ea6c234c184ad6d85decb127c18584858d3707ae7d8e2131eccc4/68747470733a2f2f696d672e736869656c64732e696f2f686578706d2f6c2f706c75672e7376673f6d61784167653d32353932303030)](https://github.com/swlib/swpdo/blob/master/LICENSE) Introduction ------------ [](#introduction) Traditional PDO to Swoole Coroutine migration plan without cost. [中文文档](README-zh.md) Install ------- [](#install) The best way to install: [Composer](http://getcomposer.org/) : ``` composer require swlib/swpdo ``` Coroutine --------- [](#coroutine) The bottom layer of Swoole implements coroutine scheduling, **and the business layer does not need to be aware**. Developers can use synchronization code writing methods to achieve the effect and ultra-high performance of asynchronous IO without perception, avoiding the discrete code logic and trapping caused by traditional asynchronous callbacks. Too many callback layers causes the code too difficult to maintain. It needs to be used in event callback functions such as `onRequet`, `onReceive`, and `onConnect`, or wrapped using the go keyword (`swoole.use_shortname` is on by default). Example ------- [](#example) > Because PDO uses multiple engines, it is difficult at the PHP level to return different instances with class - implemented constructors. **Except that the constructor is different, all methods use in the same way.** #### query [](#query) ``` $options = [ 'mysql:host=127.0.0.1;dbname=test;charset=UTF8', 'root', 'root' ]; $sql = 'select * from `user` LIMIT 1'; //PDO $pdo = new \PDO(...$options); $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); //strong type $pdo_both = $pdo->query($sql)->fetch(); $pdo_assoc = $pdo->query($sql)->fetch(\PDO::FETCH_ASSOC); $pdo_object = $pdo->query($sql)->fetch(\PDO::FETCH_OBJ); $pdo_number = $pdo->query($sql)->fetch(\PDO::FETCH_NUM); //SwPDO $swpdo = SwPDO::construct(...$options); //default is strong type $swpdo_both = $swpdo->query($sql)->fetch(); $swpdo_assoc = $swpdo->query($sql)->fetch(\PDO::FETCH_ASSOC); $swpdo_object = $swpdo->query($sql)->fetch(\PDO::FETCH_OBJ); $swpdo_number = $swpdo->query($sql)->fetch(\PDO::FETCH_NUM); var_dump($pdo_both === $swpdo_both); var_dump($pdo_assoc === $swpdo_assoc); var_dump($pdo_object == $swpdo_object); var_dump($pdo_number === $swpdo_number); //output: true true true true ``` #### prepare [](#prepare) ``` //PDO $pdo = new \PDO(...$options); $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); //strong type $statement = $pdo->prepare($sql); $statement->execute(); $pdo_fetch = $statement->fetch(\PDO::FETCH_ASSOC); $statement->execute(); $pdo_fetch_all = $statement->fetchAll(); $statement->execute(); $pdo_fetch_all_column = $statement->fetchAll(\PDO::FETCH_COLUMN, 1); $statement->execute(); $pdo_fetch_column = $statement->fetchColumn(); $statement->execute(); //SwPDO $swpdo = SwPDO::construct(...$options); $statement = $swpdo->prepare($sql); $statement->execute(); $swpdo_fetch = $statement->fetch(\PDO::FETCH_ASSOC); $statement->execute(); $swpdo_fetch_all = $statement->fetchAll(); $statement->execute(); $swpdo_fetch_all_column = $statement->fetchAll(\PDO::FETCH_COLUMN, 1); $statement->execute(); $swpdo_fetch_column = $statement->fetchColumn(); $statement->execute(); var_dump($pdo_fetch === $swpdo_fetch); //true var_dump($pdo_fetch_all === $swpdo_fetch_all); //true var_dump($pdo_fetch_all_column === $swpdo_fetch_all_column); //true var_dump($pdo_fetch_column === $swpdo_fetch_column); //true ``` ### bind [](#bind) ``` //PDO $pdo = new \PDO(...$options); $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); //strong type $statement = $pdo->prepare($sql); $statement->execute(['id' => 1]); $pdo_bind_exec = $statement->fetch(\PDO::FETCH_ASSOC); $statement->bindValue(':id', 1); $statement->execute(); $pdo_bind_val = $statement->fetch(\PDO::FETCH_ASSOC); $statement->bindParam(':id', $id); $statement->execute(); $pdo_bind_param = $statement->fetch(\PDO::FETCH_ASSOC); //SwPDO $swpdo = SwPDO::construct(...$options); $statement = $swpdo->prepare($sql); $statement->execute(['id' => 1]); $swpdo_bind_exec = $statement->fetch(\PDO::FETCH_ASSOC); $statement->bindValue(':id', 1); $statement->execute(); $swpdo_bind_val = $statement->fetch(\PDO::FETCH_ASSOC); $statement->bindParam(':id', $id); $statement->execute(); $swpdo_bind_param = $statement->fetch(\PDO::FETCH_ASSOC); var_dump($pdo_bind_exec === $swpdo_bind_exec); //true var_dump($pdo_bind_val === $swpdo_bind_val); //true var_dump($pdo_bind_param === $swpdo_bind_param); //true ``` ### Health Score 31 — LowBetter than 68% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity37 Limited adoption so far Community13 Small or concentrated contributor base Maturity44 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 Unknown Total 1 Last Release 2963d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/1bdf9390d85a45dad64fe58584f55824c12a134a04e338d6259845683d9db137?d=identicon)[twosee](/maintainers/twosee) --- Top Contributors [![twose](https://avatars.githubusercontent.com/u/25978241?v=4)](https://github.com/twose "twose (7 commits)") --- Tags coroutinemysqlpdoswoolephpmysqlpdoswoole ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/swlib-swpdo/health.svg) ``` [![Health](https://phpackages.com/badges/swlib-swpdo/health.svg)](https://phpackages.com/packages/swlib-swpdo) ``` ### Alternatives [ifsnop/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k5.5M69](/packages/ifsnop-mysqldump-php)[clouddueling/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k22.9k](/packages/clouddueling-mysqldump-php)[eftec/pdoone Minimaist procedural PDO wrapper library 1105.9k9](/packages/eftec-pdoone)[popphp/pop-db Pop Db Component for Pop PHP Framework 1814.6k11](/packages/popphp-pop-db)[riverside/php-orm PHP ORM micro-library and query builder 111.2k](/packages/riverside-php-orm) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)