Why Python has no equivalent of JDBC of Java?
formisc at gmail.com
Mon May 20 21:08:49 EDT 2019
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
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.
> >> and MSSQL. And I must say that surprisingly, being a Microsoft product,
> >> find MSSQL more simple to install than Oracle, like Postregres, and has
> >> easier SQL syntax. Like Postgres.
> >> --
> >> https://mail.python.org/mailman/listinfo/python-list
More information about the Python-list