[DB-SIG] PEP 249

[M.-A. Lemburg]

On 16.10.2018 16:37, Mike Bayer wrote:
> AFAIK , Postgresql is the only major relational database that has an
> actual non-blocking protocol.    The other databases all require that
> "async" be simulated in the context of blocking IO.

ODBC does have an async I/O API as well, but I don't know
how wide spread the implementation of this API is among ODBC
drivers.

Python modules talking wire protocol and thus having full
control over sockets could certainly support an async variant
of the DB-API as well.

E.g. we have added async support to mxODBC Connect (which uses
its own wire protocol) via gevent a long time ago and it works
well in that context. We did not introduce any API changes
for this, only a config option to enable support:

https://www.egenix.com/products/python/mxODBCConnect/doc/#_Toc433125695


> On Tue, Oct 16, 2018 at 6:02 AM M.-A. Lemburg <mal at egenix.com> wrote:
>>
>> Hi Nadar,
>>
>> we do have a set of things scheduled for a version 3.0 of
>> the DB API (see the python.org wiki), but nothing related to
>> async I/O yet.
>>
>> FWIW: I think the existing APIs can be used in an async form
>> as well, without having to specify new ones, by simply
>> providing an async entry point at the module level or
>> even making the DB module itself be async only.
>>
>> Thanks,
>> --
>> Marc-Andre Lemburg
>> eGenix.com
>>
>> Professional Python Services directly from the Experts
>>>>> Python Projects, Coaching and Consulting ...  http://www.egenix.com/
>>>>> Python Database Interfaces ...           http://products.egenix.com/
>>>>> Plone/Zope Database Interfaces ...           http://zope.egenix.com/
>> ________________________________________________________________________
>>
>> ::: We implement business ideas - efficiently in both time and costs :::
>>
>>    eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
>>     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
>>            Registered at Amtsgericht Duesseldorf: HRB 46611
>>                http://www.egenix.com/company/contact/
>>                       http://www.malemburg.com/
>>
>>
>>
>> On 11.10.2018 21:48, Nader Hamady wrote:
>>> Hello.
>>>
>>> Reaching out to find out if there have been any discusdions around a 3.0
>>> Database API Specification - Or something broader around async
>>> specifications for dabatase transactions.
>>>
>>> Thanks in advance,
>>>
>>> -N
>>>
>>>
>>>
>>> Hello.
>>>
>>> Reaching out to find out if there have been any discusdions around a 3.0
>>> Database API Specification - Or something broader around async
>>> specifications for dabatase transactions.
>>>
>>> Thanks in advance,
>>>
>>> -N
>>>
>>> --
>>> Nader B. Hamady
>>>
>>>
>>> _______________________________________________
>>> DB-SIG maillist  -  DB-SIG at python.org
>>> https://mail.python.org/mailman/listinfo/db-sig
>>>
>>
>> _______________________________________________
>> DB-SIG maillist  -  DB-SIG at python.org
>> https://mail.python.org/mailman/listinfo/db-sig

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Experts
>>> Python Projects, Coaching and Consulting ...  http://www.egenix.com/
>>> Python Database Interfaces ...           http://products.egenix.com/
>>> Plone/Zope Database Interfaces ...           http://zope.egenix.com/
________________________________________________________________________

::: We implement business ideas - efficiently in both time and costs :::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/
                      http://www.malemburg.com/