An example how to use plain SQL to migrate data in a database using Alembic.

Showing how to use pg_restore to load a dump into a developer's database server for local development.

How to remove a line from a text file based on the line number with sed.

The idea of EditorConfig is to have a file called .editorconfig in your project repository, so that the editors and IDEs of the participating developers can automatically adjust to it.

There is also a mode for Emacs / Spacemacs, which can be integrated quite easily in the following steps:

1. Add editorconfig …

How to spin up a local SMTP server for testing purposes.

First thoughts on using node2nix to mange a development environment which contains a mix of Python and Node dependencies. In this step I describe my use case and the first impressions of node2nix.

The package collection nixpkgs has a nice way to configure and tweak the package set based on the configuration file ~/.nixpkgs/config.nix.

Changing something in pythonPackages was not so obvious to me though. In my case I used dulwich on Darwin. It was pulled in as a dependency of …

Around forms and APIs the problem of validating input data and serializing application data into simple data structures occurs on a regular base to me. marshmallow is a Python library which aims to solve this problem and appears to be pretty flexible.

I have evaluated it recently as a candidate …

Sometimes I want to install a Python dependency into my working environment just to try out something quickly, and decide afterwards if I want to keep it or not. This is a case where a good old run of pip install would do just fine.

Overview and insights into how development environments for Python can be reliably managed based on the Nix package manager.