I need to create a editable data table using SQL DB

Dash Python
1

Hi All, this is my first post, I am new to dash I need to create a data table where user can input value in cell and then I need to compare that value with old cell and if it’s new than I need to save that back to sql db ,I need some reference script for SQL DB so that I can use it for my work.

Thanks in advance

2

Hi @akash1997
:wave: welcome to Dash.

Have you created your first Dash app yet? Do you feel comfortable using the callback and the datatable?

3

Yes I have created the data table and used basic callback for dropdowns but need help in creating callback for saving data into sql db as of now I am fetching data from sql db only using sql query

4

hi @akash1997
this post has code that identifies when a DataTable cell has been updated by user, and it will pull the data of the datable. Then, you would need to create another callback that would save that data inside your database through sql query. Here’s an example of how I write data into a MongoDB from a Dash app. It’s on line 130. This is not SQL query, but I hope this guides you in the right direction.

1 Like