Welcome to my digital garden!
I'm Alessandro Marrella, I'm a software engineer and a beginner artist.You can email me at hello @ this domain or chat with me in the socials linked below
Welcome to my digital garden!
I'm Alessandro Marrella, I'm a software engineer and a beginner artist.val.town is really cool. I was able to quickly add a “backend” to push thoughts to this static site
These are some notes on the tradeoffs and best practices between On Demand pricing vs Editions pricing.
A small TIL about Python profiling.
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’ll 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.
IN
and EXISTS
often produce the same result, but when negated and dealing with NULL
values, they behave differently.