Funny SQL bug because I thought row_number() started at 0
Recent Posts
Funny SQL bug because I thought
Don’t put your scale under your bed
I recently bought a smart scale. Why? Because I like data and I think it’s fun to collect and analyze my weight. But… I noticed something funny.
Refactoring code so that it becomes easier to test
I refactored a piece of code but I’m not sure if I made it better.
Dan Harmon’s Advice for Overcoming Writer’s Block
Dan Harmon, creator of Rick and Morty, fielded questions from redditors in an Ask Me Anything (AMA) a while ago.
How to change the font size of the code blocks in minimal mistakes using Github pages
In this blog post I want to share with you how to change the font size of the code blocks in the minimal mistakes Jekyll theme when using Github Pages.
Show your work: Writing complex SQL queries
This week I had to write this monster of an SQL query and I wanted to share some tips that I found useful.
Show your work: Automating cloud infrastructure using infrastructure-as-code
I want to share a little piece of work that I recently completed. Hope you enjoy!
How to structure your python code
In this post I want to show you how you can set up and structure your python code if you don’t know where to start. Just copy our setup!
Docker optimization trick: install your dependencies first and your code second
Is your docker build step slow? Assuming you can install your code as a package, try installing your dependencies first and your code second.
How to fix AttributeError: module ‘regex’ has no attribute ‘Match’ for SQLFluff
In this blog post I’ll show you how to fix the AttributeError: module 'regex' has no attribute 'Match error when trying to install SQLFluff. SQLFluff is pop...
How to scale up your code
As a machine learning engineer it is part of your job to run things on large data sets.
Our Amazon Sagemaker Processing job setup
At Snappet (we’re hiring!) we use Sagemaker Processing jobs to power most of our machine learning workflow. Sagemaker Processing jobs create our data, train...
How to see log messages while unit testing in pycharm
In this stackoverflow question someone asks how to view logging messages while unit testing. It got a lot of responses but none of them worked for me.
How to set up your Python projects with conda and poetry
At my current job we use conda to manage our environments and poetry to manage our packages. I have to say that the setup is pretty sweet and wanted to shar...