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(3mo ago)104.9k—0%71BSD-3-ClausePHPPHP 8.1 - 8.5CI passing Since Sep 27Pushed 3mo 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 1mo ago READMEChangelog (2)Dependencies (15)Versions (6)Used By (1) [ ![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 54 — FairBetter than 97% of packages Maintenance80 Actively maintained with recent releases Popularity31 Limited adoption so far Community29 Small or concentrated contributor base Maturity68 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 106d 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 14262.5k7](/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.7M24](/packages/laravel-lang-publisher)[laravel-lang/common Easily connect the necessary language packs to the application 1463.1M22](/packages/laravel-lang-common)[cakephp/localized CakePHP Localized Plugin 218595.6k5](/packages/cakephp-localized)[yiisoft/translator Yii Message Translator 26472.6k16](/packages/yiisoft-translator) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)