Posts tagged with 'database' - Freek Van der Herten's blog on Laravel, PHP and AI

Posts tagged with database

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 original

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.

Join 9,500+ smart developers

Get my monthly newsletter with what I learn from running Spatie, building Oh Dear, and maintaining 300+ open source packages. Practical takes on Laravel, PHP, and AI that you can actually use.

No spam. Unsubscribe anytime. You can also follow me on X.

Why and how you should remove inactive users and teams original

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.

Automating the Laravel 8 schema dump using GitHub Actions

Sep 16th 2020 – fidum.uk

Dan Manson explains how you can run that shiny new schema:dump command on GitHub actions. Pretty cool

Some SQL Tricks of an Application DBA

Aug 11th 2020 – hakibenita.com

Databases are the backbone of most modern systems, so taking some time to understand how they work is a good investment for any developer.

Relying on the database to validate your data

Jul 31st 2020 – matthiasnoback.nl

Matthias Noback shares his thoughts on when you should and when you shouldn't rely on the database to perform certain tasks

How to clean up huge tables in Laravel with ease original

Jul 27th 2020 by Freek Van der Herten – 3 minute read

Using our laravel-model-cleanup package, you can easily remove old unneeded records from your database. We recently released a new major version that adds support for safely cleaning out huge tables.

In this blog post, I'd like to introduce this new release of the package to you.

My twitter-friend Simon had a simple question that contained much complexity: how do databases work? The result was an absurdly long thread of 70+ tweets, in which I expounded on the workings and history of databases as used by modern web developers, and Simon chimed in on each tweet with further questions and requests for clarification. The result of this collaboration was a super fun tiny explanation of databases which many people said they liked, so here it is, lightly edited for clarity.

You can group by anything

Sep 30th 2019 – twitter.com

sql tips: you can group by anything pic.twitter.com/YoJVlUyghG
— ?Julia Evans? (@b0rk) 29 september 2019

Conditional logic with the CASE expression in SQL

Aug 21st 2019 – www.helenanderson.co.nz

CASE is SQLs answer to other programming languages IF-ELSE statement. If you need to test a condition and return a value CASE is the expression you need.

Ordering columns with null values

Jul 16th 2019 – twitter.com

And if you're a @laravelphp user wondering how you can use this feature, you can easily extend the query builder to support this. ?

Gist here: https://t.co/Wuavz0v7p9 pic.twitter.com/Vy6NJdJbcx
— Jonathan Reinink (@reinink) July 16, 2019

Calculating totals in Laravel using conditional aggregates

May 29th 2019 – reinink.ca

Jonathan Reinink wrote another awesome post on how to handle a complicated query.

I was asked recently how to calculate multiple totals (aggregates) in Laravel in the most efficient way. For example, maybe you have an email subscription service and want to display various totals based on your subscribers

Group by raw with boolean condition in Eloquent

Mar 6th 2019 – laraveldaily.com

Povilas Korop explains how to use a raw groupBy in Laravel. Cool!

How to handle relationships when softdeleting

Feb 28th 2019 – twitter.com

Here's a neat trick for soft deleting relationships in @laravelphp. ?

When you delete a record, immediately also soft delete any child records. ?

Later, when you restore the parent, automatically also restore all child records that were deleted when the parent was deleted. ? pic.twitter.com/YsYKWtu00R
— Jonathan Reinink (@reinink) February 27, 2019

Freek.dev