Alembic

Verify a PostgreSQL constraint with pytest and Testcontainers

Runs a migration-backed pytest integration test against PostgreSQL and proves case-insensitive email uniqueness.

Why must an Alembic autogenerated migration be reviewed before deployment?

Treats Alembic autogeneration as a candidate schema diff that still needs semantic and operational review.

Python Backend

Python backend interview preparation grounded in real service development.

A backend-focused Python preparation path covering language semantics, typing, FastAPI, Django, concurrency, data access, testing, security, background work, reliability, and production diagnosis.