adiafora/laravel-postgres-naturalsort

This is a just simple example of how you can add natural sorting to your Eloquent models if you use Postgres.

1.2 2022-07-29 12:12 UTC

Requires

• php: ^7.4.0 | ^8.0.0
• laravel/framework: ^8.0 | ^9.0

MIT

• Sergey Zhidkov

• php
• postgresql
• laravel
• natural sort

README

This simple package will help you add natural sorting to your Eloquent models if you use PostgreSQL.

Installation

Run:

    composer require "adiafora/laravel-postgres-naturalsort"

Run migration on the package:

    php artisan migrate

Usage

You can add a NaturalSortTrait to any Eloquent model

Product extends Model
{
    use \Adiafora\NaturalSort\NaturalSortTrait;
}

And in your client code you can write:

Product::orderByNatural('text')->get();

or reverse sorting

Product::orderByNaturalDesc('text')->get();

License

The MIT License (MIT). Please see License File for more information.