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

Thoughts on how an integration of a CLI (command line interface) toolkit for the Pyramid web framework might look like and could be integrated into the configuration mechanisms of Pyramid itself.

Working with Heroku Connect means that at some point some records will end up in a failed state. This post shows a few options how to trigger the sync manually again.

Channels can play a tricky role when using the Nix package manager to manage development environments. Especially when one want to make sure that a derivation builds against multiple channels. This post shows how to quickly build a derivation against a different channel based on setting a URL into the include path for Nix.

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.

Thoughts on providing a nice CLI (command line interface) for Pyramid applications based on Click and the API of the Pyramid web framework.

Small SQL snippet to quickly get an overview of the row count in a PostgreSQL database.

A common need is to bring up a web server ad-hoc to serve out some files via HTTP. Most of the time I am using this trick when I want to serve a local directly quickly via HTTP without setting up anything for it.

Python has a module http.server …

A bookmark based workflow for Mercurial which aims to be similar to a branch based Git workflow.