Posts

All the articles I've posted.

• 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

• Psycopg Database Connections with FastAPI

  Posted on:28 July 2024  at 

  Sharing database connections between requests with FastAPI