PHPackages                             yiisoft/log-target-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/log-target-db

ActiveLibrary[Framework](/categories/framework)

yiisoft/log-target-db
=====================

Yii Logging Library - DB Target

1.1.0(3mo ago)131675[1 PRs](https://github.com/yiisoft/log-target-db/pulls)BSD-3-ClausePHPPHP ^8.1CI passing

Since Mar 31Pushed 1mo ago14 watchersCompare

[ Source](https://github.com/yiisoft/log-target-db)[ Packagist](https://packagist.org/packages/yiisoft/log-target-db)[ Docs](https://www.yiiframework.com/)[ GitHub Sponsors](https://github.com/sponsors/yiisoft)[ OpenCollective](https://opencollective.com/yiisoft)[ RSS](/packages/yiisoft-log-target-db/feed)WikiDiscussions master Synced today

READMEChangelog (2)Dependencies (10)Versions (4)Used By (0)

 [ ![Yii](https://camo.githubusercontent.com/8317c17418b39410a660f5149071d26c5023c0d5fb2b7ebb771324812f666d73/68747470733a2f2f796969736f66742e6769746875622e696f2f646f63732f696d616765732f7969695f6c6f676f2e737667) ](https://github.com/yiisoft)

Yii Logging Library - DB Target
===============================

[](#yii-logging-library---db-target)

[![Latest Stable Version](https://camo.githubusercontent.com/c9fa4d5a5d545c639c83767333218d194658fbea4a479d9b52657d3b51f84cfc/68747470733a2f2f706f7365722e707567782e6f72672f796969736f66742f6c6f672d7461726765742d64622f762f737461626c652e706e67)](https://packagist.org/packages/yiisoft/log-target-db)[![Total Downloads](https://camo.githubusercontent.com/f6847f8cfaa5f4808c1f04a2d6ea2cd17d7860e0694cf77f8c77689287f665d5/68747470733a2f2f706f7365722e707567782e6f72672f796969736f66742f6c6f672d7461726765742d64622f646f776e6c6f6164732e706e67)](https://packagist.org/packages/yiisoft/log-target-db)[![codecov](https://camo.githubusercontent.com/6817c3e46259aedeea65a66fd5b070725a879bfa2a523c9168f1c4638b043748/68747470733a2f2f636f6465636f762e696f2f67682f796969736f66742f6c6f672d7461726765742d64622f6272616e63682f6d61737465722f67726170682f62616467652e7376673f746f6b656e3d415037564b385a594946)](https://codecov.io/gh/yiisoft/log-target-db)[![Mutation testing badge](https://camo.githubusercontent.com/7ca99754afdb1a8c4f1336585da9a259c7ea38c26516e626e12b54aa7463a713/68747470733a2f2f696d672e736869656c64732e696f2f656e64706f696e743f7374796c653d666c61742675726c3d687474707325334125324625324662616467652d6170692e737472796b65722d6d757461746f722e696f2532466769746875622e636f6d253246796969736f66742532466c6f672d7461726765742d64622532466d6173746572)](https://dashboard.stryker-mutator.io/reports/github.com/yiisoft/log-target-db/master)[![static analysis](https://github.com/yiisoft/log-target-db/workflows/static%20analysis/badge.svg)](https://github.com/yiisoft/log-target-db/actions?query=workflow%3A%22static+analysis%22)[![type-coverage](https://camo.githubusercontent.com/f10f97b6030fd0d76e35c2b2ccda434c40b552c381d2cecf97351b60000e9277/68747470733a2f2f73686570686572642e6465762f6769746875622f796969736f66742f6c6f672d7461726765742d64622f636f7665726167652e737667)](https://shepherd.dev/github/yiisoft/log-target-db)

This package provides the Database target for the [yiisoft/log](https://github.com/yiisoft/log) library.

Supported databases
-------------------

[](#supported-databases)

PackagesPHPVersionsCI-Actions[\[db-mssql\]](https://github.com/yiisoft/db-mssql)**8.1 - 8.3****2017 - 2025**[![mssql](https://github.com/yiisoft/log-target-db/actions/workflows/mssql.yml/badge.svg)](https://github.com/yiisoft/log-target-db/actions/workflows/mssql.yml)[\[db-mysql\]](https://github.com/yiisoft/db-mysql) (MySQL)**8.1 - 8.3****5.7 - 9.5**[![mysql](https://github.com/yiisoft/log-target-db/actions/workflows/mysql.yml/badge.svg)](https://github.com/yiisoft/log-target-db/actions/workflows/mysql.yml)[\[db-mysql\]](https://github.com/yiisoft/db-mysql) (MariaDB)**8.1 - 8.3****10.4 - 12.10**[![mariadb](https://github.com/yiisoft/log-target-db/actions/workflows/mariadb.yml/badge.svg)](https://github.com/yiisoft/log-target-db/actions/workflows/mariadb.yml)[\[db-oracle\]](https://github.com/yiisoft/db-oracle)**8.1 - 8.3****11C - 21C**[![oracle](https://github.com/yiisoft/log-target-db/actions/workflows/oracle.yml/badge.svg)](https://github.com/yiisoft/log-target-db/actions/workflows/oracle.yml)[\[db-pgsql\]](https://github.com/yiisoft/db-pgsql)**8.1 - 8.3****9.0 - 18.0**[![pgsql](https://github.com/yiisoft/log-target-db/actions/workflows/pgsql.yml/badge.svg)](https://github.com/yiisoft/log-target-db/actions/workflows/pgsql.yml)[\[db-sqlite\]](https://github.com/yiisoft/db-sqlite)**8.1 - 8.3****3:latest**[![sqlite](https://github.com/yiisoft/log-target-db/actions/workflows/sqlite.yml/badge.svg)](https://github.com/yiisoft/log-target-db/actions/workflows/sqlite.yml)Requirements
------------

[](#requirements)

- PHP 8.1 or higher.
- `PDO` PHP extension.

Installation
------------

[](#installation)

The package could be installed with [Composer](https://getcomposer.org):

```
composer require yiisoft/log-target-db
```

Create database connection
--------------------------

[](#create-database-connection)

For more information see [yiisoft/db](https://github.com/yiisoft/db/tree/master/docs/guide/en#create-connection).

Database Preparing
------------------

[](#database-preparing)

Package provides two way for preparing database:

1. Raw SQL. You can use it with the migration package used in your application.

    - Ensure tables:

        - [MSSQL](sql/sqlsrv-up.sql),
        - [MySQL / MariaDB](sql/mysql-up.sql),
        - [Oracle](sql/oci-up.sql),
        - [PostgreSQL](sql/pgsql-up.sql)
        - [SQLite](sql/sqlite-up.sql)
    - Ensure no tables:

        - [MSSQL](sql/sqlsrv-down.sql),
        - [MySQL / MariaDB](sql/mysql-down.sql),
        - [Oracle](sql/oci-down.sql),
        - [PostgreSQL](sql/pgsql-down.sql)
        - [SQLite](sql/sqlite-down.sql)
2. `DbSchemaManager` for `ensureTable()`, `ensureNoTable()` methods for log table (by default `{{%yii_log}}`).

```
// Create db schema manager
$dbSchemaManager = new DbSchemaManager($db);

// Ensure table with default name
$dbSchemaManager->ensureTable();

// Ensure table with custom name
$dbSchemaManager->ensureTable('{{%custom_log_table}}');

// Ensure no table with default name
$dbSchemaManager->ensureNoTable();

// Ensure no table with custom name
$dbSchemaManager->ensureNoTable('{{%custom_log_table}}');
```

General usage
-------------

[](#general-usage)

When creating an instance of `\Yiisoft\Log\Logger`, you must pass an instance of the database connection.

Creating a target:

```
$dbTarget = new \Yiisoft\Log\Target\Db\DbTarget($db, $table, $levels);
```

- `$db (\Yiisoft\Db\Connection\ConnectionInterface)` - The database connection instance.
- `$table (string)` - The name of the database table to store the log messages. Defaults to "{{%yii\_log}}".
- `$levels (array)` - Optional. The log message levels that this target is interested in. Defaults to empty array (all levels). Example: `[\Psr\Log\LogLevel::ERROR, \Psr\Log\LogLevel::WARNING]`.

Creating a logger:

```
$logger = new \Yiisoft\Log\Logger([$dbTarget]);
```

You can filter which log levels are stored in the database by passing the `$levels` parameter to the constructor:

```
use Psr\Log\LogLevel;

// Only store ERROR and WARNING level messages
$dbTarget = new \Yiisoft\Log\Target\Db\DbTarget(
    $db,
    '{{%yii_log}}',
    [LogLevel::ERROR, LogLevel::WARNING]
);
```

Alternatively, you can set levels after instantiation using the `setLevels()` method:

```
$dbTarget = new \Yiisoft\Log\Target\Db\DbTarget($db);
$dbTarget->setLevels([LogLevel::ERROR, LogLevel::WARNING]);
```

You can use multiple databases to store log messages:

```
/**
 * @var \Yiisoft\Db\Connection\ConnectionInterface $mysqlDb
 * @var \Yiisoft\Db\Connection\ConnectionInterface $sqliteDb
 */

$logger = new \Yiisoft\Log\Logger([
    new \Yiisoft\Log\Target\Db\DbTarget($mysqlDb),
    new \Yiisoft\Log\Target\Db\DbTarget($sqliteDb),
]);
```

Documentation
-------------

[](#documentation)

For a description of using the logger, see the [yiisoft/log](https://github.com/yiisoft/log) package.

- [Yii guide to logging](https://github.com/yiisoft/docs/blob/master/guide/en/runtime/logging.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 Logging Library - DB Target 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

48

—

FairBetter than 95% of packages

Maintenance86

Actively maintained with recent releases

Popularity21

Limited adoption so far

Community27

Small or concentrated contributor base

Maturity55

Maturing project, gaining track record

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

Total

2

Last Release

95d ago

PHP version history (2 changes)1.0.0PHP ^8.0

1.1.0PHP ^8.1

### 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

[![samdark](https://avatars.githubusercontent.com/u/47294?v=4)](https://github.com/samdark "samdark (46 commits)")[![devanych](https://avatars.githubusercontent.com/u/20116244?v=4)](https://github.com/devanych "devanych (15 commits)")[![terabytesoftw](https://avatars.githubusercontent.com/u/42547589?v=4)](https://github.com/terabytesoftw "terabytesoftw (14 commits)")[![machour](https://avatars.githubusercontent.com/u/304450?v=4)](https://github.com/machour "machour (11 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (10 commits)")[![xepozz](https://avatars.githubusercontent.com/u/6815714?v=4)](https://github.com/xepozz "xepozz (9 commits)")[![vjik](https://avatars.githubusercontent.com/u/525501?v=4)](https://github.com/vjik "vjik (5 commits)")[![batyrmastyr](https://avatars.githubusercontent.com/u/9303221?v=4)](https://github.com/batyrmastyr "batyrmastyr (4 commits)")[![luizcmarin](https://avatars.githubusercontent.com/u/67489841?v=4)](https://github.com/luizcmarin "luizcmarin (3 commits)")[![Fantom409](https://avatars.githubusercontent.com/u/14968877?v=4)](https://github.com/Fantom409 "Fantom409 (2 commits)")[![schmasterz](https://avatars.githubusercontent.com/u/3609269?v=4)](https://github.com/schmasterz "schmasterz (1 commits)")[![viktorprogger](https://avatars.githubusercontent.com/u/7670669?v=4)](https://github.com/viktorprogger "viktorprogger (1 commits)")[![darkdef](https://avatars.githubusercontent.com/u/8342004?v=4)](https://github.com/darkdef "darkdef (1 commits)")[![mspirkov](https://avatars.githubusercontent.com/u/63721828?v=4)](https://github.com/mspirkov "mspirkov (1 commits)")[![Copilot](https://avatars.githubusercontent.com/in/1143301?v=4)](https://github.com/Copilot "Copilot (1 commits)")[![sankaest](https://avatars.githubusercontent.com/u/21160342?v=4)](https://github.com/sankaest "sankaest (1 commits)")

---

Tags

dbhacktoberfestpsr-3yii3logframeworkloggeryii

###  Code Quality

TestsPHPUnit

Static AnalysisPsalm, Rector

Type Coverage Yes

### Embed Badge

![Health badge](/badges/yiisoft-log-target-db/health.svg)

```
[![Health](https://phpackages.com/badges/yiisoft-log-target-db/health.svg)](https://phpackages.com/packages/yiisoft-log-target-db)
```

###  Alternatives

[yiisoft/log

Yii Logging Library

42905.9k19](/packages/yiisoft-log)[yiisoft/log-target-file

Yii Logging Library - File Target

22286.2k11](/packages/yiisoft-log-target-file)[lanin/laravel-api-debugger

Easily debug your JSON API.

2311.8M](/packages/lanin-laravel-api-debugger)[yiisoft/yii-middleware

Yii Middleware

21148.4k1](/packages/yiisoft-yii-middleware)[yiisoft/cache-db

Yii Caching Library - DB Handler

136.2k](/packages/yiisoft-cache-db)

PHPackages © 2026

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