Blog Archive

Other

• February 2026 Designing an R and Quarto Course for Analysts
• February 2026 Mapping Broadband Gaps with the Open Data Portal API
• January 2026 Quantifying What You Don’t Know: Using Empirica for Epistemic Tracking in AI-Assisted Research
• January 2026 Why Your AI Assistant Needs to Read Column Comments Before Querying Your Database
• January 2026 Git Hooks for Secret Detection
• December 2025 Fixing “bash: uname: command not found” Errors in VS Code Git Bash
• October 2025 Bristol Apprenticeship Analysis
• October 2025 Fuel Categorisation With Llm
• May 2025 Solving a Gnome Shell Crash: From deb-src to NVIDIA Drivers
• May 2025 Further testing of Cline
• May 2025 Integrating MotherDuck with Claude: A Failure
• May 2025 Setting up the github pages blog

MCP

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB
• May 2025 Setting up an MCP Server with Cline

Cline

• May 2025 Setting up an MCP Server with Cline

Server

• May 2025 Setting up an MCP Server with Cline

Setup

• May 2025 Setting up an MCP Server with Cline

AI

• July 2025 The Complete Agentic AI Engineering Course - 1.1
• May 2025 Setting up an MCP Server with Cline

labelling

• May 2025 Posit Conf 2024

tidypredict

• May 2025 Posit Conf 2024

orbital

• May 2025 Posit Conf 2024

duckdb

• February 2026 Building an interactive ERD for a MotherDuck database with Claude MCP
• September 2025 CRS transformation in Duckdb SPATIAL
• September 2025 Unnesting JSON in duckdb
• June 2025 ETL for ODS analytics data
• June 2025 A Glimpse function for DuckDB
• May 2025 Workflow for diagrams with AI
• May 2025 Source database for LNRS Data Model
• May 2025 Posit Conf 2024

models

• May 2025 Posit Conf 2024

packages

• May 2025 Corey Schafer’s UV Video
• May 2025 Posit Conf 2024

uv

• May 2025 Corey Schafer’s UV Video

.venv

• May 2025 Corey Schafer’s UV Video

dependencies

• May 2025 Corey Schafer’s UV Video

install

• May 2025 Corey Schafer’s UV Video

python

• May 2025 Corey Schafer’s UV Video

sql

• September 2025 CRS transformation in Duckdb SPATIAL
• June 2025 A Glimpse function for DuckDB
• May 2025 Workflow for diagrams with AI
• May 2025 Source database for LNRS Data Model

lnrs

• May 2025 Workflow for diagrams with AI
• May 2025 Source database for LNRS Data Model

ERD

• May 2025 Workflow for diagrams with AI
• May 2025 Source database for LNRS Data Model

mermaid

• May 2025 Workflow for diagrams with AI
• May 2025 Source database for LNRS Data Model

excalidraw

• May 2025 Workflow for diagrams with AI

drawio

• May 2025 Workflow for diagrams with AI

glimpse

• June 2025 A Glimpse function for DuckDB

R

• August 2025 Positron IDE - first impressions
• June 2025 Setup for R in VS Code
• June 2025 Testing Syntax Highlighting for R and Python
• June 2025 Converting from WKB to Geopoint in R
• June 2025 A Glimpse function for DuckDB

dplyr

• June 2025 A Glimpse function for DuckDB

spatial

• June 2025 Converting from WKB to Geopoint in R

sf

• June 2025 Converting from WKB to Geopoint in R

opendatasoft

• March 2026 Building a Claude Code skill from an OpenAPI spec with mcp2cli
• June 2025 Converting from WKB to Geopoint in R

geo

• June 2025 Converting from WKB to Geopoint in R

syntax highlighting

• June 2025 Testing Syntax Highlighting for R and Python

code examples

• June 2025 Testing Syntax Highlighting for R and Python

Python

• June 2025 Testing Syntax Highlighting for R and Python

VS Code

• June 2025 Setup for R in VS Code

setup

• June 2025 Setup for R in VS Code

nushell

