You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The latter is just a very small change. When a program runs long enough (i.e. on a server), the connection is held open but MySQL closes them after a few hours. The trick is to create the engine with the pool_pre_ping parameter set to True (see https://stackoverflow.com/a/45078959 ). Please add this.
Also it would be nice to be able to pass not only the db_uri to all functions, but also something like sql_opts where you can specify those engine options as a dict.
The text was updated successfully, but these errors were encountered:
The latter is just a very small change. When a program runs long enough (i.e. on a server), the connection is held open but MySQL closes them after a few hours. The trick is to create the engine with the
pool_pre_ping
parameter set to True (see https://stackoverflow.com/a/45078959 ). Please add this.Also it would be nice to be able to pass not only the db_uri to all functions, but also something like
sql_opts
where you can specify those engine options as a dict.The text was updated successfully, but these errors were encountered: