Database Connection Pooling

I need to implement a simple connection pooling mechanism for my application.
The problem is I have almost no knowledge working with database connections.
What things should I take into account? Is there any lightweight library out there?
I expect the code to open as few connections as possible.
Was this page helpful?