Patrick Bacon on Atomic Spin

Java

Try Case-Insensitive Unicode Sorting in SQLite with Pre-collated Strings

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.

ChatGPT

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.

JavaScript

Here's an example of how to configure a Node Express app that uses express-ws for WebSocket support with the necessary options for TLS / mTLS.

PostgreSQL

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