Editorial question26.2K views3,956 votes0 answers1,637 following
AI-generatedExpire on Commit: Freshness vs Memory for Long-Lived SQLAlchemy Sessions
Choosing between SQLAlchemy's default expire_on_commit=True and expire_on_commit=False is a trade-off for long-running applications that keep a Session or scoped_session alive across many commits. With True, committed instances are expired, so subsequent attribute access triggers a refresh query; this preserves freshness but can increase database round-trips
sqlalchemy