PostgreSQL is powerful and widely compatible, supporting the complete SQL standard, including transactions, foreign keys, ...

Install PostgreSQL with pip install pgvenv pgvenv is a Python package that embeds a fully isolated PostgreSQL installation in your virtual environmnent.