메뉴 건너뛰기

Korea Oracle User Group

새소식

Python python-oracledb Driver

명품관 2023.04.05 11:13 조회 수 : 2099

파이썬 python-oracledb Driver 1.3.0 버전 릴리즈

 

URL : https://oracle.github.io/python-oracledb/index.html

 

python-oracledb 드라이버는 기존 cx_Oracle 드라이버의 새로운 이름이며 

이 명칭은 2022년 5월경 python-oracledb 1.0 버전 릴리즈 때부터 사용하기로 한 거 같습니다. 

 

이 드라이버가 2023년 3월 1.3.0 버전으로 릴리즈가 되었습니다.

해당 내용은 위 URL 사이트에서 참고하시면 되겠습니다.

 

릴리즈 노트 URL : https://python-oracledb.readthedocs.io/en/latest/release_notes.html#releasenotes

 

아래는 python-oracledb 1.3 소식에 대한 원문 내용입니다.

 


The python-oracledb 1.3 driver for Oracle Database

The python-oracledb driver is a Python programming language extension module allowing Python programs to connect to Oracle Database. Python-oracledb is the new name for Oracle's popular cx_Oracle driver.

The module conforms to the Python Database API 2.0 specification with a considerable number of additions and a couple of minor exclusions, see the feature list.

Getting Started

Installation

See python-oracledb Installation for detailed instructions.

Dependencies

  • Python versions 3.6 through 3.11.

    Pre-built packages on PyPI are available for Windows Python 3.7 or later, for macOS Python 3.7 or later, and for Linux Python 3.6 or later.

    Source code is also available.

  • Oracle Client libraries are optional.

    Thin mode: By default, python-oracledb is a 'Thin' driver which connects directly to Oracle Database. This mode does not need Oracle Client libraries.

    Thick mode: Some advanced Oracle Database functionality is currently only available via Oracle Client libraries. You can install these libraries using the free Oracle Instant Client packages. Python-oracledb works with Oracle Client libraries 11.2 through 21c. See Enabling python-oracledb Thick mode.

  • Oracle Database

    Thin mode: Connects to Oracle Database 12c, 18c, 19c and 21c.

    Thick mode: Connects to Oracle Database 11.2, 12c, 18c, and 21c, depending on the Oracle Client library version. Oracle Database's standard client-server version interoperability allows connection to both older and newer databases. For example, when python-oracledb uses Oracle Client 19c libraries, it can connect to Oracle Database 11.2 or later.

Documentation

See the python-oracledb Documentation and Release Notes.

You can use assistive technology products, such as screen readers, while you work with the documentation. You can also use the keyboard instead of the mouse.

Help

Questions can be asked on GitHub Discussions. Identified issues can be raised as GitHub Issues.

Tests

See the test suite.

Contributing

See CONTRIBUTING.

