Re: Why Python has no equivalent of JDBC of Java?

2019-06-16 Thread Peter J. Holzer
On 2019-06-16 15:45:42 +0200, Marco Sulla via Python-list wrote: > On Tue, 21 May 2019 at 01:20, Michael Torrie wrote: > > On 05/20/2019 04:23 PM, Andrew Z wrote: > > I assume > > It would have helped if you also quoted what Andrew assumed, not just that he assumed something. For the record, he

Re: Why Python has no equivalent of JDBC of Java?

2019-06-16 Thread Marco Sulla via Python-list
On Tue, 21 May 2019 at 01:20, Michael Torrie 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

Re: Why Python has no equivalent of JDBC of Java?

2019-05-26 Thread Christian Gollwitzer
Am 21.05.19 um 14:27 schrieb Adriaan Renting: Java was meant to be generic, run anywhere and abstract and hide differences in its underlying infrastructure. This has led to the Java VM, and also JDBC I guess. Python was more of a script interpreted C-derivative, much closer to the bare metal,

Re: Why Python has no equivalent of JDBC of Java?

2019-05-26 Thread Bischoop
On 2019-05-19, Marco Sulla 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. -- https://mail.python.org/mailman/listinfo/python-list

Re: Why Python has no equivalent of JDBC of Java?

2019-05-21 Thread Paul Moore
On Tue, 21 May 2019 at 13:50, Adriaan Renting wrote: > > > I think it's partially a design philosophy difference. > > Java was meant to be generic, run anywhere and abstract and hide > differences in its underlying infrastructure. This has led to the Java > VM, and also JDBC I guess. > > Python

Re: Why Python has no equivalent of JDBC of Java?

2019-05-21 Thread Adriaan Renting
I think it's partially a design philosophy difference. Java was meant to be generic, run anywhere and abstract and hide differences in its underlying infrastructure. This has led to the Java VM, and also JDBC I guess. Python was more of a script interpreted C-derivative, much closer to the

Re: Why Python has no equivalent of JDBC of Java?

2019-05-20 Thread Chris Angelico
On Tue, May 21, 2019 at 11:10 AM Andrew Z wrote: > > 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. I wouldn't

Re: Why Python has no equivalent of JDBC of Java?

2019-05-20 Thread Andrew Z
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

Re: Why Python has no equivalent of JDBC of Java?

2019-05-20 Thread Chris Angelico
On Tue, May 21, 2019 at 8:25 AM Andrew Z wrote: > > What does 249 specification mention about drivers? > Nothing. PEP 249 defines how a Python app communicates with the database module. For instance: import psycopg2 db = psycopg2.connect("...") with db, db.cursor() as cur:

Re: Why Python has no equivalent of JDBC of Java?

2019-05-20 Thread Michael Torrie
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

Re: Why Python has no equivalent of JDBC of Java?

2019-05-20 Thread Andrew Z
What does 249 specification mention about drivers? On Mon, May 20, 2019, 17:39 Marco Sulla via Python-list < python-list@python.org> wrote: > On Mon, 20 May 2019 at 17:32, Thomas Jollans wrote: > > > Python has a the "Python Database API" (DB API 2.0) > >

Re: Why Python has no equivalent of JDBC of Java?

2019-05-20 Thread Marco Sulla via Python-list
On Mon, 20 May 2019 at 17:32, Thomas Jollans 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

Re: Why Python has no equivalent of JDBC of Java?

2019-05-20 Thread Thomas Jollans
On 19/05/2019 14.27, Marco Sulla via Python-list wrote: > I programmed in Python 2 and 3 for many years, and I find it a fantastic > language. > > Now I'm programming in Java by m ore than 2 years, and even if I found its > code much more boilerplate, I admit that JDBC is fantastic. Python has a

Re: Why Python has no equivalent of JDBC of Java?

2019-05-19 Thread Andrew Z
The pg python lib requires https://www.postgresql.org/docs/current/libpq.html pip pulls it as a part of the lib install, whereas in oracle case you install the driver yourself first.(suize matters) //for some reason i thought the driver libs come as part of cx . But it was a year ago and my

Re: Why Python has no equivalent of JDBC of Java?

2019-05-19 Thread Andrew Z
Marco, You clearly know more about python/java universe than i do. But im infinitely thankful to cx team for putting out the package. Feature and performance wise , even with non supported oracle timesten, it was fantastic. Id always go after "native" vs jdbc. But i understand that most of apps

Re: Why Python has no equivalent of JDBC of Java?

2019-05-19 Thread Chris Angelico
On Mon, May 20, 2019 at 7:34 AM Marco Sulla via Python-list wrote: > > I programmed in Python 2 and 3 for many years, and I find it a fantastic > language. > > Now I'm programming in Java by m ore than 2 years, and even if I found its > code much more boilerplate, I admit that JDBC is fantastic.

Why Python has no equivalent of JDBC of Java?

2019-05-19 Thread Marco Sulla via Python-list
I programmed in Python 2 and 3 for many years, and I find it a fantastic language. Now I'm programming in Java by m ore than 2 years, and even if I found its code much more boilerplate, I admit that JDBC is fantastic. One example over all: Oracle. If you want to access an Oracle DB from Python,