dbi icon indicating copy to clipboard operation
dbi copied to clipboard

API for asynchronous executiion of statements

Open pali opened this issue 7 years ago • 2 comments

More databases supports either parallel execution of statements or at least their network client API provide asynchronous execution of one statements (via non-blocking socket and poll).

Please define stable API for DBI which would support to asynchronously prepare, execute and fetch result. So DBI application could execute statement in non-blocking mode independently of use DBD driver.

Currently DBD::Pg and DBD::mysql supports asynchronous execution, but both drivers in different way so unification at DBI API level would be useful.

pali avatar Aug 10 '17 14:08 pali

Hi @timbunce! Any progress on this?

pali avatar Jan 14 '18 11:01 pali

I'd be delighted to see a design discussion on the dbi-dev mailing list. Someone needs to drive it towards a workable implementation, perhaps that someone is you @pali :) Perhaps best to start by finding and reading old discussions and posting a summary of whatever parts seem useful.

timbunce avatar Jan 28 '18 15:01 timbunce