osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Why Python has no equivalent of JDBC of Java?


On Mon, 20 May 2019 at 17:32, Thomas Jollans <tjol at tjol.eu> wrote:

> Python has a the "Python Database API" (DB API 2.0)
> https://www.python.org/dev/peps/pep-0249/
>

So why Oracle need instantclient for using cx_Oracle? They say they use
DB-API:

> *cx_Oracle* is a Python extension module that enables access to Oracle
> Database. It conforms to the Python database API 2.0 specification
<http://www.python.org/topics/database/DatabaseAPI-2.0.html> with
> a considerable number of additions and a couple of exclusions.

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


On Sun, 19 May 2019 at 23:47, Chris Angelico <rosuav at gmail.com> wrote:

> I've no idea what the hassles are with Oracle, as it's a database
> engine that I don't use. But with PostgreSQL, which I *do* use, I can
> assure you that it's much easier
>

I use Postgres if I can choose, but companies uses Oracle unluckily. Oracle
and MSSQL. And I must say that surprisingly, being a Microsoft product, I
find MSSQL more simple to install than Oracle, like Postregres, and has an
easier SQL syntax.  Like Postgres.