http://reinink.ca/rss 2020-06-10T00:00:00+00:00 Jonathan Reinink http://reinink.ca/articles/ordering-database-queries-by-relationship-columns-in-laravel 2020-06-10T00:00:00+00:00

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.

Jonathan Reinink http://reinink.ca/articles/dynamic-relationships-in-laravel-using-subqueries 2020-04-14T00:00:00+00:00

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.

Jonathan Reinink http://reinink.ca/articles/your-database-is-a-shared-resource 2020-04-07T00:00:00+00:00

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?

Jonathan Reinink http://reinink.ca/articles/optimizing-circular-relationships-in-laravel 2020-02-19T00:00:00+00:00

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

Jonathan Reinink http://reinink.ca/articles/optimize-database-queries-in-the-perimeter-of-your-laravel-apps 2019-12-20T00:00:00+00:00

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

Jonathan Reinink http://reinink.ca/articles/viewing-model-counts-in-the-laravel-debugbar 2019-07-29T00:00:00+00:00

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

Jonathan Reinink http://reinink.ca/articles/calculating-totals-in-laravel-using-conditional-aggregates 2019-05-23T00:00:00+00:00

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

Jonathan Reinink http://reinink.ca/articles/getting-started-with-inertia-js 2019-04-04T00:00:00+00:00

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

Jonathan Reinink http://reinink.ca/articles/introducing-inertia-js 2019-03-19T00:00:00+00:00

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

Jonathan Reinink http://reinink.ca/articles/server-side-apps-with-client-side-rendering 2019-02-11T00:00:00+00:00

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.