Paul Brabban articles - 12 total
GitHub Codespaces, one year later
Back in early 2024 I tried GitHub Codespaces, and quickly ditched my local dev setup entirely. This...
GROUP BY ALL solves a really annoying SQL problem
Does your SQL still copy most of your columns from SELECT after GROUP BY? Behold: GROUP BY ALL. ...
My path to consultancy
I had big doubts about becoming a consultant or contractor. Could I do it? Would I find work? Could...
Generating portable and user-friendly identifiers
I'll share how I generate unique identifiers from data in 2025, avoiding the pitfalls I've seen...
Using AWS billing to track down lost resources
My AWS bill was higher than I expected, and it wasn't immediately clear what was driving the cost....
Google Chrome Oct 15 update broke GitHub Codespaces
The Oct 15, 2024 update of Google Chrome stable (130.0.6723.58) suddenly broke some sites, such as...
Map over an array in BigQuery
This walkthrough shows how I can use the functional programming techniques map and filter that I...
Handling CVE-2018-20225
CVE-2018-20225 in all versions of pip tripped my vulnerability alerting this morning. If you're...
dbt 1.8 breaks on update
On updating dbt-bigquery to latest 1.8.0: No module named 'dbt.adapters.factory' Issue -...
How I Do Python Data Supply Chain Security
We data practitioners - data scientists, data engineers, analytics engineers, et al. - have a hard...
Why Try Codespaces?
Why I've been trialling GitHub Codespaces as a more secure alternative to local development. I...
Fine-Grained GitHub Access Tokens with mkdocs-material-insiders
mkdocs-material-insiders is the version of mkdocs-material with extra sponsor-only features. I...