PHPackages                             janfish/swoole-db-orm - 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. janfish/swoole-db-orm

ActiveLibrary[Database & ORM](/categories/database)

janfish/swoole-db-orm
=====================

Swoole DB ORM

314PHP

Since May 28Pushed 5y ago1 watchersCompare

[ Source](https://github.com/zeng444/swoole-orm-db)[ Packagist](https://packagist.org/packages/janfish/swoole-db-orm)[ RSS](/packages/janfish-swoole-db-orm/feed)WikiDiscussions master Synced 2mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

Phalcon DB Layer 协程版
====================

[](#phalcon-db-layer-协程版)

> 支持swoole4.3.\* 及 swole4.4.\*

特色
--

[](#特色)

- 基于Swoole Mysql驱动重写的phalcon db layer，方法和phalcon手册一致
- 基于Swoole实现连接池，可以基于连接池基类实现各种类型连接池
- 基于连接池实现的协程版phalcon db layer
- 基于swoole常驻内存的特点，增加了数据库断线自动重连

基本操作同
-----

[](#基本操作同)

协程操作
----

[](#协程操作)

- 申明defer和recv实现协程通讯

```
$db =  $di->db;
$db2 =  $di->db;

$db->setDefer();
$db2->setDefer();

$statement = $mysql->query($sql);
$statement2 = $mysql2->query($sql);

$result = $db->recv();
$result2 = $db2->recv();

if (!$result) {
    echo "error:".$mysql->errno.$mysql->error.PHP_EOL;
}
if (!$result2) {
    echo "error:".$mysql->errno.$mysql->error.PHP_EOL;
}

$row = $statement->fetch();
$row2 = $statement2->fetch();

print_r($row);
print_r($row2);
```

- 写入通讯并发

```
for($i=0;$idb;
    $db->setDefer();
    $db->execute($sql);
    $result = $db->recv();
    if (!$result) {
        echo "error:".$mysql->errno.$mysql->error.PHP_EOL;
    }
}
```

数据库连接池
------

[](#数据库连接池)

- 已经集成在Janfish\\Swoole\\Coroutine\\Db\\Adapter\\Pdo\\Myql
- 创建带有数据库连接池的数据库实例和标准单一数据库实例

```
use Janfish\Swoole\Coroutine\Db\Adapter\Pdo\Myql;
use Janfish\Swoole\Pool\Db\Mysql as MysqlPool

// 连接配置
$descriptor = [
    "host" => "mysql",
    "username" => "root",
    "password" => "root",
    "dbname" => "car_insurance_genius_v2_prod",
    "port" => 3306,
    "charset" => 'utf8mb4',
    'options' => [
        \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4',
    ],
];

// 普通数据库实例
$mysql = new Myql( $descriptor);

// 数据库连接池的数据库实例
$mysql = new Myql(new MysqlPool($descriptor,[
   'min'=>100, //最小连接进程
   'max'=>100, //最大连接进程
   'min_spare_minute'=>2, //gc回收周期单位分钟
   'min_spare'=>100, //最小空闲进程
   'max_spare'=>100 //最大空闲进程
]) );
```

连接池
---

[](#连接池)

- 实现一个Redis连接池

```
use Janfish\Swoole\Pool;
use Janfish\Swoole\Pool\PoolInterface;

/**
 *
 * Class RedisPool
 */
class RedisPool extends Pool implements PoolInterface
{

    /**
     * @var array|null
     */
    private $_descriptor = [];

    /**
     * @param array|null $descriptor
     * @param array $options
     */
    public function __construct(array $descriptor, array $options)
    {
        if ($descriptor) {
            $this->_descriptor = $descriptor;
        }
        parent::__construct($options);
    }

    /**
     * Author:Robert
     *
     * @return bool|PdoMysql
     * @throws Exception
     */
    public function createConnection()
    {
        $connection = new Redis($this->_descriptor);
        if (!$connection->connect()) {
            throw new Exception('failure to create connection for redis pool');
        }
        return $connection;
    }

    /**
     * Author:Robert
     *
     * @param PdoMysql $connection
     * @return bool
     */
    public function closeConnection($connection): bool
    {
        return $connection->close();
    }

}
```

连接池方法
-----

[](#连接池方法)

```
$pool = new RedisPool(['host'=>'127.0.0.1'],['min'=>10,'max'=>1000]);
$redis = $pool->getConnection();
$redis->set("key","val");
$redis->returnConnection();

```

###  Health Score

19

—

LowBetter than 10% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity9

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity33

Early-stage or recently created project

 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.

### Community

Maintainers

![](https://www.gravatar.com/avatar/60a62fd9f299f25558ac4a898ae3833bd7185ba4706bb167a8cabf05a3d96955?d=identicon)[Robert Zeng](/maintainers/Robert%20Zeng)

---

Top Contributors

[![zeng444](https://avatars.githubusercontent.com/u/941266?v=4)](https://github.com/zeng444 "zeng444 (33 commits)")

### Embed Badge

![Health badge](/badges/janfish-swoole-db-orm/health.svg)

```
[![Health](https://phpackages.com/badges/janfish-swoole-db-orm/health.svg)](https://phpackages.com/packages/janfish-swoole-db-orm)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.3k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M543](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M209](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)