[DB-SIG] PEP 249

[Nader Hamady]

This is actually a lot of good info, thanks a lot for following up.

Wasn’t aware of the new db api version, but will follow along.

Just to clarify, I’m coming from the background of building an in house orm
that attempts to abstract some of the async features provided by different
db modules (i.e pyodbc/oracle_cx). In the process of doing so, we noticed
that different modules had different implementations for connection pooling
and making async calls. Made me wonder if the new db api version was
intended to standarize this.

Happy to get involved if there’s an apetite for it.

Nader




On Thu, Oct 18, 2018 at 09:07 Mike Bayer <mike_mp at zzzcomputing.com> wrote:

> On Thu, Oct 18, 2018 at 5:46 AM M.-A. Lemburg <mal at egenix.com> wrote:
> >
> > 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.
>
> right, unusual though that given async's intense popularity in Python
> right now, I haven't seen any drivers doing this with say, MySQL,
> which you would think would be the most obvious target, considering
> there are multiple pure-Python drivers already.
>
> >
> > 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:
>
> Well, "gevent" unfortunately does not count with the "async" crowd
> these days, I agree it's the easiest way to get at non-blocking
> behaviors but Python's asyncio is all the rage right now and it
> requires very dramatic API changes.
>
>
> >
> > 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/
> >
>
-- 
Nader B. Hamady
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20181019/3181d327/attachment.html>