gaspertrix/laravel-boolean-softdeletes

Laravel soft deletes optimization for high load queries

1.0.0 2020-05-20 04:12 UTC

Requires

• php: ~7.2
• illuminate/support: ~6.0

Requires (Dev)

• phpunit/phpunit: >=5.4.3
• squizlabs/php_codesniffer: ^2.3

MIT

• Ivan Kolodiy

• LaravelBooleanSoftdeletes
• TenantCloud

README

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

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 [e-mail] instead of using the issue tracker.

Credits

• Ivan Kolodiy
• All Contributors

License

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