I work as an analyst in the public sector. I’m interested in using code to solve problems and give insights. I code slowly in R, Python and SQL and some web stack. I like to explore new technologies and tools like duckDB, Polars, Quarto, AI, Claude and all that good stuff.
This blog is intended to capture my learnings around data, analysis and technology. All views and posts are personal opinion.
Posts
-
Building a Claude Code skill from an OpenAPI spec with mcp2cli
-
Building an interactive ERD for a MotherDuck database with Claude MCP
-
Designing an R and Quarto Course for Analysts
-
Mapping Broadband Gaps with the Open Data Portal API
-
Quantifying What You Don’t Know: Using Empirica for Epistemic Tracking in AI-Assisted Research
-
Why Your AI Assistant Needs to Read Column Comments Before Querying Your Database
-
Building a Regional Analytics Local Lakehouse with DuckDB
-
Git Hooks for Secret Detection
-
Fixing “bash: uname: command not found” Errors in VS Code Git Bash
-
Claude setup repo
-
Vibe coding project list
-
Vibe coding - further learning
-
Agentic code learnings today
-
Vibe coding a CRUD application with Claude Code
-
Bristol Apprenticeship Analysis
-
AI Workflow - from deep research to ETL automation
-
Fuel Categorisation With Llm
-
CRS transformation in Duckdb SPATIAL
-
Unnesting JSON in duckdb
-
Positron IDE - first impressions
-
DuckDB - a couple of learnings
-
The Complete Agentic AI Engineering Course - 1.1
-
ETL for ODS analytics data
-
Setup for R in VS Code
-
Testing Syntax Highlighting for R and Python
-
Converting from WKB to Geopoint in R
-
A Glimpse function for DuckDB
-
Workflow for diagrams with AI
-
Source database for LNRS Data Model
-
Corey Schafer’s UV Video
-
Posit Conf 2024
-
Solving a Gnome Shell Crash: From deb-src to NVIDIA Drivers
-
Further testing of Cline
-
Integrating MotherDuck with Claude: A Failure
-
Setting up an MCP Server with Cline
-
Setting up the github pages blog
subscribe via RSS