Sqitch Templates

Sqitch has a template mechanism that follows the same design pattern as its migration files. This makes it easy to manage templates with …

Variables in Sqitch

Sqitch supports variables in the config file like this:

[target "foo"]
    engine = pg
    uri = your-connection-string-here …

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 …