PHPackages                             ryunosuke/dbml - 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. ryunosuke/dbml

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

ryunosuke/dbml
==============

Database Manipulation Layer

v3.1.15(5mo ago)05871MITPHPPHP >=8.0CI failing

Since Jul 11Pushed 1mo ago1 watchersCompare

[ Source](https://github.com/arima-ryunosuke/dbml)[ Packagist](https://packagist.org/packages/ryunosuke/dbml)[ RSS](/packages/ryunosuke-dbml/feed)WikiDiscussions master Synced 2w ago

READMEChangelogDependencies (9)Versions (87)Used By (0)

dbml (Database Manipulation layer)
==================================

[](#dbml-database-manipulation-layer)

Description
-----------

[](#description)

Doctrine/dbal を使用して CRUD 操作に特化したライブラリです。

対応（テスト済み）RDBMS

- sqlite 3.8
- MySQL 8.0.23
- PostgreSQL 16.3
- SQLServer 2022

ドキュメントは下記においてあります。

- [クラスリファレンス](https://arima-ryunosuke.github.io/dbml/)

Install
-------

[](#install)

```
{
    "require": {
        "ryunosuke/dbml": "dev-master"
    }
}
```

Usage
-----

[](#usage)

```
$db = new \ryunosuke\dbml\Database([
    'driver'   => 'pdo_mysql',
    'host'     => '127.0.0.1',
    'port'     => '3306',
    'dbname'   => 'dbname',
    'user'     => 'user',
    'password' => 'password',
    'charset'  => 'utf8',
], [
    /* オプション配列 */
]);
```

要するに設定情報（\\Doctrine\\DBAL\\DriverManager に渡す配列）をコンストラクタ引数に渡します。 原則としてこの Database インスタンスのみ使用し、他のクラスは直接的には使用しません。 上記のように $db インスタンスを作成してあとはこの $db を使用してデータベースアクセスします。

往々にしてクエリビルダを使用するかゲートウェイを使用することが多いです。 基本的な CRUD のコードを以下に記します。

```
// t_article のレコードを全件取得
$db->selectArray('t_article'); // クエリビルダ版
$db->t_article->array();       // ゲートウェイ版

// t_article にレコードを追加する
$db->insert('t_article', [
    'article_title' => 'title',
    'content'       => 'content',
]);
$db->t_article->insert([
    'article_title' => 'title',
    'content'       => 'content',
]);

// t_article のレコードを更新する
$db->update('t_article', [
    'article_title' => 'title2',
    'content'       => 'content2',
], [
    'article_id' => 1,
]);
$db->t_article->update([
    'article_title' => 'title2',
    'content'       => 'content2',
], [
    'article_id' => 1,
]);

// t_article のレコードを削除する
$db->delete('t_article', [
    'article_id' => 1,
]);
$db->t_article->delete([
    'article_id' => 1,
]);
```

実際は JOIN ができたり下位テーブルを階層で取得できたり、 WHERE に条件が埋め込めたりしますが、そのような細かい使い方は[クラスリファレンス](https://arima-ryunosuke.github.io/document/dbml/)を参照。

License
-------

[](#license)

MIT

###  Health Score

51

—

FairBetter than 95% of packages

Maintenance82

Actively maintained with recent releases

Popularity15

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity84

Battle-tested with a long release history

 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 ~34 days

Total

84

Last Release

41d ago

Major Versions

v2.1.24 → v3.1.62025-05-30

v2.1.26 → v3.1.102025-08-06

v2.1.27 → v3.1.112025-08-11

v2.1.28 → v3.1.122025-08-11

v2.1.30 → v3.1.152026-01-08

PHP version history (4 changes)v1.0.0PHP >=7.1

v2.0.0PHP >=7.2

v2.0.11PHP >=7.4

v3.0.0PHP >=8.0

### Community

Maintainers

![](https://www.gravatar.com/avatar/e51e177034dd7673cfaa86a43d5236ed7a6bc94f32d05c9100b039d908cd1174?d=identicon)[arima-ryunosuke](/maintainers/arima-ryunosuke)

---

Top Contributors

[![arima-ryunosuke](https://avatars.githubusercontent.com/u/7457522?v=4)](https://github.com/arima-ryunosuke "arima-ryunosuke (704 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/ryunosuke-dbml/health.svg)

```
[![Health](https://phpackages.com/badges/ryunosuke-dbml/health.svg)](https://phpackages.com/packages/ryunosuke-dbml)
```

###  Alternatives

[martin-georgiev/postgresql-for-doctrine

Extends Doctrine with native PostgreSQL support for arrays, JSONB, ranges, PostGIS geometries, text search, ltree, uuid, and 100+ PostgreSQL-specific functions.

4535.7M4](/packages/martin-georgiev-postgresql-for-doctrine)[flow-php/flow

PHP ETL - Extract Transform Load - Data processing framework

84735.1k](/packages/flow-php-flow)[shopware/core

Shopware platform is the core for all Shopware ecommerce products.

585.4M526](/packages/shopware-core)[patchlevel/event-sourcing

A lightweight but also all-inclusive event sourcing library with a focus on developer experience

202332.6k12](/packages/patchlevel-event-sourcing)[flow-php/doctrine-dbal-bulk

Bulk inserts and updates for Doctrine DBAL

14361.1k3](/packages/flow-php-doctrine-dbal-bulk)

PHPackages © 2026

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