John Ruble on Atomic Spin

Development Practices

Give Me Every Nth Row: Reproducible Sampling in SQL Server and EF Core

For a recent project, I needed a small, representative sample of a large table. Here's the sampling approach I landed on.

With .NET 10, you now have no excuse not to start a collection of utility scripts that call into application code.

Developer Tools

This year's Advent of Code is going to be shorter, so I'm considering participating. Exploring what's out there, I found Gleam.

UX/Design Tools

Recently, I wanted to automate a tedious task in a UI application. I eventually settled on writing a small Swift app.

The Software Life

Neon DB solves problems with database branching. A fresh database instance is provisioned, based on the latest state of its parent database.

Development Practices

If your web app uses a Postgres database, you're already most of the way to live updates in the browser. Here's how to use LISTEN/NOTIFY.

Azure

Are you looking for a quick cron job on Azure? If your recurring task can be expressed as a one-liner, here's an easy way to run it in Azure.

Extracurricular Activities

After avoiding it for a decade or so, I’m finally dipping my toes into home automation. So, what's changed, and why now?

JavaScript

My software team recently applied the prune command and other techniques to great effect, reducing the Docker image size by half.

TypeScript

On a recent project, my team created a lightweight code generator, with reusable techniques I want to share. Read on for the why and the how.

TypeScript

I recently found myself wanting a two-dimensional switch statement in TypeScript. Here's one way to write one!