{"id":300,"date":"2025-08-27T19:28:25","date_gmt":"2025-08-27T19:28:25","guid":{"rendered":"https:\/\/1v0.net\/blog\/?p=300"},"modified":"2025-08-27T19:28:29","modified_gmt":"2025-08-27T19:28:29","slug":"soft-deletes-in-laravel-restore-force-delete-and-prune-data","status":"publish","type":"post","link":"https:\/\/1v0.net\/blog\/soft-deletes-in-laravel-restore-force-delete-and-prune-data\/","title":{"rendered":"Soft Deletes in Laravel: Restore, Force Delete, and Prune Data"},"content":{"rendered":"\n

Soft Deletes in Laravel: Restore, Force Delete, and Prune Data<\/strong><\/h2>\n\n\n\n

Soft deletes let you \u201cdelete\u201d rows without losing them immediately. Instead of removing data, Eloquent sets a deleted_at<\/code> timestamp and excludes those rows from normal queries. You can later restore<\/em> or permanently remove<\/em> them, and even prune<\/em> old soft-deleted data on a schedule. In this guide, you\u2019ll enable soft deletes, build a Recycle Bin UI, and automate cleanup safely.<\/p>\n\n\n\n

<\/div>\n\n\n\n\n

1 – Add deleted_at<\/code> to Your Table<\/strong><\/h2>\n\n\n\n

Add a soft delete column using the schema builder. Use softDeletes()<\/code> (or softDeletesTz()<\/code> if you prefer timezone-aware timestamps).<\/p>\n\n\n

\/\/ database\/migrations\/2025_08_27_000000_add_soft_deletes_to_posts_table.php<\/span>\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Migrations<\/span>\\Migration<\/span>;\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Schema<\/span>\\Blueprint<\/span>;\nuse<\/span> Illuminate<\/span>\\Support<\/span>\\Facades<\/span>\\Schema<\/span>;\n\nreturn<\/span> new<\/span> class<\/span> extends<\/span> Migration<\/span> <\/span>{\n    public<\/span> function<\/span> up<\/span>()<\/span>: void<\/span>\n    <\/span>{\n        Schema::table('posts'<\/span>, function<\/span> (Blueprint $table)<\/span> <\/span>{\n            $table->softDeletes(); \/\/ adds nullable deleted_at TIMESTAMP<\/span>\n        });\n    }\n\n    public<\/span> function<\/span> down<\/span>()<\/span>: void<\/span>\n    <\/span>{\n        Schema::table('posts'<\/span>, function<\/span> (Blueprint $table)<\/span> <\/span>{\n            $table->dropSoftDeletes(); \/\/ drops deleted_at<\/span>\n        });\n    }\n};<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This migration adds a deleted_at<\/code> column that Eloquent uses to hide \u201ctrashed\u201d rows. The down()<\/code> method makes the change reversible.<\/p>\n\n\n\n
Run the migration:<\/p>\n\n\n
php artisan migrate<\/code><\/span>Code language:<\/span> Bash<\/span> (<\/span>bash<\/span>)<\/span><\/small><\/pre>\n\n\n
After running, the table is ready to support soft deletes without breaking existing queries.<\/p>\n\n\n\n\n
<\/div>\n\n\n\n\n
2 – Enable Soft Deletes on the Model<\/strong><\/h2>\n\n\n\n
Add the SoftDeletes<\/code> trait to your Eloquent model. This automatically excludes trashed rows from default queries such as Model::all()<\/code>.<\/p>\n\n\n
\/\/ app\/Models\/Post.php<\/span>\nnamespace<\/span> App<\/span>\\Models<\/span>;\n\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Eloquent<\/span>\\Model<\/span>;\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Eloquent<\/span>\\SoftDeletes<\/span>;\n\nclass<\/span> Post<\/span> extends<\/span> Model<\/span>\n<\/span>{\n    use<\/span> SoftDeletes<\/span>;\n\n    protected<\/span> $fillable = ['user_id'<\/span>,'title'<\/span>,'body'<\/span>,'status'<\/span>];\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
With the trait, calling Post::query()<\/code> ignores rows where deleted_at<\/code> is not null. You\u2019ll use special helpers to include or filter trashed rows when needed.<\/p>\n\n\n\n\n
<\/div>\n\n\n\n\n
3 – Soft Delete, Restore, and Force Delete<\/strong><\/h2>\n\n\n\n
Soft delete marks the row; restore brings it back; force delete removes it permanently from the database.<\/p>\n\n\n
\/\/ Soft delete a post<\/span>\n$post = Post::findOrFail($id);\n$post->delete(); \/\/ sets deleted_at<\/span>\n\n\/\/ Restore a soft-deleted post<\/span>\n$post = Post::withTrashed()->findOrFail($id);\n$post->restore(); \/\/ clears deleted_at<\/span>\n\n\/\/ Permanently delete<\/span>\n$post = Post::withTrashed()->findOrFail($id);\n$post->forceDelete(); \/\/ removes row from DB<\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Use withTrashed()<\/code> to access items regardless of deletion state, then call restore()<\/code> or forceDelete()<\/code> as appropriate.<\/p>\n\n\n\n\n
<\/div>\n\n\n\n\n
4 – Query Helpers for Trashed Rows<\/strong><\/h2>\n\n\n\n
These helpers give you fine control over which rows are returned in queries.<\/p>\n\n\n
\/\/ Include trashed + non-trashed<\/span>\n$all = Post::withTrashed()->latest()->paginate(10<\/span>);\n\n\/\/ Only trashed<\/span>\n$trashed = Post::onlyTrashed()->orderBy('deleted_at'<\/span>,'desc'<\/span>)->get();\n\n\/\/ Explicitly exclude trashed (same as default)<\/span>\n$active = Post::withoutTrashed()->get();<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
withTrashed()<\/code> is useful for admin reports; onlyTrashed()<\/code> powers a Recycle Bin; withoutTrashed()<\/code> matches the default behavior when the trait is enabled.<\/p>\n\n\n\n\n
<\/div>\n\n\n\n\n
5 – Routes & Controller for a Recycle Bin UI<\/strong><\/h2>\n\n\n\n
Expose routes to view trashed items, restore them, or permanently delete them. Authorize these actions to admin roles only.<\/p>\n\n\n
\/\/ routes\/web.php (snippet)<\/span>\nuse<\/span> App<\/span>\\Http<\/span>\\Controllers<\/span>\\PostTrashController<\/span>;\n\nRoute::middleware(['auth'<\/span>])->group(function<\/span> ()<\/span> <\/span>{\n    Route::get('\/posts\/trash'<\/span>, [PostTrashController::class, 'index'<\/span>])->name('posts.trash.index'<\/span>);\n    Route::patch('\/posts\/{id}\/restore'<\/span>, [PostTrashController::class, 'restore'<\/span>])->name('posts.trash.restore'<\/span>);\n    Route::delete('\/posts\/{id}\/force'<\/span>, [PostTrashController::class, 'force'<\/span>])->name('posts.trash.force'<\/span>);\n});<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
These routes provide a list view plus endpoints to restore or force delete a specific post. Use policies\/middleware to ensure only privileged users can perform destructive actions.<\/p>\n\n\n
\/\/ app\/Http\/Controllers\/PostTrashController.php<\/span>\nnamespace<\/span> App<\/span>\\Http<\/span>\\Controllers<\/span>;\n\nuse<\/span> App<\/span>\\Models<\/span>\\Post<\/span>;\nuse<\/span> Illuminate<\/span>\\Http<\/span>\\Request<\/span>;\n\nclass<\/span> PostTrashController<\/span> extends<\/span> Controller<\/span>\n<\/span>{\n    public<\/span> function<\/span> index<\/span>()<\/span>\n    <\/span>{\n        $posts = Post::onlyTrashed()\n            ->orderBy('deleted_at'<\/span>,'desc'<\/span>)\n            ->paginate(10<\/span>);\n\n        return<\/span> view('posts.trash'<\/span>, compact('posts'<\/span>));\n    }\n\n    public<\/span> function<\/span> restore<\/span>($id)<\/span>\n    <\/span>{\n        $post = Post::withTrashed()->findOrFail($id);\n        \/\/ $this->authorize('restore', $post); \/\/ optional policy<\/span>\n        $post->restore();\n\n        return<\/span> back()->with('status'<\/span>,'Post restored.'<\/span>);\n    }\n\n    public<\/span> function<\/span> force<\/span>($id)<\/span>\n    <\/span>{\n        $post = Post::withTrashed()->findOrFail($id);\n        \/\/ $this->authorize('forceDelete', $post); \/\/ optional policy<\/span>\n        $post->forceDelete();\n\n        return<\/span> back()->with('status'<\/span>,'Post permanently deleted.'<\/span>);\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The controller paginates trashed posts and provides RESTful handlers to restore or permanently delete items. Optionally enforce policies for extra safety.<\/p>\n\n\n\n\n
<\/div>\n\n\n\n\n
6 – UI: Recycle Bin Blade View<\/strong><\/h2>\n\n\n\n
Here\u2019s a simple Recycle Bin with Restore and Delete buttons. Use CSRF and method spoofing to protect the actions.<\/p>\n\n\n
<!-- resources\/views\/posts\/trash.blade.php -->\n@extends('layouts.app'<\/span>)\n\n@section('content'<\/span>)\n<div class<\/span>=\"container<\/span>\">\n  <h1<\/span> class<\/span>=\"mb<\/span>-4\">Recycle<\/span> Bin<\/span><\/h1<\/span>>\n\n  @if<\/span>(session<\/span>('status<\/span>'))\n    <div<\/span> class<\/span>=\"alert<\/span> alert<\/span>-success<\/span>\"><\/span>{{ session('status'<\/span>) }}<\/div>\n  @endif<\/span>\n\n  @forelse($posts as<\/span> $post)\n    <div class<\/span>=\"card<\/span> mb<\/span>-3\">\n      <div<\/span> class<\/span>=\"card<\/span>-body<\/span> d<\/span>-flex<\/span> justify<\/span>-content<\/span>-between<\/span> align<\/span>-items<\/span>-center<\/span>\">\n        <div<\/span>>\n          <h5<\/span> class<\/span>=\"card<\/span>-title<\/span> mb<\/span>-1\"><\/span>{{ $post->title }}<\/h5>\n          <small class<\/span>=\"text<\/span>-muted<\/span>\">Deleted<\/span> at<\/span>: <\/span>{{ $post->deleted_at }}<\/small>\n        <\/div>\n\n        <div class<\/span>=\"d<\/span>-flex<\/span> gap<\/span>-2\">\n          <form<\/span> method<\/span>=\"POST<\/span>\" action<\/span>=\"<\/span>{{ route('posts.trash.restore'<\/span>, $post->id) }}\">\n            @csrf @method('PATCH')\n            <button class=\"<\/span>btn btn-outline-secondary\">Restore<\/button>\n          <\/form>\n\n          <form method=\"<\/span>POST\" action=\"<\/span>{{ route('posts.trash.force'<\/span>, $post->id) }}\"\n                onsubmit=\"<\/span>return<\/span> confirm('Permanently delete this post?'<\/span>);\">\n            @csrf @method('DELETE')\n            <button class=\"<\/span>btn btn-danger\">Delete Forever<\/button>\n          <\/form>\n        <\/div>\n      <\/div>\n    <\/div>\n  @empty\n    <p class=\"<\/span>text-muted\">No trashed posts.<\/p>\n  @endforelse\n\n  {{ $posts->links() }}\n<\/div>\n@endsection<\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This UI lists trashed posts with the deletion timestamp and action buttons. Restore unsets deleted_at<\/code>, while \u201cDelete Forever\u201d removes the row from the database.<\/p>\n\n\n\n\n
<\/div>\n\n\n\n\n
7 – Scheduled Pruning of Old Soft-Deleted Rows<\/strong><\/h2>\n\n\n\n
Use model pruning to automatically purge items that have been soft-deleted for a while (e.g., 30 days).<\/p>\n\n\n
\/\/ app\/Models\/Post.php (add trait & prunable() if you like)<\/span>\nnamespace<\/span> App<\/span>\\Models<\/span>;\n\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Eloquent<\/span>\\Model<\/span>;\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Eloquent<\/span>\\SoftDeletes<\/span>;\nuse<\/span> Illuminate<\/span>\\Database<\/span>\\Eloquent<\/span>\\Prunable<\/span>;\n\nclass<\/span> Post<\/span> extends<\/span> Model<\/span>\n<\/span>{\n    use<\/span> SoftDeletes<\/span>, Prunable<\/span>;\n\n    public<\/span> function<\/span> prunable<\/span>()<\/span>\n    <\/span>{\n        \/\/ prune items soft-deleted more than 30 days ago<\/span>\n        return<\/span> static<\/span>::onlyTrashed()\n            ->where('deleted_at'<\/span>, '<'<\/span>, now()->subDays(30<\/span>));\n    }\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The Prunable<\/code> trait defines a query selecting candidates for permanent removal. Here we keep trashed posts for 30 days before pruning them.<\/p>\n\n\n
\/\/ app\/Console\/Kernel.php (schedule pruning)<\/span>\nprotected<\/span> function<\/span> schedule<\/span>(\\Illuminate\\Console\\Scheduling\\Schedule $schedule)<\/span>: void<\/span>\n<\/span>{\n    \/\/ Run daily at 02:00; add --pretend in staging to preview deletions<\/span>\n    $schedule->command('model:prune'<\/span>, [\n        '--model'<\/span> => [\\App\\Models\\Post::class],\n    ])->dailyAt('02:00'<\/span>);\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
This schedules the built-in model:prune<\/code> command to run daily. In non-production environments, consider --pretend<\/code> to preview what would be deleted.<\/p>\n\n\n\n
Remember to set up your cron to run the Laravel scheduler: * * * * * php \/path\/to\/artisan schedule:run >> \/dev\/null 2>&1<\/code>.<\/p>\n\n\n\n\n
<\/div>\n\n\n\n\n
Wrapping Up<\/h2>\n\n\n\n
Soft deletes provide a safe middle ground between \u201cactive\u201d and \u201cgone.\u201d You added a deleted_at<\/code> column, enabled the SoftDeletes<\/code> trait, implemented restore and force delete flows, built a Recycle Bin UI, and configured pruning to keep the database lean. This pattern reduces accidental loss and gives you clean, auditable lifecycle management for records.<\/p>\n\n\n\n\n
<\/div>\n\n\n\n\n
What\u2019s Next<\/h2>\n\n\n\n