blog
Setting up SSH in 1password for both authentication and git signing
I recently had to set up a new Mac for programming. I took the opportunity to do what a colleague suggested me to do a long time ago: ditch gpg, gpg-agent, and such in favor of 1Password. This setup is much simpler and I believe more secure than what I was doing before.
BigQuery Editions vs On Demand
These are some notes on the tradeoffs and best practices between On Demand pricing vs Editions pricing.
BigQuery performance best practice: use semi joins when possible
SQL is an amazing language, it lets you declaratively say what you want, and the engine figures out for you the best way to return it to you. Or should I say, it figures out the best way to return it to you given the information it has and the capabilities of the engine itself.
In this post, we鈥檒l discuss a performance optimization technique for BigQuery (also other advanced enough Enteprise Data Warehouses and databases support SEMI JOINS, but I'll focus on BigQuery since it's the one I use the most these days): using semi joins.
How to run and serve a webserver in Google Colab without ngrok
Today I learned how to run a webserver in Google Colab, without needing external services like ngrok. I'm using Dagster here as an example but any webserver should work.
[VIDEO] Powering machine learning pipelines with Dagster
Presentation I gave at the Dagster Community Meeting on the 21st of September, 2021 on how to use Dagster for machine learning purposes, with an explanation on why we chose that instead of Airflow.
Avoiding ZIP does not support timestamps before 1980 in Nix with Python
By default, nix sets the epoch to be 1 (which corresponds to 1970-01-01), this causes some issues when building some Python packages. Since the zip might contain files from the nix store, those are dated 1970 breaking the installation of the python package.
How to get started with Nix
I started learning Nix a few months ago, when it was introduced to the company I work for by some brilliant coworkers. I'm still learning and exploring this space, but I thought I'd share a few tips and resources that helped me start this journey to help newbies like me start working with this tool.
Kubernetes Webhooks in Haskell and Dhall
I spent the past few weeks fighting with Kubernetes Admission Controllers (also known as Mutating/Validating Webhooks).
[SLIDES] Introduction to meta-programming in Scala
Slides from the talk I gave at the Dublin Scala Users Group on the 23rd of January 2019