How to implement this ?

When I init the request I need open a connection with the database (and
execute a query for example) and in the end of the request I need close the
database connection.

Another question is: How I know that a database connection is open ?

ps: sorry by my 'dummie questions' and by my terrible english !.

Well,

   I'm trying implement this then in my code.py I have this code:

from model import setDB, unsetDB

def db_handler(handler):
    setDB()
    result=handler()
    unsetDB()
    return result

webapp = web.application(urls, globals())
webapp.add_processor(db_handler)

im my model.py I have this code:

db = web.database(dbn=DBN, host=HOST, db=DB, user=USER, pw=PWD)

def unsetDB():
    print '>>>>>>>>> in the unset <<<<<<<<<<<'
    db = None
    print str(db)

def setDB():
    print '>>>>>>>>> in th SET <<<<<<<<<<<'
    unsetDB()
    db = web.database(dbn=DBN, host=HOST, db=DB, user=USER, pw=PWD)
    print str(db)

but when I look in my system process monitor I still have a opened
connection with database

any idea ?

Por que fechar a conexão?

Normally, for performance, you want to open the connection as soon as you
get a chance and _keep_ it open. What problem are you trying to solve?

Tchau,
Francois

--
Francois Dion
http://solarisdesktop.blogspot.com

    Well, I think that when many visitants access the website (where each
access is a new browser session and a new database connection correct ? )
 this can leave the website slow.

     Actually I still don't know how...I don't understand how the
connections works in web.py, for example, I don't know when the connection
is closed.

    But, thank you so much for your replay.

    Best regards,
    Leandro.

 Friends,

   Any idea ?, tip ? or suggestion ?

Hi Leandro,

Have you monitored your database to see how many connections does it has?
I may be wrong, but I think db connections number aren't related to
sessions number.