Freek Van der Herten's blog on PHP, Laravel and JavaScript

Posts tagged with database

The value of a good database design

Mar 21st 2022 – tray2.se - submitted by Patrik Ahlström

You might think that the way your store your data isn't really that important. Well it's more important than you think it is. A good database design just like good clean code is the key to performance, not only for the end user but also for you the developer. A poor database model just like poorly written code will slow you down and furthermore it will slow your database queries down which results in a slow application.

Common SQL errors for Laravel Developers

Mar 11th 2022 – tray2.se - submitted by Patrik Ahlström

I hope you won't run into any of these.

Composable seeders in Laravel with callOnce

Feb 24th 2022 – sebastiandedeyne.com

Laravel 9 is fresh out the door, and it contains a small contribution of mine: a new callOnce method for database seeders.

Efficient Pagination Using Deferred Joins

Jan 27th 2022 – aaronfrancis.com - submitted by Aaron Francis

A slight modification to traditional offset/limit pagination that can drastically boost performance.

Bitmasking in Laravel and MySQL

Nov 22nd 2021 – aaronfrancis.com - submitted by Aaron Francis

An introduction to using bitmasks in general, and their usage in PHP, Laravel, and MySQL.

Increase Database Performance By Using Multiple Columns

Nov 12th 2021 – downing.tech

By thinking outside of the box, you can often get much faster database performance by splitting values across multiple database columns.

Efficient Distance Querying in MySQL

Nov 12th 2021 – aaronfrancis.com - submitted by Aaron Francis

A clever use of MySQL indexes and generated columns to make blazing fast geolocation searches.

Database and Eloquent ORM: New features and improvements since the original Laravel 8 release (1/2)

Nov 12th 2021 – protone.media - submitted by Pascal Baljet

In this series, I show you new features and improvements to the Laravel framework since the original release of version 8. This week is about the Database and Eloquent features in Laravel 8.

Ensuring data(base) consistency during concurrent requests

Nov 3rd 2021 – blog.frankdejonge.nl - submitted by Robin Dirksen

Bugs caused by race conditions can be a huge source or frustration. They are difficult to identify and often difficult to remedy.

How to update large data in Laravel

Oct 29th 2021 – 42coders.com

Here are a few best practices for working with a large tables.

Strategies for decreasing the number of queries in a Laravel app

Sep 13th 2021 by Freek Van der Herten – 13 minute read

Oh Dear is all-in-one solution to monitor your site that my buddy Mattias Geniar and I have created. It can monitoring uptime, certificates, broken links, scheduled jobs, and much more.

Under the hood, Oh Dear is a large Laravel application that performs many queries all of the time. To power future features, we've recently changed our database structure and refactored some pieces in our code base. We increased performance by decreasing the number of queries.

In this blog post, we'd like to to share some techniques that might be helpfull to increase the performance of your Laravel app too.

How Laravel handles DB connections

Jun 7th 2021

Mohammed Said created another kick ass video, this time on how Laravel handles DB connections.

How to optimize ORDER BY RANDOM()

Jun 4th 2021 – tpetry.me

Tobias explains how you can make this operation very fast even if your table has several million records.

Offset vs Cursor Pagination in Laravel

May 11th 2021 – www.laravel-enlightn.com - submitted by Paras Malhotra

An in-depth guide on offset and cursor pagination in Laravel, and the pros and cons of each.

Laravel Worldwide Meetup #8: Using Vite in Laravel & How to optimize your DB indexes

Apr 28th 2021 by Freek Van der Herten – 1 minute read

Here's the recording of Laravel Wordwide Meetup #8. My guests for this edition were Kai Sassnowski talking on the importance of DB indexes, and Sebastian De Deyne on how to use Vite in Laravel.

Why and how you should remove inactive users and teams

Mar 29th 2021 by Freek Van der Herten – 8 minute read

There are many SaaS applications that allow potential new customers to try out the service using a trial period. Of course, not everybody will convert. After the trial period is over, some people will not use the service anymore. However, if nothing is being done about it, their email address and…

Laravel Media Library: Load Only 1st Picture Efficiently

Nov 16th 2020 – naxon.dev - submitted by Daniel Naxon

I needed to display only the first picture from my Product's model media collection and found my app running five queries and hydrating 16 models with only four products to display 😱 . Here's how I ended with only two queries and eight models.

Using Laravel's new Query Builder Upsert feature

Oct 20th 2020 – atymic.dev - submitted by atymic

Overview of the new upsert feature in Laravel 8.10, how to use it and some tips.

Gracefully deprecating foreign keys for a polymorphic relationship

Oct 12th 2020 – timacdonald.me - submitted by Tim Mac

Here's how to handle moving from a classic foreign key constrained relationship, to a polymorphic relationship in Eloquent, without impacting the end user.

How to delete 900 million records in MySQL without shooting yourself in the foot

Sep 22nd 2020 – flareapp.io

When reviewing the contents of the database of Flare, we encountered a table with 1 billion records. Technically that isn't a problem. Flare runs on Vapor and uses an Aurora database, so it can handle that scale. But of course, there's a cost for storing that many records.

We dove in and concluded that we could safely delete about 900 million records. They all were created before a specific date.