PostgreSQL Types by Reference

When writing a function to work with a specific table structure, you may have to match the argument types with table columns. If a table …

Exit Codes in psql

In PostgreSQL certain commands are forbidden in transactions or functions, and lack IF NOT EXISTS variants. Examples include CREATE DATABASE …

Second Brain

Someone recently told me about Building a Second Brain. The book presents a “CODE” approach: Capture, Organize, Distill, …

Separating Storage From llm Embeddings

The llm program uses sqlite to store embeddings. I want to store my embeddings in PostgreSQL. Rather than try to alter the built-in storage, …

Programming Throwdown

Jason Gauci and Patrick Wheeler have an excellent podcast called Programming Throwdown. I know Jason from the Austin CTO Club. The first …

A gh Alias For json Data

The GitHub command-line tool gh has a number of commands that can return json data. For example, this command returns the two fields of data …

Canary Islands

Today I spoke with a Ukranian entrepreneur now living in the Canary Islands. I didn’t know the population of the islands exceeds 2 …

An llm Plugin Hack

The llm package from Simon Willison has a plugin architecture. So I decided to try it. Any reasonable person would begin with a new model …

Convert Between json and yaml With yq

One of my experimental projects involves fetching data from GitHub with gh, editing the output, and then posting the results back to GitHub. …

Willison's llm

Simon Willison has created a marvelous tool for experimenting with LLMs at the command line: llm. It employs a plugin architecture and …