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 <torr...@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@python.org> wrote: > > > >> On Mon, 20 May 2019 at 17:32, Thomas Jollans <t...@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 <ros...@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 > -- https://mail.python.org/mailman/listinfo/python-list
