> Hi,
>
> I know aolserver comes with postgres support, but I would like to use
> the Pgtcl library for a project.
> Has anybody managed to use Pgtcl and keep a persistent connection to
> the database that can be re-used by the requests coming in, or do you
> have to keep opening a connection to the db, query the db then close
> the connection for every single request?
>
Just curious, why use pgtcl instead of the underlining db api in aolserver?
Note that I am one of the maintainers of pgtcl (at least one of theversions),
and I don't use it within aolserver. I don't think it hasbeen proven that pgtcl
is thread safe...so I don't know what kind oftrouble you will get in (although
it's on my list to make it so).
Given that, I don't think you want to share connection/resulthandles across
connections, so you would want to connect/disconnectevery time, just to be
safe...although you could give it a try to seewhat happens...
I know people who use pgtcl from Apache + mod_tcl, but Apache is a different
environment.
HTH,
--brett
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.