I’ve been trying to incorporate a SQLite database into a Dash project I’m working on. I have a DataTable where a user is able to edit values in one of the columns. What I want to do is have the new values the user enters update values stored in my SQLite database through a callback on the ‘data’ and ‘columns’ attributes.
This approach works for me, as I can see the changes when querying the database outside of dash, and the updates stick once I reset my Dash application and run it again. For whatever reason, the updates seem to get wiped whenever I refresh the page, and when querying the database outside of Dash, any updates I’ve made seem to be reverted to what the original values were.
Has anyone run across this scenario before, and figured out a solution or workaround?