PHPackages                             yiisoft/translator-message-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/translator-message-db

ActiveLibrary[Framework](/categories/framework)

yiisoft/translator-message-db
=============================

Yii Translator DB Message Storage

1.1.0(1mo ago)104.9k—0%7BSD-3-ClausePHPPHP 8.1 - 8.5CI passing

Since Sep 27Pushed 1mo ago12 watchersCompare

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

READMEChangelog (2)Dependencies (15)Versions (6)Used By (0)

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

Yii Translator DB Message Storage
=================================

[](#yii-translator-db-message-storage)

[![Latest Stable Version](https://camo.githubusercontent.com/bd6a7ca318be834de45a0e12b76126283f350ccb40401b2a7726efa77845335f/68747470733a2f2f706f7365722e707567782e6f72672f796969736f66742f7472616e736c61746f722d6d6573736167652d64622f762f737461626c652e706e67)](https://packagist.org/packages/yiisoft/translator-message-db)[![Total Downloads](https://camo.githubusercontent.com/4fed73c91750e1e0acbf75c232713c77f858505e6fb1ea3495e4ed2367291ba6/68747470733a2f2f706f7365722e707567782e6f72672f796969736f66742f7472616e736c61746f722d6d6573736167652d64622f646f776e6c6f6164732e706e67)](https://packagist.org/packages/yiisoft/translator-message-db)[![codecov](https://camo.githubusercontent.com/3417e07e289faa53ad967f7b07845e243f7f5d9479c83bd484a08cecba5acb07/68747470733a2f2f636f6465636f762e696f2f67682f796969736f66742f7472616e736c61746f722d6d6573736167652d64622f6272616e63682f6d61737465722f67726170682f62616467652e7376673f746f6b656e3d4838504647473553574f)](https://codecov.io/gh/yiisoft/translator-message-db)[![Mutation testing badge](https://camo.githubusercontent.com/32104ed74ec007a7a0128cfcb1c668bb57a056225ef13cbf0326ecaac5ac2b23/68747470733a2f2f696d672e736869656c64732e696f2f656e64706f696e743f7374796c653d666c61742675726c3d687474707325334125324625324662616467652d6170692e737472796b65722d6d757461746f722e696f2532466769746875622e636f6d253246796969736f66742532467472616e736c61746f722d6d6573736167652d64622532466d6173746572)](https://dashboard.stryker-mutator.io/reports/github.com/yiisoft/translator-message-db/master)[![static analysis](https://github.com/yiisoft/translator-message-db/workflows/static%20analysis/badge.svg)](https://github.com/yiisoft/translator-message-db/actions?query=workflow%3A%22static+analysis%22)[![type-coverage](https://camo.githubusercontent.com/42db48011e89ad982038f232262bab2cbd1882e987b7d7234563a632c394c8fd/68747470733a2f2f73686570686572642e6465762f6769746875622f796969736f66742f7472616e736c61746f722d6d6573736167652d64622f636f7665726167652e737667)](https://shepherd.dev/github/yiisoft/translator-message-db)

The package provides message storage backend based on DB to be used with [`yiisoft/translator`](https://github.com/yiisoft/translator) package.

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

[](#supported-databases)

PackagesCI-Actions[\[db-mssql\]](https://github.com/yiisoft/db-mssql)[![mssql](https://github.com/yiisoft/translator-message-db/actions/workflows/mssql.yml/badge.svg)](https://github.com/yiisoft/translator-message-db/actions/workflows/mssql.yml)[\[db-mysql/mariadb\]](https://github.com/yiisoft/db-mysql)[![mysql](https://github.com/yiisoft/translator-message-db/actions/workflows/mysql.yml/badge.svg)](https://github.com/yiisoft/translator-message-db/actions/workflows/mysql.yml)[\[db-oracle\]](https://github.com/yiisoft/db-oracle)[![oracle](https://github.com/yiisoft/translator-message-db/actions/workflows/oracle.yml/badge.svg)](https://github.com/yiisoft/translator-message-db/actions/workflows/oracle.yml)[\[db-pgsql\]](https://github.com/yiisoft/db-pgsql)[![pgsql](https://github.com/yiisoft/translator-message-db/actions/workflows/pgsql.yml/badge.svg)](https://github.com/yiisoft/translator-message-db/actions/workflows/pgsql.yml)[\[db-sqlite\]](https://github.com/yiisoft/db-sqlite)[![sqlite](https://github.com/yiisoft/translator-message-db/actions/workflows/sqlite.yml/badge.svg)](https://github.com/yiisoft/translator-message-db/actions/workflows/sqlite.yml)Requirements
------------

[](#requirements)

- PHP 8.1 - 8.5.
- `json` PHP extension.

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

[](#installation)

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

```
composer require yiisoft/translator-message-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 `ensureTables()`, `ensureNoTables()` methods for translator tables (by default `{{%yii_source_message}}` and `{{%yii_message}}`).

Configuration
-------------

[](#configuration)

### Quick start

[](#quick-start)

In case you use [`yiisoft/config`](https://github.com/yiisoft/config), you will get configuration automatically. If not, the following DI container configuration is necessary:

```
use Yiisoft\Translator\MessageReaderInterface;
use Yiisoft\Translator\Message\Db\MessageSource;

return [
    MessageReaderInterface::class => [
        'class' => MessageSource::class,
    ],
];
```

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

[](#general-usage)

### Create of instance of MessageSource

[](#create-of-instance-of-messagesource)

```
/** @var \Yiisoft\Db\Connection\ConnectionInterface $db */
$messageSource = new \Yiisoft\Translator\Message\Db\MessageSource($db);
```

### Create of instance of MessageSource with caching

[](#create-of-instance-of-messagesource-with-caching)

```
/** @var \Yiisoft\Db\Connection\ConnectionInterface $db */
/** @var \Yiisoft\Cache\CacheInterface $cache */
$cacheDuration = 7200; // The TTL of this value. If set to null, default value is used - 3600
$messageSource = new \Yiisoft\Translator\Message\Db\MessageSource($db, $cache, $cacheDuration);
```

### Read message without `yiisoft/translator` package

[](#read-message-without-yiisofttranslator-package)

```
/**
 * @var \Yiisoft\Translator\Message\Db\MessageSource $messageSource
 * @var ?string $translatedString
 */
$id = 'messageIdentificator';
$category = 'messageCategory';
$language = 'de-DE';

$translatedString = $messageSource->getMessage($id, $category, $language);
```

### Writing messages from array to storage

[](#writing-messages-from-array-to-storage)

```
/**
 * @var \Yiisoft\Translator\Message\Db\MessageSource $messageSource
 */
$category = 'messageCategory';
$language = 'de-DE';
$data = [
    'test.id1' => [
        'message' => 'Nachricht 1', // translated string
        'comment' => 'Comment for message 1', // is optional parameter for save extra metadata
    ],
    'test.id2' => [
        'message' => 'Nachricht 2',
    ],
    'test.id3' => [
        'message' => 'Nachricht 3',
    ],
];

$messageSource->write($category, $language, $data);
```

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

[](#documentation)

- [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 Translator DB Message Storage 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

56

—

FairBetter than 98% of packages

Maintenance89

Actively maintained with recent releases

Popularity31

Limited adoption so far

Community27

Small or concentrated contributor base

Maturity67

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

Total

2

Last Release

57d ago

PHP version history (2 changes)1.0.0PHP ^8.0

1.1.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

[![samdark](https://avatars.githubusercontent.com/u/47294?v=4)](https://github.com/samdark "samdark (25 commits)")[![terabytesoftw](https://avatars.githubusercontent.com/u/42547589?v=4)](https://github.com/terabytesoftw "terabytesoftw (14 commits)")[![vjik](https://avatars.githubusercontent.com/u/525501?v=4)](https://github.com/vjik "vjik (11 commits)")[![darkdef](https://avatars.githubusercontent.com/u/8342004?v=4)](https://github.com/darkdef "darkdef (9 commits)")[![devanych](https://avatars.githubusercontent.com/u/20116244?v=4)](https://github.com/devanych "devanych (7 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (5 commits)")[![xepozz](https://avatars.githubusercontent.com/u/6815714?v=4)](https://github.com/xepozz "xepozz (3 commits)")[![luizcmarin](https://avatars.githubusercontent.com/u/67489841?v=4)](https://github.com/luizcmarin "luizcmarin (2 commits)")[![Tigrov](https://avatars.githubusercontent.com/u/8563175?v=4)](https://github.com/Tigrov "Tigrov (2 commits)")[![batyrmastyr](https://avatars.githubusercontent.com/u/9303221?v=4)](https://github.com/batyrmastyr "batyrmastyr (2 commits)")[![thenotsoft](https://avatars.githubusercontent.com/u/44147615?v=4)](https://github.com/thenotsoft "thenotsoft (2 commits)")[![mspirkov](https://avatars.githubusercontent.com/u/63721828?v=4)](https://github.com/mspirkov "mspirkov (2 commits)")[![rustamwin](https://avatars.githubusercontent.com/u/16498265?v=4)](https://github.com/rustamwin "rustamwin (1 commits)")[![Fantom409](https://avatars.githubusercontent.com/u/14968877?v=4)](https://github.com/Fantom409 "Fantom409 (1 commits)")[![Arhell](https://avatars.githubusercontent.com/u/26163841?v=4)](https://github.com/Arhell "Arhell (1 commits)")[![sankaest](https://avatars.githubusercontent.com/u/21160342?v=4)](https://github.com/sankaest "sankaest (1 commits)")[![viktorprogger](https://avatars.githubusercontent.com/u/7670669?v=4)](https://github.com/viktorprogger "viktorprogger (1 commits)")

---

Tags

dbhacktoberfesti18ntranslatoryii3internationalizationi18nformattingmessage storage

###  Code Quality

TestsPHPUnit

Static AnalysisPsalm, Rector

Type Coverage Yes

### Embed Badge

![Health badge](/badges/yiisoft-translator-message-db/health.svg)

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

###  Alternatives

[yiisoft/translator-message-php

Yii Translator PHP Message Storage

14254.3k6](/packages/yiisoft-translator-message-php)[yiisoft/i18n-message-php

Yii Translator PHP Message Storage

143.4k](/packages/yiisoft-i18n-message-php)[laravel-lang/publisher

Localization publisher for your Laravel application

2167.3M16](/packages/laravel-lang-publisher)[laravel-lang/common

Easily connect the necessary language packs to the application

1452.9M16](/packages/laravel-lang-common)[cakephp/localized

CakePHP Localized Plugin

218585.3k4](/packages/cakephp-localized)[yiisoft/translator

Yii Message Translator

26455.1k14](/packages/yiisoft-translator)

PHPackages © 2026

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