Are there any best practices for Dash when using a MySQL query?
I would suggest sqlite3. You don’t need to install the module as it is included in the standard library (since Python 2.5). It can read and write concurrently and fast because it uses .wal files. It utilizes the standard SQL syntax and is python compatible so there’s no need of external inclusion like css and js, as needed by Dash.