i’m new to Dash so bare with me.
i want to make an application that handles user inputs (numeric & alphanumeric values) , stores the values in database (MSSQL as it is the standard at workplace) and then in same app display visualizations (scatter plots with USL, LSL, avg…)
is this possible using Dash ?
i find very little material about this , especially the MSSQL connection (data push and pull)
anyone can help with this ?
Hi Lo,
you can use everything the Python landscape has to offer. In your usecase, you can use sqlalchemy to handle your database connections, queries and models while handling the user input via regular callbacks. Just keeping in mind - if you have long running queries (longer then 30 secs) that you are going to face server timeouts when in production. For that you can use background callbacks.
Hope this helps
If I find the time over the weekend I’ll provide a simple example using a database with sqlite3, if this could be helpful.
I’m pretty sure @adamschroeder has an example of using sqlite3. 
Unfortunately, I don’t have an sqlite3 example. I wrote something with mongoDB once. If you think that would be helpful, @Lo96 , I can dig it up.