Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Oracle Database Python Driver cx_Oracle Now on GitHub

DZone's Guide to

Oracle Database Python Driver cx_Oracle Now on GitHub

Oracle's Python driver, cx_Oracle, has found a new home on GitHub and an array of new features. See where to find it and what you can do with it now.

· Database Zone
Free Resource

Learn how to create flexible schemas in a relational database using SQL for JSON.

The fully open source Oracle Database Python driver cx_Oracle has found a new home and has its source code repository now hosted on Oracle's GitHub, reinforcing our commitment to bring more open source projects to the platform. You can find the repository under: github.com/oracle/python-cx_Oracle. This driver is widely popular amongst Python developers, data scientists, and many other users, and it is one of the most downloaded drivers for the Oracle Database.

Along with that, the latest new version of the driver 5.3 is now available for download. This version, a long awaited release by the community, brings many new key features. For a detailed write up on those and more see Chris Jones’ blog post. Version 5.3 supports Python 2.7, 3.4 and higher and you can use cx_Oracle with Oracle 11.2, 12.1 and 12.2 client libraries, allowing connections to multiple Oracle Database versions. The driver is also represented on the PyPI Python Package Index, making installing cx_Oracle as simple as running pip install cx_Oracle.

Other key new features are:

  • Direct binding to SQL objects
  • PL/SQL records and collections can be bound
  • Support for scrollable cursors
  • Support for Advanced Queuing
  • Fetch PL/SQL implicit results
  • Support for Statement Caching

Find the complete list of key new features on Chris' blog about this release.

We are also very proud of the fact that Anthony Tuininga, long time contributor of cx_Oracle, has decided to join Oracle and making maintaining the driver his full-time job. Welcome aboard, Anthony!

What's Ahead: cx_Oracle 6.0

Anthony has already looked ahead to version 6, which aims to be even better. Over the past year, he'ss been working hard on ODPI-C, an open source library of C code that simplifies and standardizes the use of common Oracle Call Interface (OCI) features, such as those used by cx_Oracle. ODPI-C was recently released on the Oracle GitHub odpi repository. As you can see from the cx_Oracle source code, the master branch of cx_Oracle code has been updated to use ODPI-C. If you want to test the current state of this future release, download a bundle from GitHub and build it.

Create flexible schemas using dynamic columns for semi-structured data. Learn how.

Topics:
python ,oracle database ,database ,drivers

Published at DZone with permission of Bruno Borges. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}