Hello everyone,

Historically, many projects were using the following requirement for SQLAlchemy:

SQLAlchemy!=1.1.5,!=1.1.6,!=1.1.7,!=1.1.8,>=1.0.10

These banned versions were present in global-requirements.txt until earlier this month [1]. The remaining projects with the above requirement must change it to fix their requirements-check job (ERROR: Requirement for package SQLAlchemy excludes a version not excluded in the global list).

While fixing the requirement for blazar, I realised that OpenStack projects are using a wide range of minimum requirements. For example, networking-sfc had already bumped the minimum to SQLAlchemy 2.0 [2], although this is being reverted [3].

While all projects must be compatible with the upper constraint (currently 2.0.30), should we agree on a maximum version for the lower bound? The 2024.2 release targets Ubuntu Jammy, which includes python3-sqlalchemy 1.4.31, and Debian bookworm, which includes python3-sqlalchemy 1.4.46.

Thanks,
Pierre Riteau (priteau)

[1] https://review.opendev.org/c/openstack/requirements/+/879743
[2] https://review.opendev.org/c/openstack/networking-sfc/+/920046
[3] https://review.opendev.org/c/openstack/networking-sfc/+/920868