pony icon indicating copy to clipboard operation
pony copied to clipboard

python-oracledb support.

Open liudonghua123 opened this issue 2 years ago • 2 comments

I see the following documentation on https://docs.ponyorm.org/api_reference.html#oracle.

Pony uses the cx_Oracle driver for connecting to Oracle databases. More information about the parameters which you can use for creating a connection to Oracle database can be found here.

However, the cx-oracle is deprecated, now python-oracledb should be use instead.

Is there any plans for update the oracle driver to python-oracledb.

liudonghua123 avatar Dec 07 '22 07:12 liudonghua123

python-oracledb also has some excellent features like thin mode.

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

https://oracle.github.io/python-oracledb/

liudonghua123 avatar Dec 07 '22 07:12 liudonghua123

@liudonghua123 Do you know how to process CHAR type field in PonyORM. The char type field will add extra spaces at the end of the value if the length of the value isn't up to the field length.

lypch avatar Jan 08 '24 07:01 lypch