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.

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

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