Python-oracledb 3.1 has been released with improved Advanced Queueing and Data Frame features

The python-oracledb 3.1 release is now available on PyPI.

Photo by Jean-Pierre Brungs on Unsplash

This is hot on the heels of last month’s big 3.0 release (see New release of python-oracledb 3.0 Fetches Directly to Data Frames, has Thin Mode AQ, supports Centralized Configuration Providers, and more). We had originally intended just to do a 3.0.x bug fix release, but some enhancements were ready to ship, so we decided to share them with you now as a feature release.

The enhancements are:

• Advanced Queueing in Thin mode now supports JSON payloads, and bulk enqueueing and dequeuing. These changes continue the progress towards Thin mode parity with Thick mode. AQ support was also extended to the python-oracledb async API too.
• The python-oracledb data frame query functionality was extended with support for CLOB, BLOB, and RAW data types.
• Support for scrollable cursors was added to python-oracledb Thin mode. Scrollable cursors are now useable in both modes.
• The other notable change was that we dropped support for Python 3.8, which the upstream maintainers already ceased supporting last year.

There are also plenty of bug fixes. Check the release notes for all the details.

Installing or Upgrading python-oracledb

You can install or upgrade python-oracledb by running:

python3 -m pip install oracledb --upgrade

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

Python-oracledb Resources

Python-oracledb is an open source package for the Python Database API specification with many additions to support advanced Oracle Database features. By default, it is a ‘Thin’ driver that is immediately usable without needing any additional install e.g. no Instant Client is required. Python-oracledb is used by frameworks, ORMs, SQL generation libraries, and other projects.

• Installation instructions: python-oracledb.readthedocs.io/en/latest/installation.html
• Documentation: python-oracledb.readthedocs.io/en/latest/index.html
• Discussions: github.com/oracle/python-oracledb/discussions
• Source Code: github.com/oracle/python-oracledb