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
