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 …

How to migrate custom fields with the Salesforce Migration Tool avoiding failures due to unknown permissions.

A wrap up of a simple fixture for py.test which creates a test database based on SQLAlchemy.

Very good summary to refresh the relevant bits about JavaScript as a language.

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

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.

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 …

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