[Twisted-Python] db connections

Pet petshmidt at googlemail.com
Tue Mar 24 04:10:17 MDT 2009


Hi,

I've wrote an daemon which does some queries to db and sends response
back to client. Do I need to make for every request from client (new
instance of  MyProtocol) a new connection to DB? Or can I somehow
prepare connection, so I could save some time? Maybe make connection
in Factory and pass it to Protocol? But what happens if too much
clients are connected to server? What is the way to control it?

Regards, Pet


class MyProtocol(basic.LineReceiver):

    def __init__(self):
        print "new connection"
        self.dbcon = adbapi.ConnectionPool("pyPgSQL.PgSQL",
database="data", user='pet', host='local', password='some')


class MyFactory(protocol.ServerFactory):
    protocol = MyProtocol

class MyService(internet.TCPServer):
    def __init__(self):
        internet.TCPServer.__init__(self,PORT,MyFactory())

def main():
    reactor.listenTCP(PORT, MyFactory())
    reactor.run()


if __name__ == '__main__':
    main()




More information about the Twisted-Python mailing list