Patrick Bacon on Atomic Spin

The Entity Framework: WHERE IN vs. OPENJSON Problem

Let's look at mitigations for slow queries caused by Entity Framework using OPENJSON instead of a basic WHERE IN clause for collections.

Developer Tools

Here's how and why you should log your ZSH History. Use a zsh hook to save commands to daily log files, allowing for easy searching.

Java

Here's how you use the Collator class in Java to pre-collate Unicode strings in a case-insensitive way so that SQLite can index/sort them.

Developer Tools

Here are some examples of using the jq command-line utility to create new JSON data from scratch or update values in an existing JSON document.

The Software Life

Here's how to use the power of LLMs to generate Common Table Expressions, making a legacy database easier to work with for ad-hoc queries.

Developer Tools

Here's how to tell an installed Java application to use the macOS system proxy for network traffic, so it can be directed through a VPN.

Java

Here are example implementations of creating a Java Stream API that yields the entries in a ZIP archive, reading from a provided InputStream.

Java

Here's a code example of programmatically configuring Ehcache in a Spring Boot application with a persistent disk store.

Web Apps

Here's a way to force Playwright to wait for hydration of a SvelteKit page before starting to interact with it in automated browser tests.

Development

Frozen thinking can be a problem for senior developers. Let's examine why it's a problem and some practices to overcome it.

JavaScript

Here's an Express middleware function that uses the busboy library to save an uploaded (multipart form) file to a temp file on disk.

Python

Statically linking OpenSSL to Python is not officially supported, but there are a couple of ways it can be done.