I have a question about a Dash app i made.
In this app at the start I have the database name hardcoded, now I would like to make this user selectable.
I have seen the Dash Upload Component (dcc.Upload) but this loaded when the app starts.
Is it possible to select a database file from the dcc.Upload and change the variable “Database” and the reload the app? Or is there a other solution. Its only to get the database name and path in the variable. i Know a varaible is not the best option is dash and is unsafe but its a fully local app. But if there is a better way please…
Hope the question is understandable, if not please say so.
Here the start code:
database = "1234_1234.db" def create_connection(db_file) : try : conn = sqlite3.connect (db_file) return conn except Error as e : print (e) return None conn = create_connection (database) df = pd.read_sql ('SELECT time, Output FROM database', con=conn)
after this there are a couple of pandas data frames loaded with info from the database
and the the application is started
app = dash.Dash (__name__, external_stylesheets=external_stylesheets) app.config['suppress_callback_exceptions'] = True app.layout = html.Div ([