How to quickly profile python imports and runtime
A small TIL about Python profiling.
til
NOT IN and NOT EXISTS don't always produce the same result
IN and EXISTS often produce the same result, but when negated and dealing with NULL values, they behave differently.
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.
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.