SQLAlchemy and Idle in transaction queries
Orphaned transactions are a problem that could lead to messy states in the database. This is usually a good indicator that the something is not right in the manner in which connections are established and closed on the services that query the database.
Transactional Unit Tests with Pytest and Async SQLAlchemy
This is a quick how-to post if you’re working on migrating your database-backed applications to async-sqlalchemy and are looking to get a test framework in place.