GhostvOne

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,…

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…

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…

whereDate() When you use whereDate() on a datetime field, the query casts the column to date before performing the comparison. This operation prevents the use of indexes defined on the created_at column, which results in a full table scan and…