We found 12 results for "SQL".
In Laravel projects, a lot of issues come from non-Laravel mistakes, database structure is one of those. In this tutorial, we will cover the most typical mistakes devs make when structuring DB in Laravel.
When working with shops and e-commerce projects, one common question is how to structure the DB of products with all attributes, variants, and options, like "iPhone - Black - 2 GB RAM - 1 TB Storage". In this tutorial, we will show our version of doing that.
If you want to replace DB auto-increment IDs with something more sophisticated, one of the solutions is UUID. In this article, I will show you how UUID columns work in Laravel, and what are the options and tools to use them.
This is a deep dive into belongsToMany Relationships in Laravel with examples - from simple, to much more complex.
Video version of a long 14-minute-read premium article from Laravel Daily.
If you are using SQLite and MySQL interchangably with Laravel, be cautious about some differences in the details.
A practical dive into SQL queries - we launch a few Eloquent "magic methods" and see what database queries are actually running under the hood.
If you need to perform a one-time operation of updating the data in DB, where do you do that?
A quick video showing how to protect from SQL injection in raw queries of Laravel Query Builder.
In Laravel and Eloquent, to avoid N+1 Query problems or to find slow SQL queries, you may use automatic tools. In this short tutorial, I will show you a few of them.
Database Transactions are essential if you want to perform a few DB insert/update/delete operations and ensure the integrity of the data. Let's take a look at 5 different examples from Laravel open-source projects.
There are situations when we're not sure what the columns of the DB table would be, they need to be flexible. For example, e-shop product properties: size, color, fabric, there may be more in the future. What is the best DB structure? I will show you 3 options and their performance.
