All articles (english only)

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 report deletion errors Laravel provides…

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 in production, because it intercepts…

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, deleted, or modified while the…

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 degrades performance, especially on large tables. Here is an example query: The result (PostgreSQL): whereBetween()…