CODEWITHSUNDEEP
python-3.xoracle11gcx-oracleoracle19c
Mukul Bindal
Mukul Bindal

Reputation: 433

Can I connect my python script with Oracle database without downloading its client?

I have an old program which uses cx_Oracle with Oracle 11g. This program is not portable as the user need to download Oracle 11g in order to use it. Is it possible to use Oracle database in my script but without downloading it, may be by using any online database?

Upvotes: -1

Views: 249

Answers (2)

Mukul Bindal
Mukul Bindal

Reputation: 433

After reading your problem, What I understood is that you need a portable database. Since your scripts are connected to Oracle 11g with cx_Oracle , I guess you used SQL queries everywhere. I suggest you to use SQLite instead of cx_Oracle if you are in a hurry. Both have kinda similar syntax for executing queries though you may need to modify some keyword. To start quickly refer https://docs.python.org/3/library/sqlite3.html

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 142788

Oracle software can be downloaded from the Oracle Technology Network, here.

If you want to use an online database, Oracle offers Oracle Cloud Free Tier, but I don't think it offers 11g as it is quite old (will be desupported soon). Also, I don't know whether you can (or can not) connect your Python application to it; you'll have to contact Oracle or wait for someone else who knows that info.

Maybe someone hosts 11g, but I doubt that it is for free so - maybe your best option is to download and install free Oracle 11g Express Edition (XE).

Upvotes: 1

Related Questions