Patrick Bacon on Atomic Spin

PostgreSQL

How to Partition Consecutive Rows with PostgreSQL

You can use PostgreSQL's window function capabilities to partition data over a specific number of consecutive rows preceding any given row.

React / Redux

Prevent an Unnecessary Refetch with nextFetchPolicy and Apollo Client

I recently figured out the cause of a strange issue due to a change in how the cache-and-network fetch policy works in Apollo Client 3.

TypeScript

Updated “Branding” for a Strongly-Typed Date String in TypeScript

Due to changes to TypeScript, I've updated my branding strategy so that the DateStr type works properly in newer versions of TypeScript.

Developer Tools

A LaunchAgent for Automatic Proxy Configuration

Start an automatic Proxy Configuration (PAC) HTTP server at startup, using LaunchCtl and miniserve, for proxying a VPN connection on macOS.

Developer Tools

How to Fix a Prisma Library Load Problem with Cypress on macOS

Here's how to fix the "Unable to Load Node-API Library" error that can come up when trying to use Prisma in Cypress tasks on macOS.

Web Apps

Cypress in Docker with VNC

This post describes the dependencies and configuration needed to run X11, a VNC server, and to get Cypress running in a Docker container.

Extracurricular Activities

Self-Hosted PostgreSQL with SSL in Docker

Here I share all the configuration details needed to self-host PostgreSQL running in a Docker container, with a valid SSL certificate from Let's Encrypt.

Platforms & Languages

Foreach Loops and Timeouts in 3 Languages

Documenting the behavior of using setTimeout (or similar) in a foreach loop in three different languages: Squirrel, TypeScript, and C#.

Extracurricular Activities

Configuring IP Passthrough with an AT&T BGW210-700 and a UDM Pro

The steps I took to configure an AT&T (Arris) BGW210-700 router for IP Passthrough mode, going to a Unifi Dream Machine Pro.

Developer Tools

Azure Functions Request Tests

Conclusion of a 4-part series on how to write an end-to-end test for an Azure Functions API in C#, within the unit testing framework.

.NET / WPF

Using Reflection to Find Azure Function Methods

Part of a series on writing request tests for a C# Azure Functions API in xUnit, this post shows how to use reflection to locate the HTTP triggered methods.

.NET / WPF

Testing JSON Input/Output in Azure Functions Request Tests

Improve request tests for an Azure Function by serializing/deserializing JSON using the same configuration that the framework would use in production.

Patrick Bacon

Keep up with our latest posts.