Make localized URLs shareable between users with different locales

[marvin-wtt]

Why?

With the current implementation of implicit route model binding, it is only possible to query for slugs within the same locale. This becomes a problem when a link with a localized slug is shared to a person with a different locale configured. Even though the model exists, the user will get a 404.

Before creating a PR to address this issue, I'd like to hear a few opinions from you and @freekmurze on my thoughts so far.
I basically have two approaches, which are explained here.
I'd of course make this optional to avoid a BC.

Option 1

Search for the slug with REGEXP
This is by far the easiest approach, but noticeably worse performance wise for larger datasets.

Option 2

Create a separate table for the translated slugs which morphs to the model instead of storing them as JSON. This would be much better than executing a regex search on every page request. The slugs would then need to be unique for [sluggable_type, name].
The user experience would be similar IMO. It would only be required to publish the migration if the feature is wanted.

The only downside I could imagine is that it is slightly more complicated for the user to manually override a slug, as some admin panels already provide great support for laravel-translateable fields.

slugs
    id - integer
    sluggable_type - string
    sluggable_id - integer
    locale - string
    name - string

[nnnnnnnngu]

Is there any update regarding this?

[nnnnnnnngu]

My solution so far

public function show($slug)
    {
        $blogPost = BlogPost::findBySlug($slug);

        if (! $blogPost) {
            foreach (config('app.locales') as $locale) {
                $blogPost = BlogPost::where('slug->'.$locale, $slug)->first();
                if ($blogPost) {
                    break;
                }
            }
        }

        abort_unless($blogPost,404);

        return view('blog.show', [
            'blogPost' => $blogPost,
        ]);
    }

[nnnnnnnngu]

Improved version, it will redirect to localized slug instead of showing original slug but correct content

    public function show($slug)
    {
        $article = Article::findBySlug($slug);

        if (! $article) {
            foreach (config('app.locales') as $locale) {
                $article = Article::where('slug->'.$locale, $slug)->first();
                if ($article) {
                    return redirect()->to(route('articles.show', ['article' => $article]));
                }
            }
        }

        abort_unless($article,404);

        return view('articles.show', compact('article'));
    }

[marvin-wtt]

I created a PR but it was not merged.

See:
#233

[nnnnnnnngu]

It is a must have feature with translatable slugs :/

[marvin-wtt]

You can tag Freek in the PR or here in the discussion. Maybe he changed his opinion on that subject