SQLAlchemy ORM

SQLAlchemy is used for relational database access and migrations.

Engine creation

from sqlalchemy import create_engine

engine = create_engine(DB_URL, pool_pre_ping=True)

Session lifecycle

from sqlalchemy.orm import sessionmaker

Session = sessionmaker(bind=engine)

Always close sessions explicitly in background workers.