Upgrade to use SQLAlchemy 2.x

PeterC · February 26, 2026, 7:15am

Are there plans in place to upgrade to Version 2.x of SQLAlchemy?

I’m looking to replace cx_Oracle that is currently used, with python-oracledb, but this isn’t supported until 2.0.25 [I think] of SQLAlchemy.

Thanks …

cornelinux · February 26, 2026, 7:17am

Yes, It is in the master branch.

github.com/privacyidea/privacyidea

requirements.txt

master


      
              #   python-dateutil
              #   smpplib
          smpplib==2.2.4 \
              --hash=sha256:0fab94702f0a70500d654e8df69933465728770e75838ecceef0314b4442d0c2 \
              --hash=sha256:6f3b036fcb2643c1b7a3289bb5ac4c9a720af1bf73e572e2729db6b5d800c273
              # via privacyIDEA (pyproject.toml)
          soupsieve==2.8 \
              --hash=sha256:0cc76456a30e20f5d7f2e14a98a4ae2ee4e5abdc7c5ea0aafe795f344bc7984c \
              --hash=sha256:e2dd4a40a628cb5f28f6d4b0db8800b8f581b65bb380b97de22ba5ca8d72572f
              # via beautifulsoup4
          sqlalchemy==2.0.43 \
              --hash=sha256:022e436a1cb39b13756cf93b48ecce7aa95382b9cfacceb80a7d263129dfd019 \
              --hash=sha256:03d73ab2a37d9e40dec4984d1813d7878e01dbdc742448d44a7341b7a9f408c7 \
              --hash=sha256:07097c0a1886c150ef2adba2ff7437e84d40c0f7dcb44a2c2b9c905ccfc6361c \
              --hash=sha256:11b9503fa6f8721bef9b8567730f664c5a5153d25e247aadc69247c4bc605227 \
              --hash=sha256:11f43c39b4b2ec755573952bbcc58d976779d482f6f832d7f33a8d869ae891bf \
              --hash=sha256:13194276e69bb2af56198fef7909d48fd34820de01d9c92711a5fa45497cc7ed \
              --hash=sha256:136063a68644eca9339d02e6693932116f6a8591ac013b0014479a1de664e40a \
              --hash=sha256:14111d22c29efad445cd5021a70a8b42f7d9152d8ba7f73304c4d82460946aaa \
              --hash=sha256:1681c21dd2ccee222c2fe0bef671d1aef7c504087c9c4e800371cfcc8ac966fc \
              --hash=sha256:1a113da919c25f7f641ffbd07fbc9077abd4b3b75097c888ab818f962707eb48 \

The next release will very likely support SQLA2.

PeterC · February 26, 2026, 9:44am

Great, thank you for the very quick, positive, response