Welcome!

This is a fairly minimal blog with assorted tech posts. The main plan is to come back to these posts when I forget how to do something, but if you find it useful too, that's great. :)

Recent Posts

• How Does Ollama's Structured Outputs Work?

  Posted on:9 December 2024  at 

  Digging into what Ollama is doing under the hood to produce structured outputs

• Relevant XKCD? - Testing Multimodal Retrieval

  Posted on:6 December 2024  at 

  Embedding XKCDs with nomic-embed-vision-v1.5 (and retrieving them with DuckDB)

• Preventing Overlapping Data in PostgreSQL - What Goes Into an Exclusion Constraint

  Posted on:20 October 2024  at 

  How can you prevent overlapping date ranges? Exclusion constraints do it at the database layer

• Quick CSV to SQLite with DuckDB

  Posted on:30 September 2024  at 

  Quickly creating SQLite databases with DuckDB, without writing schemas