RFC: new module SQL::QueryQueue

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Looking for comments on the name, as well as the function of this
module proposal.  This will be my first public module submission, of a
module I have developed and used privately for a few months.  The
intention of the module is to provide a FIFO queue for execution of
SQL statements, providing a fault-tolerant, abstraction of the DBI.
During times of lost database connectivity, statements will be queued
while the SQL::QueryQueue object tries to reconnect.  Once a
connection has been reestablished, the queue will resume processing.


use SQL::QueryQueue;
my $queue  = SQL::QueryQueue->instance($db_dsn, $db_user_id,
my $sql = qq { update test set ip = '' where domain
= ?};
$queue->submit_job($sql, 'perlmonks.org');
# in another sub somewhere in your program...
my $q = SQL::QueryQueue->instance();
my $sql = qq{ select * from test where ip like '209.%' };
my $array_ref = $q->submit_job($sql);
foreach my $row (@$array_ref) {
    print join ', ', @$row, "\n";


The SQL::QueryQueue object inherits from Class::Singleton and depends
on DBI.  The current implementation also depends on Log::Log4perl and
Linuga::EN::Numbers::Ordinate, though these dependencies could be

Any comments & suggestions are greatly appreciated.

Michael Peck
mpeck [at] pobox.com

Re: RFC: new module SQL::QueryQueue

On Feb 20, 3:19 pm, mapec...@gmail.com wrote:
Quoted text here. Click to load it

Looks like a good idea, but why the limitation to a single instance?
I've known of applications using multiple connected databases.

Re: new module SQL::QueryQueue

mapeck65@gmail.com schreef:

Quoted text here. Click to load it

See also:
Mailing-List: contact modules-help(AT)perl.org; run by ezmlm

Affijn, Ruud

"Gewoon is een tijger."

Site Timeline