tenantcloud/laravel-boolean-softdeletes

Laravel soft deletes optimization for high load queries

v5.2.0 2024-04-25 12:29 UTC

This package is auto-updated.

Last update: 2024-09-14 20:27:37 UTC


README

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

This package is designed for high-load applications and optimizes queries with soft deletes by utilizing a boolean field for indexing, which is more efficient than using 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.*
For Laravel 9 - laravel-boolean-softdeletes 4.*
For Laravel 10 - laravel-boolean-softdeletes 5.*

Change log

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

Contributing

Please see CONTRIBUTING 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.