osdir.com


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

Why Python has no equivalent of JDBC of Java?


Exactly right. Im not sure why Marco is wondering about native drivers not
to be a part of python module (for oracle).
Id be very unhappy, if a python module come with a native drivers for
something as complex as a database.

Cx guys gave you the power to install what and how your project requires.
In  Microsoft case .. that would be a different discussion :)

On a flip side, if you dont need oracle specific features, then maybe u
should use something basic for data storage. //but thats a different
discussion


On Mon, May 20, 2019, 19:18 Michael Torrie <torriem at gmail.com> wrote:

> 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
> >>
>
> --
> https://mail.python.org/mailman/listinfo/python-list
>