Articles

2022

Year in review: 2022

Is COUNT(*) slow in MySQL?

Adding a Microservice to Your Monolith

Efficient Pagination Using Deferred Joins

Inertia Server-Side Rendering on Laravel Vapor

Using Ziggy with Inertia Server-Side Rendering

2021

Bitmasking in Laravel and MySQL

Using Laravel's Schema Builder Outside of Migrations

Efficient Distance Querying in MySQL

Hiring a Personal CFO

The Exceeding Cleverness of Laravel's Atomic Database Locks

Fixing Images on Laravel Vapor with League\Commonmark

Laravel + Vue: ReferenceError document is not defined at insertStyleElement

The Perfect Vercel + GitHub Actions Deployment Pipeline

Separate Marketing + App sites with Laravel Jetstream and Inertia.js

Blogging with Markdown in Laravel

Reliably Building Frontend Assets With NVM and Yarn (or NPM)

Fixing "Laravel PackageManifest.php: Undefined index: name" in GitHub Actions

Building a Shedquarters in My Backyard

Is Making Software Sisyphean?

2020

Handling Large CSVs with Laravel

Ensuring Consistent Polymorphic Relationships with Laravel

Realtime Spreadsheets with Laravel

Laravel Pseudo-Daemons

Much (Much) Older

Introducing Vue Model

Hosting An Advanced Yii2 App on Heroku

Encrypting and Encoding Information in URLs with PHP

My Aperture Backup Strategy

Remaking "Snake" In Excel

Using MySQL Triggers to Ensure Immutability

Yii and the Asset Pipeline: Part 2

Scheduling Jobs With Yii

Automating Yii Migrations on Heroku

Wrangling Timezones in PHP, MySQL, and Yii

Importing Transactions Into Mint

Yii, Heroku, and The Asset Pipeline

How I Use Evernote and IFTTT

Idea Extraction Gone Terribly Wrong

Carving the Statue of David