Foxpodcast955

Latest version

Once Oracle, Python, cxOracle package and Instant Client are ready, we can connect to Oracle from Python. The following program will connect to Oracle Database using username hr and password hr. In case you are trying to use a different account or a different version of Oracle database then feel free to change the details and experiment. The cxOracle is designed to conform to the Python database API 2.0 specification. It also provides you with a number of additions designed specifically for the Oracle Database. The cxOracle 7.x works perfectly fine with Python version 2.7, and with versions from 3.5 to 3.7. In this section, we will only use the Python version from 3.5 to 3.7.

Released:

A very simple asynchronous wrapper that allows you to get access to the Oracle database in asyncio programs. - GoodManWEN/cx_Oracle_async

Project description

A very simple asynchronous wrapper that allows you to get access to the Oracle database in asyncio programs.

Easy to use , buy may not the best practice for efficiency concern.

Requirements

• cx_Oracle >= 8.1.0 (Take into consideration that author of cx_Oracle said he's trying to implement asyncio support , APIs maybe change in future version. Switch to 8.1.0 if there's something wrong makes it not gonna work.)

Install

Feature

• Nearly all the same as aiomysql in asynchronous operational approach , with limited cx_Oracle feature support.
• No automaticly date format transition built-in.
• AQ feature added , check docs here for further information.
• You can modify some of the connection properties simply like you're using cx_Oracle.
• You can do basic insert / select / delete etc.
• If you're connecting to database which is on a different machine from python process , you need to install oracle client module in order to use this library. Check cx-Oracle's installation guide for further information.

Documentation

Performance

/* Test platform: */
AMD Ryzen 3700x
Windows 10 LTSC
Oracle 19c
You can find performance test codes here.

Examples

Before running examples , make sure you've already installed a Oracle Client on your machine.

Release historyRelease notifications | RSS feed

0.3.2

0.3.0

0.2.3

0.2.2

0.2.0

0.1.4

0.1.3

0.1.2

0.1.1

0.1.0

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Hashes for cx_Oracle_async-0.3.2-py3-none-any.whl

Hashes for cx_Oracle_async-0.3.2.tar.gz

Cx Oracle Python Install