Andrew Lisowski 💻

Senior Software Engineeer snowflake.com Co-Founder @graze.social Co-Host of @devtools.fm Creator of @kich.io hipstersmoothie.com

14257 followers4170 following24 stories

Longform Stories

Using Bluesky Labelers To Show Campaign Funding Data

What Bluesky labelers are and how I built one that uses OpenSecrets data to surface the donors funding US politicians, NASCAR-jumpsuit style.

Nov 23·1 min read·52 words

Vscode Turborepo Jest Debugging

How to debug the current Jest test file in a Turborepo monorepo from VS Code by running tests from the closest package instead of the repo root.

Apr 26·1 min read·58 words

Including static files in App Router RSCs

Why bundling static files into a Next.js App Router build is harder than it looks, and how webpack's require.context and custom loaders solve it.

Jan 27·1 min read·55 words

Conditionally rendering RSCs

How React Server Components can be conditionally rendered by passing them as children to client components, with an MDX post-preview example.

Jan 8·1 min read·45 words

Importing Local Database Into Planetscale

Step-by-step instructions for importing a local MySQL database into PlanetScale using ngrok to expose your server and enabling GTID mode.

May 22·1 min read·45 words

Creating "Window Open" Notifications when AC is Running

Building a HomeKit automation that pings Discord when a window is open while the AC or heat is running, using notification switches and IFTTT.

Jun 27·1 min read·56 words

Turning Off Lights When There Is No Motion

Working around HomeKit's automation timeouts with a Homebridge delay switch so lights only turn off after 30 minutes of no motion.

Jun 27·1 min read·50 words

Home Automation Workflows

A hub of guides for building complex HomeKit automations the Home app can't handle alone, from locks to motion lights to notifications.

Jun 27·1 min read·47 words

Home Automation User Experience (HAUX)

My guiding rule for home automation: automations should always work for you, never against you, or you'll just end up turning them off.

Jun 27·1 min read·51 words

Getting Files Out Of A Docker Container

A quick guide to rescuing config files trapped inside a Docker container by mounting a new volume and copying them back out to the host.

Jun 27·1 min read·57 words

Home Automation

An overview of my HomeKit smart home: the hardware I use and how Apple's Home app plus Homebridge tie it all together with good HAUX.

Jun 27·1 min read·52 words

Fixing Buggy Hdmi Cec

When a new receiver's HDMI CEC fell short, I rebuilt one-remote control with HomeKit, Homebridge, and a Harmony Hub to sync my TV and receiver.

Jun 27·1 min read·54 words

Automate Your Locks Without User Interaction

Fully automate a HomeKit smart lock with no confirmation tap, using Homebridge Dummy switches to sync the lock to arrival and departure.

Jun 27·1 min read·50 words

Create Switches That Trigger Notifications

Fill HomeKit's biggest gap, custom notifications, with the Homebridge Messenger plugin and IFTTT to fire alerts from automation switches.

Jun 27·1 min read·43 words

Javascript Monorepo Tooling

A survey of JavaScript monorepo tools (lerna, yarn, pnpm, rush, nx, turborepo, changesets, auto) organized by installer, task-runner, and publisher.

Jun 7·1 min read·43 words

Podcast Tooling

Every tool I use to run the devtools.fm podcast, from guest scheduling and remote recording to editing, distribution, the website, and analytics.

Jun 5·1 min read·46 words

Podcast Social Clips

How I cut short promo clips from each devtools.fm episode for social media, plus the video length limits for every platform.

Jun 1·1 min read·45 words

Podcast Production Process

My full Descript workflow for producing a devtools.fm episode, from video and audio cuts to final polish and publishing across platforms.

Jun 1·1 min read·45 words

Essential Mac Apps

The apps I install on every Mac: Raycast, Ghostty, CleanShot X, PixelSnap, ColorSlurp, Cursor, and more for everyday and developer work.

Jun 1·1 min read·45 words

Devtools Fm

devtools.fm is my interview podcast about developer tools and the people who make them, co-hosted with Justin Bennett. Here's where to find it.

May 31·1 min read·48 words

Podcast Editing Organization

How I structure compositions in Descript to edit and produce devtools.fm, from the multi-track sequence to social and YouTube clip folders.

May 31·1 min read·45 words

Terminal Setup

A walkthrough of my terminal setup (Ghostty, oh-my-zsh, Powerlevel10k) plus the prompt customizations and aliases that make it feel amazing.

May 30·1 min read·42 words

Git Aliases

The Git aliases and color config I use every day, including a smart push helper and a one-liner to clean up merged branches.

May 30·1 min read·48 words

Better Default Tools

Modern replacements for the default command-line tools on your computer: bat, eza, delta, fzf, and zoxide for a prettier, faster terminal.

May 30·1 min read·45 words