A partial unique index allows to constrain only a subset of the records in a table. This post shows an example how to implement a partial unique constraint with SQLAlchemy.

Setting custom meta data with Pelican can be implemented easily. This post shows a small example how I solved it.

Two approaches to quickly compare two similar tables and get an idea of how many records differ based on an example with geo data.

Having a list of all packages available in a simple text file is enough to get a good overview of available packages.

An example Nix snippet which provides the Salesforce migration tool inside of a shell environment based on the Nix package manager.

A small sed snippet to translate the output of heroku config into export calls for the shell.

A small snippet to get the version if the nixpkgs which are currently used. Useful when tracking down trouble and trying to reproduce things with the correct commit.