Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Answer: What is true database connection pooling and can it be done with Perl?

by fx (Pilgrim)
on Jan 03, 2004 at 22:32 UTC ( [id://318550] : note . print w/replies, xml ) Need Help??


in reply to Re: What is true database connection pooling and can it be done with Perl?
in thread What is true database connection pooling and can it be done with Perl?

Can it be done in Perl? Of course!

Although I fully support (and indeed try to practice) the art of giving people pointers to answers and then letting them research the rest, I believe your last sentence is lacking in this case.

I am currently looking for a way to implement a pool of (Oracle) database connections and am hitting brick walls at most corners I turn. DBD::Oracle does not seem to play nicely with iThreads in stark contrast to the documentation, the DBI users mailing list has been unable to help so far, and CPAN lists no (mature / database) pooling modules with the exception of ResourcePool which has iThreads listed under the Limitations section.

Update: Perhaps I'll turn this into a meditation...

Replies are listed 'Best First'.
Re^2: Answer: What is true database connection pooling and can it be done with Perl?
by Anonymous Monk on May 11, 2011 at 14:50 UTC

    One thing you should have in mind is DBI is not thread safe! So, working with 'pure' DBI + threads is a dangerous way because the treatment of this thing will be stay by your own. And believe me! This a very boring task!

    If you're using( or want to use ) some database abstraction, you can search for DBIx::Class namespace. There are various pooling solutions. Google refs

    But if you don't want to use database abstractions, I recommend for you AnyEvent::DBI and/or AnyEvent::Tools CPAN refs .

    Cheers!