Review on using Nix to manage development environments for Python projects.

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.

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.

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.