• June 2025 ETL for ODS analytics data

ETL

• October 2025 AI Workflow - from deep research to ETL automation
• June 2025 ETL for ODS analytics data

API

• October 2025 AI Workflow - from deep research to ETL automation
• June 2025 ETL for ODS analytics data

LLM

• July 2025 The Complete Agentic AI Engineering Course - 1.1

Agentic AI

• August 2025 Positron IDE - first impressions
• July 2025 The Complete Agentic AI Engineering Course - 1.1

SQL

• August 2025 DuckDB - a couple of learnings

over()

• August 2025 DuckDB - a couple of learnings

csv

• August 2025 DuckDB - a couple of learnings

IDE

• August 2025 Positron IDE - first impressions

json

• September 2025 Unnesting JSON in duckdb

unnest

• September 2025 Unnesting JSON in duckdb

struct

• September 2025 Unnesting JSON in duckdb

CRS

• September 2025 CRS transformation in Duckdb SPATIAL

geometry

• September 2025 CRS transformation in Duckdb SPATIAL

geojson

• September 2025 CRS transformation in Duckdb SPATIAL

polars

• November 2025 Vibe coding - further learning
• November 2025 Vibe coding a CRUD application with Claude Code
• October 2025 AI Workflow - from deep research to ETL automation

energy

• October 2025 AI Workflow - from deep research to ETL automation

httpx

• October 2025 AI Workflow - from deep research to ETL automation

Agentic coding

• December 2025 Claude setup repo
• December 2025 Vibe coding project list
• November 2025 Vibe coding - further learning
• November 2025 Agentic code learnings today
• November 2025 Vibe coding a CRUD application with Claude Code
• October 2025 AI Workflow - from deep research to ETL automation

Google Gemini

• October 2025 AI Workflow - from deep research to ETL automation

Copilot

• October 2025 AI Workflow - from deep research to ETL automation

CRUD

• November 2025 Vibe coding - further learning
• November 2025 Vibe coding a CRUD application with Claude Code

LNRS

• November 2025 Vibe coding - further learning
• November 2025 Vibe coding a CRUD application with Claude Code

Claude Code

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB
• December 2025 Claude setup repo
• December 2025 Vibe coding project list
• November 2025 Vibe coding - further learning
• November 2025 Agentic code learnings today
• November 2025 Vibe coding a CRUD application with Claude Code

DuckDB

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB
• November 2025 Vibe coding - further learning
• November 2025 Vibe coding a CRUD application with Claude Code

Streamlit

• November 2025 Vibe coding - further learning
• November 2025 Vibe coding a CRUD application with Claude Code

Droid

• November 2025 Agentic code learnings today

Workflow

• November 2025 Agentic code learnings today

Motherduck

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB
• December 2025 Claude setup repo

Chrome

• December 2025 Claude setup repo

HuWise

• December 2025 Claude setup repo

OpenDataSoft

• December 2025 Claude setup repo

Data Lakehouse

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB

Medallion Architecture

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB

Schema Documentation

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB

UK Geography

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB

EPC Data

• January 2026 Building a Regional Analytics Local Lakehouse with DuckDB

motherduck

• February 2026 Building an interactive ERD for a MotherDuck database with Claude MCP

mcp

• March 2026 Building a Claude Code skill from an OpenAPI spec with mcp2cli
• February 2026 Building an interactive ERD for a MotherDuck database with Claude MCP

claude

• March 2026 Building a Claude Code skill from an OpenAPI spec with mcp2cli
• February 2026 Building an interactive ERD for a MotherDuck database with Claude MCP

data-engineering

• February 2026 Building an interactive ERD for a MotherDuck database with Claude MCP

open-data

• March 2026 Building a Claude Code skill from an OpenAPI spec with mcp2cli

cli

• March 2026 Building a Claude Code skill from an OpenAPI spec with mcp2cli

skills

• March 2026 Building a Claude Code skill from an OpenAPI spec with mcp2cli

huwise

• March 2026 Building a Claude Code skill from an OpenAPI spec with mcp2cli