luben karavelov wrote:
Hello
I am new to the list. So to present myself. I am mostly SQL/perl/C
developer, Working with DBI since 2001 mostly with Postgresql.
I have written a small framework to handle postgresql async
notifications that is in production here for 2 years. I intend to post
it a CPAN and make it public. So I have some questions.
Is DBI::Listen the right namespace? The module is called DBI::Listen::pg.
Do some other databases have concept of async notifications?
Thanks in advance
Luben
I don't know exactly what postgres async notifications are but I know
DBD::ODBC has limited support for a asynchronous mode which is pretty
useful for picking up debug output etc from procedures.
DBD::ODBC has odbc_async_exec flag which is described as:
Allow asynchronous execution of queries. Right now, this causes a
spin-loop (with a small "sleep") until the sql is complete. This is
useful, however, if you want the error handling and asynchronous
messages (see the err_handler) below. See t/20SQLServer.t for an example
of this.
Not sure if this helps you at all or not but you did ask about other
databases.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com