search

perl5-dbi / dbi

DBI - The Perl 5 Database Interface
Other
83 stars 58 forks source link

API for asynchronous executiion of statements #52

Open pali opened 7 years ago

pali commented 7 years ago

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 commented 6 years ago

Hi @timbunce! Any progress on this?

timbunce commented 6 years ago

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.