Python-oracledb 2.4 has been released

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

Photo by kazuend on Unsplash

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 the new name for the cx_Oracle driver.

To get started quickly, use samples/sample_container to create a container image containing Oracle Database and python-oracledb.

Top Features in python-oracledb 2.4

• Support for Oracle Database 23ai Pipelining. This is a great feature. For details, see my companion blog post Pipelined database operations with python-oracledb 2.4.
• A refactored connection string parser to improve support for various connection string syntaxes.
• Added packages for Python 3.13 and dropped support for Python 3.7.

Other enhancements and bug fixes also landed. Check out the release notes for details.

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

Home page: oracle.github.io/python-oracledb/index.html

Installation instructions: python-oracledb.readthedocs.io/en/latest/installation.html

Documentation: python-oracledb.readthedocs.io/en/latest/index.html

Release Notes: python-oracledb.readthedocs.io/en/latest/release_notes.html

Discussions: github.com/oracle/python-oracledb/discussions

Issues: github.com/oracle/python-oracledb/issues

Source Code Repository: github.com/oracle/python-oracledb