Should I use SQLite in‑memory or a disposable PostgreSQL container for SQLAlchemy integration tests that avoid production credentials?
Goal The goal is to run SQLAlchemy integration tests that exercise ORM behavior without exposing any production database credentials. Constraints and uncertainty Tests must remain isolated, avoid credential leakage in logs, and run quickly in CI. Using an in‑memory SQLite engine (sqlite:///:memory:) satisfies the credential‑free requirement but lacks Postgre