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

[BMaximus]

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

Originally posted as a Categorized Question.

[jeffa]

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!

[fx]

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...

[Anonymous Monk]

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!