Removing the lint from BigQuery SQL with SQLFluff

Removing the lint from BigQuery SQL with SQLFluff image

Our reporting stack is built atop over 15k lines of BigQuery SQL that I have been trying to tame. Having made good use of Python formatters and linters like Black and Flake8, I wanted a linter that could help me clean up the code and also potentially be integrated with pre-commit and GitHub Actions.

Read more

Falling in love with a mermaid

Falling in love with a mermaid image

It's the 14th of February so rather than buying any useless stuff I don't need for a fake holiday, I thought I'd play with a charting library.

Read more

Julia, are you sure I should commit?

Julia, are you sure I should commit? image

I've been working on Julia for a week now and wanted to add some pre-commit hooks to the module I have started creating. One of the strengths of the pre-commit library for Python is the ability to create hooks for other languages. I didn't find any existing hooks dedicated to Julia although there are a few simpler hooks to handle whitespace etc that could be applied. I decided to investigate trying to build some Julia-specific hooks from scratch.

Read more