Sqlalchemy/Pandas.read_sql_query搭配使用with Dash lobg callback的坑

Mar 6, 2023

--

一、Sqlalchemy回到1.4.31即回到正常
用最新的版本反而不正常（2.0.5.post1）(2.0.0以上都不正長)

二、Dash組合用到long_callback會造成資裡庫多執行緒的現象，要注意執行給予時間才不發生以下錯誤

pymysql.err.InternalError: Packet sequence number wrong - got 45 expected 0

I am trying to connect to mysql database via pymysql. Everything works when I SSH into the database via terminal. So…

stackoverflow.com

三、用Background Callbacks的方式給予動作間相互等待的時間

Background Callbacks

Support for background callbacks on @dash.callback was introduced in Dash 2.6. If you're using an earlier version of…

dash.plotly.com

四、long_callback不可多層，running不會涵蓋到，中間被穿插著啟動執行，資料結果會出問題

Steven Wang

Written by Steven Wang

賣東西是大學問

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams