Code snippets
Code snippets
Copy-ready answers to everyday coding questions, each with a short explanation. Laravel, PHP, JavaScript, SQL, Bash and more.
4 snippets tagged #database · Show all
PHP
November 2, 2026
Laravel database transactions with DB::transaction
Runs several writes as one unit: if anything throws, all of them roll back. attempts retries on deadlocks.
<?php
use Illuminate\Support\Facades\DB;
PHP
November 2, 2026
Laravel soft deletes: delete, restore and query trashed records
Marks a row as deleted instead of removing it, so you can restore it later. withTrashed() and onlyTrashed() let you query deleted rows.
<?php
// migration
$table->softDeletes();
SQL
October 20, 2026
MySQL backup and restore a database with mysqldump
Dumps a database to a file and restores it later. --single-transaction gives a consistent backup of InnoDB tables without locking them.
# Backup
mysqldump -u root -p --single-transaction mydb > mydb.sql
# Backup compressed
PHP
October 3, 2026
Laravel Eager Loading with Eloquent: Avoid N+1 Queries
Laravel Eloquent eager loading lets you load model relationships in advance using the with() method, helping prevent the N+1 query problem and reducing unnecess...
use App\Models\Post;
// Eager load the author and comments relationships
$posts = Post::with(['author', 'comments'])->get();