Features

  • Easily installed from PyPI. No additional install is required - you just need an available Oracle Database.

  • Support for Python 3.6 and higher.

  • Optional use of Oracle Client 11.2, 12, 18, 19 or 21 libraries for advanced Oracle Database functionality. Oracle's standard cross-version interoperability, allows easy upgrades and connectivity to different Oracle Database versions.

  • Connects to Oracle Database 11.2, 12, 18, 19 or 21 on-premises or in the Cloud.

  • SQL and PL/SQL Execution with significant optimizations including compressed fetch, pre-fetching, client and server result set caching, and statement caching with auto-tuning.

  • Full use of Oracle Network Service infrastructure, including encrypted network traffic and security features.

  • Extensive Oracle data type support, including large object support (CLOB and BLOB).

  • Direct binding to SQL objects. One great use case is binding Python objects to Oracle Spatial SDO objects.

  • JSON datatype support.

  • SODA (Simple Oracle Document Access).

  • Array operations for efficient INSERT, UPDATE and MERGE execution.

  • Array row counts and batch error handling for array operations.

  • Fetching of large result sets with easy tuning.

  • REF CURSOR support.

  • Support for scrollable cursors. Go back and forth through your query results.

  • Fetch PL/SQL Implicit Results. Easily return query results from PL/SQL.

  • Row Prefetching. Efficient use of the network.

  • Client Result Caching. Improve performance of frequently executed look-up statements.

  • Support for Advanced Queuing. Use database notifications to build micro-service applications.

  • Continuous Query Notification (CQN). Get notified when data changes.

  • Support for Edition Based Redefinition. Easily switch applications to use updated PL/SQL logic.

  • Support for setting application context during the creation of a connection, making application metadata more accessible to the database, including in LOGON triggers.

  • End-to-end monitoring and tracing.

  • Transaction management and Two-phase Commits.

  • Session Pooling, with tagging and session state fix-up callback.

  • Database Resident Connection Pooling (DRCP).

  • Privileged Connections.

  • External Authentication.

  • Token Authentication.

  • Database startup and shutdown.

  • Oracle Sharding connectivity.

  • Oracle Database High Availability Features, such as FAN notifications, Application Continuity, and Transaction Guard support.

Some features above are only available in Thick mode. See the user documentation Oracle Database Features Supported by python-oracledb for more information.

Python DB API specification exclusions:

  • The TIME data type is not supported by Oracle Database and is therefore not implemented.

  • The method cursor.nextset() is not implemented because the specification assumes an implementation of cursors that does not fit well with Oracle Database's implementation of cursors and implicit results. See the method Cursor.getimplicitresults() for the Oracle replacement.

License

Python-oracledb license information is in LICENSETHIRD_PARTY_LICENSES and NOTICE.

번호 제목 글쓴이 날짜 조회 수 추천 수
138 ACE Blog Posts and Podcasts April 3 – April 9, 2023: Oracle 23c Free Developer Release, APEX, OCI, SQL, and More 명품관 2023.04.11 963 0
137 ADB Newsletter for April 2023 명품관 2023.04.11 8681 0
136 What's new in Oracle Help Center Learn: March 2023 명품관 2023.04.11 1282 0
135 Oracle 23c의 JSON Relational Duality(JSON 관계형 이원성)의 주요 이점 명품관 2023.04.05 782 0
» Python python-oracledb Driver 명품관 2023.04.05 2099 0
133 Introducing Oracle Database 23c Free – Developer Release [1] 명품관 2023.04.04 1301 0
132 ACE Blog Posts and Podcasts February 24 - March 23, 2023: APEX, Database, MySQL / SQL, OCI and More 명품관 2023.03.29 786 0
131 PostgreSQL JDBC 42.6.0 Released 명품관 2023.03.28 886 0
130 Virtual Classroom Series Upgrade to Oracle Database 19c 명품관 2023.03.27 4665 0
129 pgAdmin 4 v6.21 Released 명품관 2023.03.14 866 0
128 PostgreSQL 14 Internals 무료 pdf 제공 명품관 2023.03.13 1193 0
127 MariaDB Python Connector 1.1.6 now available 명품관 2023.03.09 807 0
126 What's new in Oracle Help Center Learn: February 2023 명품관 2023.03.09 1153 0
125 What’s in it for you? Attend Free MySQL Summit on March 23rd 명품관 2023.03.09 4032 0
124 Exadata System Software Updates - March 2023 명품관 2023.03.09 4581 0
123 Exadata System Software Release 23.1 명품관 2023.03.08 875 0
122 MariaDB Community Server 11.0 now RC 명품관 2023.02.27 585 0
121 MariaDB 10.11.2 GA now available 명품관 2023.02.27 752 0
120 RHEL runs on OCI supported by Oracle and Red Hat 명품관 2023.02.02 3973 0
119 Oracle Cloud Infrastructure and Red Hat Enterprise Linux 명품관 2023.02.01 6684 0
위로