Why Python has no equivalent of JDBC of Java?

[Marco Sulla]

On Tue, 21 May 2019 at 01:20, Michael Torrie <torriem at gmail.com> wrote:

> On 05/20/2019 04:23 PM, Andrew Z wrote:
> I assume
>

Nope, it requires the instantclient and, on Linux only, also the
installclient-devel package. And a bunch of obscure and terrible settings,
like LD_LIBRARY_PATH...

On Tue, 21 May 2019 at 03:42, Chris Angelico <rosuav at gmail.com> wrote:

> From the sound of
> things, the choice of database back end has already been made, and the
> Python script just has to cope. Otherwise, PostgreSQL would be an
> entirely better alternative.
>

Yes it's that the problem.
Well I love Postgres, but IMHO the big disadvantages over Oracle are two:
BLOBs and performance.

On Tue, 21 May 2019 at 15:14, Paul Moore <p.f.moore at gmail.com> wrote:

> Because a commercial product like Oracle doesn't document
> those protocols, open-source reimplementations are hard, if not
> impossible.
>

IMHO this is the more logical answer to my doubts.

On Tue, 21 May 2019 at 18:17, Dennis Lee Bieber <wlfraed at ix.netcom.com>
wrote:

> It wouldn't surprise me to find that they include the JDBC
> driver layer for Oracle database in the Java package}


It would surprise _me_. Oracle did not even uploaded ojdbc to the maven
repository...

On Sun, 26 May 2019 at 15:37, Bischoop <Bischoop at bischoop.uk> wrote:

> On 2019-05-19, Marco Sulla <mail.python.org at marco.sulla.e4ward.com> wrote:
> >blablabla
> >blablablalbla
> >blablalblalbalblabla
>
> There's no perfect language mate, in some one is easier in other not,
> normal surprised you notice it so late.


I discovered it two years and an half ago, when I started to program in
Java too. Sorry if I didn't had the time to post but I'm working. And sorry
again, I don't know the whole basics of every programming language in the
world. I only programmed in Python 2 and 3, Cython, C, C++, Fortran, Qt,
PHP, Visual Basic .NET, LabView and  Javascript.


On Sun, 26 May 2019 at 19:53, Christian Gollwitzer <auriocus at gmx.de> wrote:

> Python closer to the metal than Java? This is nonsense.
>

Well, it seems to me the majority of python db drivers uses Cython, Python
C API or external C libraries. So in this particular case Python *could* be
more performant than Java. I don't know, you should do some benchmark with
different queries, different in nature, complexity and number of rows
retrieved, on the same db, accessed once with Java and once with Python.
The problem is benchmarking Java not so easy as Python. It's very boring.