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