sqlfluff

SQLFluff @ Coalesce 2020

The dbt project at tails.com has over 600 models and 66k lines of code. With multiple contributors to a project and varying SQL backgrounds, it's really difficult to maintain consistent readability and comprehension across a codebase like that by hand.

3dprinting

The Zen of Good Cable Management

I already feel less stressed.

3dprinting

Dry-Box for Sensitive Filament

PETG printing badly? Maybe you also need a dry box.

data

Growing Business Analytics on a Shoestring - Part 2

Following on from part 1, we go from getting serious into philosophy as we track our growing analytics function.

data

The Innovation Community Podcast

A few weeks ago I was lucky enough to feature on The Innovation Community Podcast hosted by Paul Capon. We took a rambling tour through life in small businesses and

design

A logo for sqlfluff

For around a year I've been working on sqlfluff, a SQL linter to keep up with the growing place of analytics code as a store of business definitions.  This post

diy

Reclaimed Shelves

The Croydon wood recycling centre is a great place, given everyone is locked down during the Covid19 pandemic, it's been a great time to make progress on some home improvement. This project involved... a lot of sanding.

data

DataIQ 100 2020

I was very humbled to be included in the DataIQ 100 for 2020. This is a repost of the bio included in that.

code

Continuous Deployment for Ghost Themes

My journey to upgrading Ghost and setting up continuous deployment for a custom Ghost theme using CircleCi.

code

SQL in 2019

SQL has been around for a long time, as a language for communicating with databases, as a communication protocol. More recently with the rise of data as a business function, or a domain in it's own right SQL has also become an invaluable tool for defining the structure of data.

data

Data from scratch, a blessing or a curse?

In this episode of the Hub and Spoken podcast, I have a chat with Jason Foster at Cynozure, discussing building data functions from scratch in a fast-paced business.

code

Enforcing DBT Dependencies in Snowflake

If you use dbt and Snowflake, we made a dbt package you can use to make sure that you keep your dependencies tidy and understandable.

cnc

CNC Mini Mill: Part 3 - Leadscrews, Leadscrews everywhere...

If one screw doesn't give you the stiffness you want, then why not add some more?

3dprinting

Extruders: Small is difficult

Designing a new, smaller, compact direct drive extruder for the hypercube was hard.

cnc

CNC Mini Mill: Part 2 - change of plan

We set out back in August to build a CNC Mini Mill using an old tumble drier motor. Here's how the plan changed.

code

Growing Business Analytics on a Shoestring - Part 1

This is a repost of my original post on the tails.com tech blog. Like lots of fast growing tech startups, our data needs at Tails.com have changed significantly

cnc

CNC Mini Mill: Part 1

How hard can it be. I mean, building a dasktop CNC Mini Mill from scratch, without access to an existing mill or lathe. If nothing else I'll learn something along

code

Codeship & Baking Arguments

In Codeship, CI environment variables aren't available at container build time. Here we use build arguments to achieve the same end and bake CI variables into containers.