tenantcloud/laravel-boolean-softdeletes

Laravel soft deletes optimization for high load queries

3.1 2021-07-13 08:07 UTC

This package is auto-updated.

Last update: 2022-06-13 10:02:37 UTC


README

Latest Version on Packagist Software License Build Status Coverage Status Quality Score Total Downloads

This package is mostly for high load apps. It will speed up queries with soft deletes. Boolean field is much better for indexing instead of unique timestamps.

Install

Via Composer

$ composer require tenantcloud/laravel-boolean-softdeletes

Add Webkid\LaravelBooleanSoftdeletes\SoftDeletesBoolean trait to models with soft deletes.

Then create and run migration to add soft delete boolean field

Schema::table('users', function (Blueprint $table) {
    $table->boolean('is_deleted')->default(0)->index();
});

If you want to use this package for existing project you can use built-in command

php artisan softdeletes:migrate

Also you can change default column name is_deleted to any other by setting static property IS_DELETEDof certain model

Versions compatibility

For Laravel 5 - laravel-boolean-softdeletes 0.1.2
For Laravel 6 - laravel-boolean-softdeletes 1.0.0
For Laravel 7 - laravel-boolean-softdeletes 2.0.0
For Laravel 8 - laravel-boolean-softdeletes 3.*

Change log

Please see CHANGELOG for more information on what has changed recently.

Testing

$ composer test

Contributing

Please see CONTRIBUTING and CODE_OF_CONDUCT for details.

Security

If you discover any security related issues, please email kolodiy.ivan.i@gmail.com instead of using the issue tracker.

Credits

License

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