Is there a way to connect mysql while a python application running?

Question

I'd like to make an python application and retrieve query results from mysql server.

So every time when an event happened, the application connect to mysql through mysqlclient like below

# retrieve query result from db
db=_mysql.connect(host="localhost",user="root",
                  passwd="password",db="db")

Is there a way not to try to connect every time but keep the connection?

What the event is? You can connect to database once at the beginning of the python script, and use it after that. If you re-run the python script when every event arrive, it must re-connect to the database. — ElapsedSoul
– ElapsedSoul, Commented Dec 16, 2020 at 6:34
@Sajidshaikh no i didn't. what is that? is there any documentation for connection pooling? — Eric Lee
– Eric Lee, Commented Dec 16, 2020 at 6:51

ElapsedSoul · Accepted Answer · 2020-12-16 07:02:15Z

1

Change

begin loop:
    get MQ msg
    db=_mysql.connect(host="localhost",user="root",
                  passwd="password",db="db")
    db.insert()

to

db=_mysql.connect(host="localhost",user="root",
                  passwd="password",db="db")
begin loop:
    get MQ msg
    db.insert()

answered Dec 16, 2020 at 7:02

ElapsedSoul

8451 gold badge7 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ElapsedSoul Over a year ago

Additional remarks, the connection pool Sajidshaikh mentioned help you to manage the connection like parallel process and re-connection. If you care about the stability of the connection, you can use it.

Collectives™ on Stack Overflow

Is there a way to connect mysql while a python application running?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related