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

BMaximus has asked for the wisdom of the Perl Monks concerning the following question: ⭐ (database programming)

Replies are listed 'Best First'.
Re: What is true database connection pooling and can it be done with Perl?⭐ by jeffa (Bishop) on Jul 20, 2003 at 16:12 UTC
There are a few nodes here about connection pooling. Just search for database connection pool. According to Webopedia, a connection pool is: A cache of database connections maintained in the database's memory so that the connections can be reused when the database receives future requests for data. full definition. Can it be done in Perl? Of course!	[reply]
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
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...	[reply]
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!	[reply]