These posts contain subjects related to databases.
November 21, 2023
When you want to update a record and create it when it doesn't exist, you can use the
updateOrInsert method in Laravel.
The so-called "upsert" methods....
October 26, 2021
When you want to rollback a set of database operations if one of them fails, you can execute them within a database transaction. Laravel provides several techniques to do this. One of them, that I...Read
February 11, 2021
When working with Laravel, you will probably use the query builder in order to create and run database queries. Sometimes you want to see the raw SQL output of a query, for example when you are...Read
August 18, 2020
When you need to update a resource in Laravel, you might decide to use the
update or the
Let's take a look at the source code of the
July 8, 2020
Laravel 7 introduced Custom Eloquent Casts. Next to primitive types, such as json, it is also possible to cast values that form a compound to objects. This is an effective way to introduce value...Read
May 16, 2020
Since 7.x, Laravel provides a very compact syntax for creating foreign key constraints with the
In this post we will give a short demonstration of this syntax, and we...
April 24, 2020
Recently I stumbled upon a nested query in a Laravel project. It was written like this: You might have seen a comparable nested query in the code you had to work on, and you probably agree that...Read