Small example how to print out a SQLAlchemy query with parameters being expanded.

When displaying items based on a database search, one sometimes wants to display a specific set of items at the top or bottom of the result set. Applying the custom order inside of the database query allows to still use LIMIT and OFFSET in a natural way.

A hint on how to store the Heroku Connect mapping configuration in a repository, so that diffs are readable and a useful information of the system changes over time.

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.