Laravel Expert

Laravel Expert Skill

This skill provides deep Laravel expertise including Eloquent optimization, architectural patterns, security best practices, and testing strategies.

---

🔥 Common Pitfalls

N+1 Query Problem

// ❌ N+1 — 1 + N queries
foreach (Site::all() as $site) {
    echo $site->owner->name;
}

// ✅ Eager loading — 2 queries
foreach (Site::with('owner')->get() as $site) {
    echo $site->owner->name;
}

// ✅ Nested
Site::with(['owner', 'checks.results'])->get();

// ✅ Conditional
Site::with(['checks' => fn($q) => $q->failed()])->get();

Mass Assignment

// ❌ CRITICAL
protected $guarded = [];

// ❌ Sensitive fields in fillable
protected $fillable = ['name', 'email', 'is_admin'];

// ✅ Safe
protected $fillable = ['name', 'email', 'bio'];
// Use forceFill() for admin fields with explicit check

Query Builder vs Eloquent

// When to use Query Builder:
// - Bulk operations
// - Complex aggregations
// - Performance critical paths

DB::table('sites')
    ->where('status', 'active')
    ->update(['checked_at' => now()]);

// When to use Eloquent:
// - CRUD with relationships
// - Model events needed
// - Accessors/mutators
$site = Site::find($id);
$site->update(['status' => 'active']);

---

🏗️ Architecture Patterns

Action Classes

// app/Actions/Sites/CreateSite.php
namespace App\Actions\Sites;

use App\Models\Site;
use App\Models\User;

class CreateSite
{
    public function __construct(
        private AnalyzerService $analyzer
    ) {}

    public function execute(array $data, User $user): Site
    {
        $site = Site::create([
            ...$data,
            'owner_id' => $user->id,
            'status' => 'pending',
        ]);

        $this->analyzer->queueCheck($site);

        return $site;
    }
}

Service Classes

// Stateless, injected via DI
class AnalyzerService
{
    public function __construct(
        private HttpClient $http,
        private CacheManager $cache
    ) {}

    public function analyze(Site $site): AnalysisResult
    {
        $cacheKey = "analysis.{$site->id}";
        
        return $this->cache->remember(
            $cacheKey,
            now()->addHour(),
            fn() => $this->performAnalysis($site)
        );
    }

    private function performAnalysis(Site $site): AnalysisResult
    {
        $response = $this->http->get($site->url);
        return new AnalysisResult($response);
    }
}