Laravel developers ditch separate tables for JSON-based translations

Global Middleware and Localized Routing

To ensure a seamless user experience, the application uses a custom SetLocale middleware. This logic extracts the language code directly from the URL prefix—such as /es/ for Spanish—and sets the application state accordingly. By validating these prefixes against a regex pattern, the system maintains

integrity while ensuring that every route remains strictly localized. Additionally, the middleware persists the user's choice in a cookie, allowing for a consistent experience during return visits.

Dynamic UI via Filament Tabs

The

admin panel provides a highly visual way to manage these translations. Instead of a single massive form, the implementation uses dynamic tabs that loop through a locales configuration file. Each tab displays an emoji flag and a set of input fields.

foreach (config('locales') as $code => $locale) {
    $tabs[] = Tab::make($locale['name'])
        ->icon($locale['flag'])
        ->schema([
            TextInput::make("title.$code")
                ->required($code === 'en'),
            Textarea::make("description.$code"),
        ]);
}

This structure ensures that only the primary language (English) requires validation, while others remain optional.

Performance Tradeoffs with Astrotomic

While JSON fields offer flexibility, high-traffic applications with heavy SQL querying might struggle with performance. In these scenarios, the

package serves as a robust alternative. Unlike Spatie's JSON approach, Astrotomic utilizes separate relational tables to store translations. This allows for faster indexing and more efficient sorting at the database level, though it increases the complexity of the initial database migration and model setup.