RSSAmplifier

Blog

Dan Clayton's Blog

A simple software blog.

blog.danielclayton.co.ukRSS feed ↗9 posts

Latest posts

AWS ECS Express Mode is a bit naff

Why I had to ditch AWS's flagship way to 'easily' deploy containers

Docker build caching in CI (for multi-stage builds)

How and why to set up registry build caching in CI, with a GitLab example

How Does Ollama's Structured Outputs Work?

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

Relevant XKCD? - Testing Multimodal Retrieval

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

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

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

Quick CSV to SQLite with DuckDB

Quickly creating SQLite databases with DuckDB, without writing schemas

Psycopg Database Connections with FastAPI

Sharing database connections between requests with FastAPI

Refactoring list logic using Python sets

Replacing loops and ifs with Python sets for a speedup and better readability.

Starting a new Python project - an opinionated starter guide

An opinionated mini-guide to setup a new Python project from scratch with *most* of the tooling you will need.