SQLAlchemy: Creating vs. Reusing a Session

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

Just a quick question: SQLAlchemy talks about calling sessionmaker() once but calling the resulting Session() class each time you need to talk to your DB. For me that mean s the second I would do my first session.add(x) or something similar, I would first do

from project import Session
session = Session()

What I did until now was to make the call session = Session() in my model once and then always import the same session anywhere in my application. Since this is a web-applications this would usually mean the same (as one view is executed).

But where is the difference? What is the disadvantage of using one session all the time against using it for my database stuff until my function is done and then creating a new one the next time I want to talk to my DB?

I get that if I use multiple threads, each one should get their own session. But using scoped_session(), I already make sure that problem doesn"t exist, do I?

Please clarify if any of my assumptions are wrong.

👻 Read also: what is the best laptop for engineering students?

SQLAlchemy: Creating vs. Reusing a Session __del__: Questions

import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.

import time
while True:
    print("This prints once a minute.")
    time.sleep(60) # Delay for 1 minute (60 seconds).

from time import sleep
sleep(0.1) # Time in seconds

SQLAlchemy: Creating vs. Reusing a Session __del__: Questions

We hope this article has helped you to resolve the problem. Apart from SQLAlchemy: Creating vs. Reusing a Session, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

• Italiano SQLAlchemy: Creating vs. Reusing a Session
• Deutsch SQLAlchemy: Creating vs. Reusing a Session
• Français SQLAlchemy: Creating vs. Reusing a Session
• Español SQLAlchemy: Creating vs. Reusing a Session
• Türk SQLAlchemy: Creating vs. Reusing a Session
• Русский SQLAlchemy: Creating vs. Reusing a Session
• Português SQLAlchemy: Creating vs. Reusing a Session
• Polski SQLAlchemy: Creating vs. Reusing a Session
• Nederlandse SQLAlchemy: Creating vs. Reusing a Session
• 中文 SQLAlchemy: Creating vs. Reusing a Session
• 한국어 SQLAlchemy: Creating vs. Reusing a Session
• 日本語 SQLAlchemy: Creating vs. Reusing a Session
• हिन्दी SQLAlchemy: Creating vs. Reusing a Session