PHPackages juzaweb/laravel-translation-loader - 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. juzaweb/laravel-translation-loader ActiveLibrary[Database & ORM](/categories/database) juzaweb/laravel-translation-loader ================================== Store your language lines in the database, yaml or other sources 2.0.6(2mo ago)1594.6k↓49.5%4MITPHPPHP ^7.4|^8.0|^8.1CI failing Since Mar 20Pushed 2mo ago1 watchersCompare [ Source](https://github.com/juzaweb/laravel-translation)[ Packagist](https://packagist.org/packages/juzaweb/laravel-translation-loader)[ Docs](https://github.com/spatie/laravel-translation-loader)[ Fund](https://spatie.be/open-source/support-us)[ RSS](/packages/juzaweb-laravel-translation-loader/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (9)Dependencies (4)Versions (11)Used By (4) Store your language lines in the database ========================================= [](#store-your-language-lines-in-the-database) [![Latest Version on Packagist](https://camo.githubusercontent.com/0525c630a6d018d2725b8b3fd76962bb313d4c07927ab68e8dd923818815bfe4/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f7370617469652f6c61726176656c2d7472616e736c6174696f6e2d6c6f616465722e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/spatie/laravel-translation-loader)[![Software License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](LICENSE.md)[![GitHub Workflow Status](https://camo.githubusercontent.com/1d7c20ea4e4e91f656100057cd7c92e2c08f3014d9a92b383dc9d747b9b8aeb2/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f776f726b666c6f772f7374617475732f7370617469652f6c61726176656c2d7472616e736c6174696f6e2d6c6f616465722f72756e2d74657374733f6c6162656c3d7465737473)](https://camo.githubusercontent.com/1d7c20ea4e4e91f656100057cd7c92e2c08f3014d9a92b383dc9d747b9b8aeb2/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f776f726b666c6f772f7374617475732f7370617469652f6c61726176656c2d7472616e736c6174696f6e2d6c6f616465722f72756e2d74657374733f6c6162656c3d7465737473)[![Total Downloads](https://camo.githubusercontent.com/2e06b63965ff3a504cc23583d7ce7b23e75be2413bf9e20edfc531aa1b661671/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f7370617469652f6c61726176656c2d7472616e736c6174696f6e2d6c6f616465722e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/spatie/laravel-translation-loader) In a vanilla Laravel or Lumen installation you can use [language files](https://laravel.com/docs/5.6/localization) to localize your app. This package will enable the translations to be stored in the database. You can still use all the features of [the `trans` function](https://laravel.com/docs/5.6/localization#retrieving-translation-strings) you know and love. ``` trans('messages.welcome', ['name' => 'dayle']); ``` You can even mix using language files and the database. If a translation is present in both a file and the database, the database version will be returned. Want to use a different source for your translations? No problem! The package is [easily extendable](https://github.com/spatie/laravel-translation-loader#creating-your-own-translation-providers). Spatie is a webdesign agency based in Antwerp, Belgium. You'll find an overview of all our open source projects [on our website](https://spatie.be/opensource). Support us ---------- [](#support-us) [![](https://camo.githubusercontent.com/d4a710fef761fd7be0e0460a243b2c217e7e182457c50025937ad0b9186fc974/68747470733a2f2f6769746875622d6164732e73332e65752d63656e7472616c2d312e616d617a6f6e6177732e636f6d2f6c61726176656c2d7472616e736c6174696f6e2d6c6f616465722e6a70673f743d31)](https://spatie.be/github-ad-click/laravel-translation-loader) We invest a lot of resources into creating [best in class open source packages](https://spatie.be/open-source). You can support us by [buying one of our paid products](https://spatie.be/open-source/support-us). We highly appreciate you sending us a postcard from your hometown, mentioning which of our package(s) you are using. You'll find our address on [our contact page](https://spatie.be/about-us). We publish all received postcards on [our virtual postcard wall](https://spatie.be/open-source/postcards). Installation ------------ [](#installation) You can install the package via composer: ``` composer require spatie/laravel-translation-loader ``` In `config/app.php` (Laravel) or `bootstrap/app.php` (Lumen) you should replace Laravel's translation service provider ``` Illuminate\Translation\TranslationServiceProvider::class, ``` by the one included in this package: ``` Spatie\TranslationLoader\TranslationServiceProvider::class, ``` You must publish and run the migrations to create the `language_lines` table: ``` php artisan vendor:publish --provider="Spatie\TranslationLoader\TranslationServiceProvider" --tag="migrations" php artisan migrate ``` Optionally you could publish the config file using this command. ``` php artisan vendor:publish --provider="Spatie\TranslationLoader\TranslationServiceProvider" --tag="config" ``` This is the contents of the published config file: ``` return [ /* * Language lines will be fetched by these loaders. You can put any class here that implements * the Spatie\TranslationLoader\TranslationLoaders\TranslationLoader-interface. */ 'translation_loaders' => [ Spatie\TranslationLoader\TranslationLoaders\Db::class, ], /* * This is the model used by the Db Translation loader. You can put any model here * that extends Spatie\TranslationLoader\LanguageLine. */ 'model' => Spatie\TranslationLoader\LanguageLine::class, /* * This is the translation manager which overrides the default Laravel `translation.loader` */ 'translation_manager' => Spatie\TranslationLoader\TranslationLoaderManager::class, ]; ``` > **Note:** publishing assets doesn't work out of the box in Lumen. Instead you have to copy the files from the repo. Usage ----- [](#usage) You can create a translation in the database by creating and saving an instance of the `Spatie\TranslationLoader\LanguageLine`-model: ``` use Spatie\TranslationLoader\LanguageLine; LanguageLine::create([ 'group' => 'validation', 'key' => 'required', 'text' => ['en' => 'This is a required field', 'nl' => 'Dit is een verplicht veld'], ]); ``` You can fetch the translation with [Laravel's default `trans` function](https://laravel.com/docs/5.3/localization#retrieving-language-lines): ``` trans('validation.required'); // returns 'This is a required field' app()->setLocale('nl'); trans('validation.required'); // returns 'Dit is een verplicht veld' ``` You can still keep using the default language files as well. If a requested translation is present in both the database and the language files, the database version will be returned. If you need to store/override json translation lines, just create a normal LanguageLine with `group => '*'`. Creating your own translation providers --------------------------------------- [](#creating-your-own-translation-providers) This package ships with a translation provider than can fetch translations from the database. If you're storing your translations in a yaml-file, a csv-file, or ... you can easily extend this package by creating your own translation provider. A translation provider can be any class that implements the `Spatie\TranslationLoader\TranslationLoaders\TranslationLoader`-interface. It contains only one method: ``` namespace Spatie\TranslationLoader\TranslationLoaders; interface TranslationLoader { /* * Returns all translations for the given locale and group. */ public function loadTranslations(string $locale, string $group): array; } ``` Translation providers can be registered in the `translation_loaders` key of the config file. Changelog --------- [](#changelog) Please see [CHANGELOG](CHANGELOG.md) for more information what has changed recently. Testing ------- [](#testing) ``` composer test ``` Contributing ------------ [](#contributing) Please see [CONTRIBUTING](CONTRIBUTING.md) for details. Security -------- [](#security) If you discover any security related issues, please email instead of using the issue tracker. Credits ------- [](#credits) - [Freek Van der Herten](https://github.com/freekmurze) - [All Contributors](../../contributors) License ------- [](#license) The MIT License (MIT). Please see [License File](LICENSE.md) for more information. ### Health Score 53 — FairBetter than 97% of packages Maintenance86 Actively maintained with recent releases Popularity35 Limited adoption so far Community13 Small or concentrated contributor base Maturity64 Established project with proven stability 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 ~161 days Recently: every ~61 days Total 10 Last Release 67d ago Major Versions v1.x-dev → v2.02022-04-07 PHP version history (2 changes)v1.0PHP ^7.2|^8.1 v1.0.1PHP ^7.4|^8.0|^8.1 ### Community Maintainers ![](https://www.gravatar.com/avatar/3169e8a8781068840e9300a57785089da521287dbe0279fc9cc7e8de1c1d95a9?d=identicon)[juzaweb](/maintainers/juzaweb) --- Top Contributors [![juzaweb](https://avatars.githubusercontent.com/u/47020363?v=4)](https://github.com/juzaweb "juzaweb (11 commits)") --- Tags spatielaravellanguagetranslatedatabasei8ndblaravel-translation-loader ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/juzaweb-laravel-translation-loader/health.svg) ``` [![Health](https://phpackages.com/badges/juzaweb-laravel-translation-loader/health.svg)](https://phpackages.com/packages/juzaweb-laravel-translation-loader) ``` ### Alternatives [spatie/laravel-translation-loader Store your language lines in the database, yaml or other sources 8362.9M51](/packages/spatie-laravel-translation-loader)[tomatophp/filament-translations Manage your translation with DB and cache, you can scan your languages tags like trans(), \_\_(), and get the string inside and translate them use UI. 6230.1k3](/packages/tomatophp-filament-translations)[codezero/laravel-unique-translation Check if a translated value in a JSON column is unique in the database. 186965.1k7](/packages/codezero-laravel-unique-translation)[cybercog/laravel-clickhouse ClickHouse migrations for Laravel 163166.8k](/packages/cybercog-laravel-clickhouse)[arcanedev/laravel-settings This package allows you to persists configs/settings for Laravel projects. 74131.4k6](/packages/arcanedev-laravel-settings)[webparking/laravel-db-rebuild A laravel package that allows for quick database rebuilds with presets. 448.8k](/packages/webparking-laravel-db-rebuild) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)