[AWS] Persistent database connections

[Maciej Sobczak]

Hi,

Thomas Løcke wrote:

 > All hints and advice are more than welcome. Also in regards to a good
 > database package (PostgreSQL).  :o)

You can try this one:

http://www.inspirel.com/soci-ada/

This library has a direct support for connection pooling in the form 
that can be particularly useful in the event-driven environment like web 
server request handlers.

The documentation provides no usage examples with pools, but the 
concepts are described here:

http://www.inspirel.com/soci-ada/doc/reference.html

Try to find the "Connection pool" string on this page.

In essence, you would create the connection pool with some predefined 
size and explicitly open all connections in the pool before starting the 
web server component - the request handlers will then "lease" the 
connection (session) from the pool and give it back to the pool 
implicitly in the session's finalizer.

The PostgreSQL server is supported properly, aside with Oracle and MySQL.

Regards,

-- 
Maciej Sobczak * www.msobczak.com * www.inspirel.com