Search code examples
pythonpandas

Does pandas need to close connection?

When using pandas "read_sql_query", do I need to close the connection? Or should I use a "with" statement? Or can I just use the following and be good?

from sqlalchemy import create_engine
import pandas as pd

sql = """
    SELECT * FROM Table_Name;
    """
engine = create_engine('blah')

df = pd.read_sql_query(sql, engine)

print df.head()
Solution

  • Looking at the source code, I can't find a con.close() method on any SQL connection object, only the cursor objects for the queries.

    I'd close for safe-measure. Whether you do that using with or not is up to you.