Is it required to close python SQL connection in Flask app?

Question

I've the code like this below. Is it necessary to close mysql connection because whenever my home page is requested, a new sql connection will be created?

I randomly get Connection Limit error. But I'm not sure if the DB connection is the problem.

@app.route("Home", methods=["GET"])
def get_home_page():
     db = mysql.connect(host, user, password, db_name, charset='utf8', use_unicode=True)
     ...

Answer 1

It is good practice to close the connection. You can put your codes inside a try..finally block.

@app.route("Home", methods=["GET"])
def get_home_page():
     db = mysql.connect(host, user, password, db_name, charset='utf8', use_unicode=True)
     try:
       ... do something ...
     finally:
         db.close()