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

Why Python has no equivalent of JDBC of Java?

On 05/20/2019 04:23 PM, Andrew Z wrote:
> What does 249 specification mention about drivers?

Nothing that I can see.

But it stands to reason that at some point the Python code is going to
have to interface with the SQL database server's API. And when the
database in question is proprietary, the original poster should probably
not be surprised that a special driver install is required. I assume
it's also required for JDBC also, but since Java is owned by Oracle,
they probably install such things automatically.

> On Mon, May 20, 2019, 17:39 Marco Sulla via Python-list <
> python-list at python.org> wrote:
>> 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.
>> --
>> https://mail.python.org/mailman/listinfo/python-list