When working with remote storage such as S3, Cloudflare R2 or another S3-compatible CDN, file management can quickly become problematic if it is not properly controlled. A common case appears when deleting files linked to a database. In this article, we will look at: The problem: Laravel does not always…

When an SQL transaction becomes complex, it can be difficult to understand exactly which queries are executed and in what order. Laravel allows you to listen to all SQL queries using the DB::listen() method. Example of listening to queries inside a transaction Result obtained: Warning: DB::listen() should not be used…

Laravel provides several methods to iterate over large amounts of data without exhausting memory, including chunk() and chunkById(). Although chunk() may seem convenient, it is strongly recommended to prefer chunkById() for all batch processing tasks. The chunk() method works using SQL offsets (LIMIT / OFFSET). However, if records are added,…