RSSAmplifier

Blog

Jonathan Reinink

reinink.caRSS feed ↗10 posts

Latest posts

Ordering database queries by relationship columns in Laravel

In this article I explain how to order database queries in Laravel by the value (column) of an Eloquent relationship. We look at has-one, belongs-to, has-many and belongs-to-many relationships.

Dynamic relationships in Laravel using subqueries

In this article I explain how to use subqueries to create dynamic relationships in Laravel. This is a powerful technique that allows you to push more work into the database layer of your app. This can have a huge impact on performance by allowing you to drastically reduce the number of database queries executed and overall memory used.

Your database is a shared resource

As web developers, we have the tendency to think of every two requests as largely independent of one another. If one request is slow, it's unlikely to affect the other...right?

Optimizing circular relationships in Laravel

In this article I explain how to optimize circular relationships in Laravel using the Model::setRelation() method.

Optimize database queries in the perimeter of your Laravel apps

In this article I explain how optimizing database queries in the perimeter of your Laravel apps can help you avoid performance issues.

Viewing model counts in the Laravel Debugbar

In this article I explain how to view model counts in the Laravel Debugbar.

Calculating totals in Laravel using conditional aggregates

In this article I explore how to calculate multiple totals (aggregates) in Laravel using conditional aggregates.

Getting started with Inertia.js

In this article I use a screencast to explain how to get started with Inertia.js.

Introducing Inertia.js

In this article I introduce Inertia.js, a framework for creating server-driven single-page apps.

Server-side apps with client-side rendering

In this article I introduce a technique I've been using lately that blends my favourite parts of server-side and client-sidee apps: using client-side rendering in a server-side app.