[Sqlrelay-discussion] sqlrelay connection pooling and postgres

[blair b. <bla...@gm...>]

Hi,

I discovered SQLRelay a few weeks ago and thought it seemed like a
good option for connection pooling a grid middleware application
cluster that I am setting up.  The app is written in python using
postgres and will typically be running several instances for different
users (separate databases) at once.  When I was setting it up however
I noticed this hidden deep in the config info:

"When SQL Relay is used with any other database, it simply logs out
and logs back in as a different user. This is quite inefficient and
defeats the value of keeping persistent database connections."

Does this mean that sqlrelay is actually of no use as a connection
pool server to any DBMS other than oracle?  If so, I think that needs
to be made much clearer on the website.  Or will it try and reuse
connections to the same database when they are available and only
reconnect when there are none available (in which case there is still
some benefit, especially with a large pool)?

Regards,
-Blair

-- 
In science one tries to tell people, in such a way
as to be understood by everyone, something that
no one ever knew before. But in poetry, it's the
exact opposite.
 - Paul Dirac