11. 02. 2019.

Performance comparison: Python & cx_Oracle versus SQL*Plus & SQL*Net

In this article I want to check the truth about the slowness of Python language when it comes to retrieving data directly from Oracle database. Second goal is to show graphically impact of changing the array size on performance, which is not possible and convenient to do with SQL*Plus.   Python is widely used as […]

23. 01. 2019.

Python & Oracle Instant Client connection setup on Linux – part 2

In the previous article I’ve described how to install Oracle Instant Client and setup cx_Oracle Python driver correctly. You only need Basic package to install: Version 18.3.0.0.0 Base – one of these packages is required Basic Package – All files required to run OCI, OCCI, and JDBC-OCI applications Download instantclient-basic-linux.x64-18.3.0.0.0dbru.zip (72,794,506 bytes) (cksum – 3435694482) […]

22. 01. 2019.

Python & Oracle Instant Client connection setup on Linux

In the previous post https://www.josip-pojatina.com/en/python-oracle-connection-options/ you can find how to connect to Oracle database by using cx_oracle Python driver, full Oracle Client installation and Red Hat rpm based distribution (Red Hat, CentOS, Oracle Linux, Fedora).  In reality, more than 90% of all Linux servers in a Cloud belongs to Ubuntu (unlike on premise situation where […]

18. 01. 2019.

Python – Oracle connection options

In this blog I’ll present several ways for connecting to Oracle database. As a first step To connect to Oracle database you need to import cx_oracle package. You can think of cx_oracle as Oracle jdbc driver for Java programmers. Since the first public appearance in July, 20017, Oracle is constantly improve Python cx_driver by adding […]

18. 01. 2019.

Python as bash replacement

Even today, on many projects I can still find that many developers are still using bash & Korn shell or even Pro*C as a main tool for developing scripts that will be executed as part of batch job in one of the following ways: Unix/Linux cron Oracle’s dbms_job / dbms_scheduler commercial enterprise job scheduling software […]

16. 01. 2019.

PyCharm and conda virtualenv bug fix

PyCharm is probably one of the most popular IDE for Python developers. There are two main versions: Community (Free) and Professional. In case you are using Anaconda Python distribution for some projects, you already know that conda virtual environment is not applied correctly in terminal window of the PyCharm. As can be seen, python interpreter […]