python-oracledb 1.1 for Oracle DB supports Azure OAuth 2.0 Tokens

Christopher Jones
Oracle Developers
Published in
1 min readSep 15, 2022
Abstract image
Photo by Ricardo Gomez Angel on Unsplash

python-oracledb 1.1, the extremely popular Oracle Database interface for Python, is now Production on PyPI.

python-oracledb is an open source package for the Python Database API specification with many additions to support advanced Oracle Database features.

Main Changes

  • Support for Azure Active Directory OAuth 2.0 and Oracle Cloud
    Infrastructure Identity and Access Management (IAM) token authentication to Oracle Autonomous Database.
  • Advanced Queueing improvements, including support for JSON payloads.
  • Thick mode (which uses Oracle Client libraries) can now be used on systems where Python’s cryptography package isn’t available for Thin mode connectivity. See Installing python-oracledb without the Cryptography Package.

See the Release Notes for more improvements and bug fixes.

Installing or Upgrading python-oracledb

You can install or upgrade python-oracledb by running:

python -m pip install oracledb --upgrade

The pip options --proxy and --user may be useful in some environments. See python-oracledb Installation for details.

python-oracledb References

Want to talk about it? Join our public developer Slack channel here.

--

--

Christopher Jones
Oracle Developers

Oracle Database Product Manager for language drivers including Python python-oracledb, Node.js node-oracledb, PHP OCI8 and more! On Mastodon: @cjbj@phpc.social