Tag: laravel-and-php
All posts with tag "laravel-and-php".
-
Laravel Pulse: Production Monitoring Done Right
A practical guide to setting up Laravel Pulse for production monitoring -- from installation to custom recorders, Supervisor configuration, security gates, and performance tuning. Stop flying blind in production.
-
PgBouncer Connection Pooling: Transaction vs Session Mode Guide
Master PgBouncer connection pooling modes. Compare transaction vs session mode performance for Laravel and PostgreSQL. Avoid common database bottlenecks.
-
Laravel Queue Deadlock: Redis vs Database Driver (SQLSTATE 40001)
Resolve Laravel queue deadlocks (Serialization failure: 1213). Compare Redis vs Database drivers, locking mechanisms, and the SKIP LOCKED fix for PostgreSQL and MySQL.
-
Laravel Race Condition Fix: Cache::lock vs Database Locks
Master Laravel race condition fixes by comparing distributed Cache::lock with pessimistic database locking (lockForUpdate). Code examples and use cases.
-
The Ultimate Laravel + PostgreSQL Query Optimization Checklist (Part 7)
A practical end-to-end checklist to diagnose and optimize any Laravel query: classify short vs long, apply index and N+1 fixes, streamline long report queries, and escalate with CTEs, views, JSON functions, and partitioning.
-
Solving N+1 for Good in Laravel: The NORM JSON Function Pattern (Performance Part 6)
How to eliminate N+1 queries in complex Laravel endpoints by offloading relationship assembly to a PostgreSQL JSON-building function (NORM pattern) and returning one predictable JSON payload.
-
Architecting Complexity: CTEs, Views, and Partitioning in Laravel (Performance Part 5)
How and when to use PostgreSQL CTEs, database views, and table partitioning in a Laravel app to tame complex queries, encapsulate reusable logic, and keep massive tables fast.
-
Taming Long Queries & Joins: Winning Strategies for Reports (Laravel + PostgreSQL Performance Part 4)
How to optimize report-style 'long queries' in Laravel with PostgreSQL: when Seq Scans are good, how hash joins work, using EXISTS for semi/anti-joins, and structuring GROUP BY to avoid repeated large table scans.
-
Short Queries, Massive Tables: Indexes That Make Laravel Fly (Laravel + PostgreSQL Performance Part 3)
Why once-fast find() and where() calls slow down at scale, how PostgreSQL chooses Seq Scan vs Index Scan, and the exact indexing habits to keep short queries instant on millions of rows.
-
What Happens When You Run ->get()? Reading PostgreSQL Execution Plans (Laravel + PostgreSQL Performance Part 2)
A practical walkthrough for Laravel devs on what PostgreSQL does after Eloquent sends a query: parse, plan, execute. Learn how to extract SQL, run EXPLAIN, and decode Seq Scan cost, rows, and width so you can spot missing indexes early.