PHPackages yiisoft/db - 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. [Framework](/categories/framework) 4. / 5. yiisoft/db ActiveLibrary[Framework](/categories/framework) yiisoft/db ========== Database abstraction layer and query builder 2.0.1(3mo ago)187468.4k↓28.9%45[26 issues](https://github.com/yiisoft/db/issues)[9 PRs](https://github.com/yiisoft/db/pulls)20BSD-3-ClausePHPPHP 8.1 - 8.5CI passing Since May 22Pushed 2mo ago23 watchersCompare [ Source](https://github.com/yiisoft/db)[ Packagist](https://packagist.org/packages/yiisoft/db)[ Docs](https://www.yiiframework.com/)[ GitHub Sponsors](https://github.com/sponsors/yiisoft)[ OpenCollective](https://opencollective.com/yiisoft)[ RSS](/packages/yiisoft-db/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (7)Dependencies (19)Versions (25)Used By (20) [ ![Yii](https://camo.githubusercontent.com/8317c17418b39410a660f5149071d26c5023c0d5fb2b7ebb771324812f666d73/68747470733a2f2f796969736f66742e6769746875622e696f2f646f63732f696d616765732f7969695f6c6f676f2e737667) ](https://github.com/yiisoft) Yii Database ============ [](#yii-database) [![Latest Stable Version](https://camo.githubusercontent.com/c8988f5bf3489f48da5b7cabc6b7cb7bed05abd864729d39e2cbb780bb6decbe/68747470733a2f2f706f7365722e707567782e6f72672f796969736f66742f64622f76)](https://packagist.org/packages/yiisoft/db)[![Total Downloads](https://camo.githubusercontent.com/7302ce1336e30b7679971c3c482445b4e5ad3bed35a3c0fc944d1532f492789d/68747470733a2f2f706f7365722e707567782e6f72672f796969736f66742f64622f646f776e6c6f616473)](https://packagist.org/packages/yiisoft/db)[![Build status](https://github.com/yiisoft/db/actions/workflows/build.yml/badge.svg?branch=master)](https://github.com/yiisoft/db/actions/workflows/build.yml?query=branch%3Amaster)[![Code Coverage](https://camo.githubusercontent.com/306ef62c67bceedddce2a0ca8fc407a8c55160494384dc84ad7012dd12a96ebc/68747470733a2f2f636f6465636f762e696f2f67682f796969736f66742f64622f6272616e63682f6d61737465722f67726170682f62616467652e737667)](https://codecov.io/gh/yiisoft/db)[![Mutation testing badge](https://camo.githubusercontent.com/2adb138426f67e4642588494d383f5d713e09bb59d6d6465f6e5c5c8e54a44cf/68747470733a2f2f696d672e736869656c64732e696f2f656e64706f696e743f7374796c653d666c61742675726c3d687474707325334125324625324662616467652d6170692e737472796b65722d6d757461746f722e696f2532466769746875622e636f6d253246796969736f667425324664622532466d6173746572)](https://dashboard.stryker-mutator.io/reports/github.com/yiisoft/db/master)[![Static analysis](https://github.com/yiisoft/db/actions/workflows/static.yml/badge.svg?branch=master)](https://github.com/yiisoft/db/actions/workflows/static.yml?query=branch%3Amaster)[![type-coverage](https://camo.githubusercontent.com/4743e314f618516741bff801857a986e69d4e8d64ff145a3a7a05d4692e80dc6/68747470733a2f2f73686570686572642e6465762f6769746875622f796969736f66742f64622f636f7665726167652e737667)](https://shepherd.dev/github/yiisoft/db)[![psalm-level](https://camo.githubusercontent.com/8cf0b9055d3e9e42318d21f978a63f07278d2730217acf9bab4460905957998a/68747470733a2f2f73686570686572642e6465762f6769746875622f796969736f66742f64622f6c6576656c2e737667)](https://shepherd.dev/github/yiisoft/db) Framework-agnostic database abstraction layer that provides a set of classes to connect and interact with various database management systems (DBMS) using a unified API, including a powerful query builder. Available database drivers: - [Yii DB MSSQL](https://github.com/yiisoft/db-mssql) - [Yii DB MySQL](https://github.com/yiisoft/db-mysql) (also supports MariaDB) - [Yii DB Oracle](https://github.com/yiisoft/db-oracle) - [Yii DB PostgreSQL](https://github.com/yiisoft/db-pgsql) - [Yii DB SQLite](https://github.com/yiisoft/db-sqlite) Optional packages that provide additional functionality: - [Yii Active Record](https://github.com/yiisoft/active-record) provides an object-oriented interface for working with database tables, similar to ORM frameworks such as Doctrine or Hibernate. - [Yii DB Migration](https://github.com/yiisoft/db-migration) allows you to manage database schema using migrations. Requirements ------------ [](#requirements) - PHP 8.1 - 8.5. - `pdo` PHP extension. Installation ------------ [](#installation) To install `yiisoft/db` you must install at least one database driver: - [`yiisoft/db-mysql`](https://github.com/yiisoft/db-mysql); - [`yiisoft/db-pgsql`](https://github.com/yiisoft/db-pgsql); - [`yiisoft/db-sqlite`](https://github.com/yiisoft/db-sqlite); - [`yiisoft/db-mssql`](https://github.com/yiisoft/db-mssql); - [`yiisoft/db-oracle`](https://github.com/yiisoft/db-oracle). Important It also depends on [PSR-16: Common Interface for Caching Libraries](https://www.php-fig.org/psr/psr-16/) and requires the installation of [PSR-16 implementation](https://packagist.org/providers/psr/simple-cache-implementation). For example, [yiisoft/cache](https://github.com/yiisoft/cache) or one of the other [cache handlers](https://github.com/yiisoft/cache#cache-handlers). General Usage ------------- [](#general-usage) To connect to a database, create an instance of the appropriate driver: ``` use Yiisoft\Db\Sqlite\Connection; use Yiisoft\Db\Sqlite\Driver; /** * @var Psr\SimpleCache\CacheInterface $cache */ // Creating a database connection $db = new Connection( new Driver('sqlite:memory:'), new SchemaCache($cache), ); ``` You can then use the `$db` object to execute SQL queries, manage transactions, and perform other database operations. Here are some examples: ``` use Yiisoft\Db\Connection\ConnectionInterface; /** * @var ConnectionInterface $db */ // Query builder $rows = $db ->select(['id', 'email']) ->from('{{%user}}') ->where(['last_name' => 'Smith']) ->limit(10) ->all(); // Insert $db->createCommand() ->insert( '{{%user}}', [ 'email' => 'mike@example.com', 'first_name' => 'Mike', 'last_name' => 'Smith', ], ) ->execute(); // Transaction $db->transaction( static function (ConnectionInterface $db) { $db->createCommand() ->update('{{%user}}', ['status' => 'active'], ['id' => 1]) ->execute(); $db->createCommand() ->update('{{%profile}}', ['visibility' => 'public'], ['user_id' => 1]) ->execute(); } ) ``` Documentation ------------- [](#documentation) - Guide: [English](docs/guide/en/README.md), [Português - Brasil](docs/guide/pt-BR/README.md) - [Internals](docs/internals.md) If you need help or have a question, the [Yii Forum](https://forum.yiiframework.com/c/yii-3-0/63) is a good place for that. You may also check out other [Yii Community Resources](https://www.yiiframework.com/community). License ------- [](#license) The Yii Database is free software. It is released under the terms of the BSD License. Please see [`LICENSE`](./LICENSE.md) for more information. Maintained by [Yii Software](https://www.yiiframework.com/). Support the project ------------------- [](#support-the-project) [![Open Collective](https://camo.githubusercontent.com/a2b15f8e2268d4e3842e00d41ff7a57cce2ad8bd8d8769c5dc4fa05a546a4f62/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4f70656e253230436f6c6c6563746976652d73706f6e736f722d3765616466313f6c6f676f3d6f70656e253230636f6c6c656374697665266c6f676f436f6c6f723d376561646631266c6162656c436f6c6f723d353535353535)](https://opencollective.com/yiisoft) Follow updates -------------- [](#follow-updates) [![Official website](https://camo.githubusercontent.com/d6b0929173e28cc627430d2519ca1853466a70f37395877eaf4820cb3e1e1909/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f506f77657265645f62792d5969695f4672616d65776f726b2d677265656e2e7376673f7374796c653d666c6174)](https://www.yiiframework.com/)[![Twitter](https://camo.githubusercontent.com/d077c362ac639792171af8bc002ee827816733dfc0925f70b557e6d151022226/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f747769747465722d666f6c6c6f772d3144413146323f6c6f676f3d74776974746572266c6f676f436f6c6f723d314441314632266c6162656c436f6c6f723d3535353535353f7374796c653d666c6174)](https://twitter.com/yiiframework)[![Telegram](https://camo.githubusercontent.com/4e38dd12535575c39c65bea7119b95e663abb2d1f4e3d669a27bbda07ef603f0/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f74656c656772616d2d6a6f696e2d3144413146323f7374796c653d666c6174266c6f676f3d74656c656772616d)](https://t.me/yii3en)[![Facebook](https://camo.githubusercontent.com/48204e301b34b29b0815854544f04c337fc0692096cab35e9a1f8c53a42c2307/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f66616365626f6f6b2d6a6f696e2d3144413146323f7374796c653d666c6174266c6f676f3d66616365626f6f6b266c6f676f436f6c6f723d666666666666)](https://www.facebook.com/groups/yiitalk)[![Slack](https://camo.githubusercontent.com/1a3645ba1c97e6684d0349bc478201e1621ba0d3efad516d81035364d442bad7/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f736c61636b2d6a6f696e2d3144413146323f7374796c653d666c6174266c6f676f3d736c61636b)](https://yiiframework.com/go/slack) ### Health Score 66 — FairBetter than 99% of packages Maintenance81 Actively maintained with recent releases Popularity55 Moderate usage in the ecosystem Community46 Growing community involvement Maturity75 Established project with proven stability Bus Factor3 3 contributors hold 50%+ of commits 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 ~172 days Recently: every ~227 days Total 7 Last Release 98d ago Major Versions 1.3.0 → 2.0.02025-12-05 PHP version history (2 changes)1.0.0PHP ^8.0 2.0.0PHP 8.1 - 8.5 ### Community Maintainers ![](https://www.gravatar.com/avatar/261a6249c6f605f3956a2fae40fbb813f6b2e1e6f2bf806180c851a965426e54?d=identicon)[cebe](/maintainers/cebe) ![](https://www.gravatar.com/avatar/fc29e4e7068a00fe9b9db37b8aadda1db6020adcacef810461e47b99c2b150e6?d=identicon)[samdark](/maintainers/samdark) ![](https://www.gravatar.com/avatar/ccb75e3312d6bd454ea445ea308139fd185a4ca906ca5df21cc66e6a35de25a3?d=identicon)[SilverFire](/maintainers/SilverFire) ![](https://www.gravatar.com/avatar/99106256c24a8cb23871b99fa90e48f37f1aa71608c185759b7d2a88683a5918?d=identicon)[hiqsol](/maintainers/hiqsol) --- Top Contributors [![qiangxue](https://avatars.githubusercontent.com/u/993322?v=4)](https://github.com/qiangxue "qiangxue (1773 commits)")[![samdark](https://avatars.githubusercontent.com/u/47294?v=4)](https://github.com/samdark "samdark (1452 commits)")[![cebe](https://avatars.githubusercontent.com/u/189796?v=4)](https://github.com/cebe "cebe (1212 commits)")[![klimov-paul](https://avatars.githubusercontent.com/u/1482054?v=4)](https://github.com/klimov-paul "klimov-paul (602 commits)")[![terabytesoftw](https://avatars.githubusercontent.com/u/42547589?v=4)](https://github.com/terabytesoftw "terabytesoftw (376 commits)")[![SilverFire](https://avatars.githubusercontent.com/u/4499203?v=4)](https://github.com/SilverFire "SilverFire (305 commits)")[![Tigrov](https://avatars.githubusercontent.com/u/8563175?v=4)](https://github.com/Tigrov "Tigrov (180 commits)")[![Ragazzo](https://avatars.githubusercontent.com/u/1748844?v=4)](https://github.com/Ragazzo "Ragazzo (129 commits)")[![vjik](https://avatars.githubusercontent.com/u/525501?v=4)](https://github.com/vjik "vjik (122 commits)")[![darkdef](https://avatars.githubusercontent.com/u/8342004?v=4)](https://github.com/darkdef "darkdef (114 commits)")[![creocoder](https://avatars.githubusercontent.com/u/896494?v=4)](https://github.com/creocoder "creocoder (99 commits)")[![schmunk42](https://avatars.githubusercontent.com/u/649031?v=4)](https://github.com/schmunk42 "schmunk42 (78 commits)")[![resurtm](https://avatars.githubusercontent.com/u/100198?v=4)](https://github.com/resurtm "resurtm (74 commits)")[![suralc](https://avatars.githubusercontent.com/u/730039?v=4)](https://github.com/suralc "suralc (40 commits)")[![thiagotalma](https://avatars.githubusercontent.com/u/612578?v=4)](https://github.com/thiagotalma "thiagotalma (35 commits)")[![cuileon](https://avatars.githubusercontent.com/u/313312?v=4)](https://github.com/cuileon "cuileon (34 commits)")[![kartik-v](https://avatars.githubusercontent.com/u/3592619?v=4)](https://github.com/kartik-v "kartik-v (33 commits)")[![sergeymakinen](https://avatars.githubusercontent.com/u/983964?v=4)](https://github.com/sergeymakinen "sergeymakinen (32 commits)")[![rob006](https://avatars.githubusercontent.com/u/5972388?v=4)](https://github.com/rob006 "rob006 (31 commits)")[![hiqsol](https://avatars.githubusercontent.com/u/11820365?v=4)](https://github.com/hiqsol "hiqsol (30 commits)") --- Tags databasedbalquery-buildersqlyii3databasedbalsqlyiiquery builder ### Code Quality TestsPHPUnit Static AnalysisRector Code StylePHP CS Fixer ### Embed Badge ![Health badge](/badges/yiisoft-db/health.svg) ``` [![Health](https://phpackages.com/badges/yiisoft-db/health.svg)](https://phpackages.com/packages/yiisoft-db) ``` ### 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)[yiisoft/db-mysql MySQL/MariaDB driver for Yii Database 42169.1k17](/packages/yiisoft-db-mysql)[yiisoft/db-pgsql PostgreSQL driver for Yii Database 39164.6k6](/packages/yiisoft-db-pgsql)[yiisoft/db-sqlite SQLite driver for Yii Database 30173.4k10](/packages/yiisoft-db-sqlite)[yiisoft/db-oracle Oracle driver for Yii Database 3361.3k3](/packages/yiisoft-db-oracle)[yiisoft/db-mssql Microsoft SQL Server driver for Yii Database 2877.0k3](/packages/yiisoft-db-mssql) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)